In this post, I will discuss on how to optimize join. Based on my experience. When you join record you need to join as fewer as possible otherwise it will result in performance. And please make…
I was having a problem this morning in using a ORDER BY in UNION Clause. The solution is to use keyword of “TOP 100 PERCENT” on the related ORDER BY SELECT query. CREATE PROCEDURE MyAPLRank @MemberID…
This is the function in SQL server to get the last day for each month until the day that you define in a variable which is in this case is “@genDate”. I used this function to…
This is the sample of cursor solutions, i will add the explanation a bit later CREATE PROCEDURE AutoSumEventMembers AS SET NOCOUNT ON; /*This stored procedure is used to update the number of players played on the…