snippet designate a certain time of the day in getdate()
Snippet to designate a certain time of the day to evaluate in the current day. If you need to limit a...
2013-04-23
350 reads
Snippet to designate a certain time of the day to evaluate in the current day. If you need to limit a...
2013-04-23
350 reads
Intellisense can be a boon to adding quick development. Quick hints on scope specific variables, syntax suggestions, function descriptions and...
2013-04-22
904 reads
Dynamic SQL can be helpful, but a pain to debug. I spent hours today working on figuring out why my...
2013-04-18
408 reads
Populating default dates in SSRS can be helpful to save the user from having to constantly input the date range...
2013-04-18
84,375 reads
By HamishWatson
This blog post is about a situation where you are capitalising an argument in...
By HamishWatson
This blog post relates to where you might be doing scale operations of your...
By HamishWatson
This blog post is about a situation where writing an IF THEN ELSE statement...
Create TABLE #TableA ( TaskNameA nvarchar(100), GovernA bit, ToolTypeA nvarchar(10), ResourceNameA nvarchar(100) ) Create...
I am trying to the code function to determine if a particular application is...
I am trying to patch my SQL server with CU8 and GDR for SQL...