ORDER BY in UNION
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…
-
-
Getting the last day for each month in SQL server
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…
-
Failed to enable constraints, one or more rows contain values violating non null, unique or foreign-key constraints
I found this error on my project. Well i spent around one hour to figure out this problem. People might think that this is some silly error message. The error message i got is “Failed to…
-
Cursor Tutorial in SQL Server
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…