A Flexible Day Of Week Function
A Flexible Day Of Week Function where a criteria can be passed as an integer to a stored procedure.
2010-10-13 (first published: 2010-10-06)
1,371 reads
Todd Young
Blogs
One Thousand SQL Saturdays (*ish)
By Steve Jones
This weekend is SQL Saturday #1000, running virtually from Oregon. It’s a good schedule,...
Top Azure Synapse Analytics and Power BI questions
By James-Serra
I have listed below the top questions I see from customers about Azure Synapse...
Pre-Conference Workshop and Sessions at PASS Summit
I’m pleased to announce that I will be presenting at PASS Summit. This year...
Forums
ROWLOCK UPDLOCK - Locks whole table
Hi All I came across the following query on one of my systems. SELECT...
Index scan
Hi, I have a query as below: ;With P As (Select ProductID --Query that...
why cannot use ClientProcessID to trace data in SQL Server Profile.
A C/S system is running on a SQL Server database, and I get its...
Ask SSC