Posts by Michael Rodrigues • 11 points
2 posts
-
0
votes4
answers27603
viewsA: SQL - Calculate percentage in the same select
Example in SQL SERVER: SELECT DISTINCT PerformanceRating Metric ,COUNT(*) OVER(PARTITION BY PerformanceRating) Quantity ,ROUND(((CAST(COUNT(*) OVER(PARTITION BY PerformanceRating) AS…
-
1
votes1
answer282
viewsQ: Tempdata works on Localhost but doesn’t work when published
Thank you in advance for your attention! I am developing in ASP.NET MVC5 What happens is this: when the tests are carried out in the localhost, this code works perfectly. I can retrieve the tempdata…