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)
488 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)
437 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)
751 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,717 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)
1,579 reads
Blogs
SQL on-demand in Azure Synapse Analytics
By James-Serra
The new SQL on-demand (to be renamed SQL serverless) offering within Azure Synapse Analytics...
My First Hand-built AWS CodePipeline
I’ve just completed my first, successful, AWS CodePipeline. I’m sorry to say it took...
Fixing Broken Pip
By Steve Jones
I’ve got Python 3.8 on my machine, and recently I got a note that...
Forums
Using Begin Tran for a select statement?
Hello All I have an overly complex SELECT statement that I am married to...
Exclude square bracket and text from start or end of string
Hi, I want to remove square brackets and text from either start of string...
MCSA Certifications - SQL2016
Dear all - Firstly apologies if my post isn't specifically for this particular forum...
Ask SSC