How to Format Dates in SQL Server (Hint: Don’t Use FORMAT!)
Here's why you should NEVER use the FORMAT() function in SQL Server.
2022-08-05
17,846 reads
Datetime conversions
How to Find the Start and End Dates for the Current Week (and more)
Learn to calculate Start / First of Week, End of Week, Start of Next Week, Year, Quarter, and Month of the week, Week Numbers and more in T-SQL (Jeff Moden)
2022-07-13
15,636 reads
Convert GMT/UTC to Local datetime
International Applications require timezone handling for different users Here is how to do this with SQL.
2009-05-06
2,840 reads
Blogs
A New Word: Ghough
By Steve Jones
ghough – n. a hollow place in your psyche that can never be filled;...
T-SQL Tuesday: Encryption and Data Protection
I have the honour of hosting this month’s T-SQL Tuesday. In case there’s any...
Parameterize your Databricks notebooks with widgets
Widgets provide a way to parameterize notebooks in Databricks. If you need to call...
Forums
Report server login issue
Trying to deploy reports in visual studio 2022, reporting service login is asking for...
Opening and closing with date filter is not giving me correctly output
I want ,when Opening_value and Opening_Date exist in tabel #tbl_Account_L_Four ,then opening_Value will be...
Report server login issue.
Trying to deploy reports in visual studio 2022, reporting service login is asking for...
Ask SSC