Function to pad Bigint with leading zeros or other single characters
Function to pad bigint with leading 0's or other single character
2019-10-31 (first published: 2019-10-23)
634 reads
Shane Clarke
Function to convert UserAccountControl number to details text
Function that converts AD UserAccountControl number to details text
2019-04-15 (first published: 2019-04-12)
492 reads
Function to Round or Truncate DateTime
This Function is used to round to Second, Minute, Hour or Day or to Truncate to Second, Minute, Hour, Day, Month or Year and return Datetime Value
2017-05-31 (first published: 2017-05-23)
2,979 reads
Function to calculate and return age in text to closest minute between
Calculates and returns age in text to closest minute between 2 datetimes, eg: 2 Years, 4 Months, 12 Days, 4 Hours, 17 Minutes
2016-08-12 (first published: 2012-05-17)
1,725 reads
Function to convert UserAccountControl number to details text
Function that converts AD UserAccountControl number to details text
2015-07-27 (first published: 2013-05-14)
2,266 reads
Blogs
Daily Coping 3 Feb 2023
By Steve Jones
Today’s coping tip is to ask other people about things they’ve enjoyed recently I...
Daily Coping 2 Feb 2023
By Steve Jones
Today’s coping tip is to challenge negative thoughts and look for the upside. I’m...
Deadline for Microsoft MVP contributions is 20 March 2023
Since changing to the new MVP renewal model, Microsoft MVPs have had until 31...
Forums
Can an INSERT statement block SELECT statements?
Hi All, Can an INSERT statement block SELECT statements? not sure why ? Can...
Extended Events to capture query causing tempdb log to get full
Hi! How\Steps to setup Extended events to capture query causing tempdb log getting full?...
How to append data to the previous row
Hi, I have a table that stores event transactions, the sample data see the...
Ask SSC