Create a pivot Table similiar to Microsoft Access Pivot Command, Specify if there should be totals at the bottom, right or both..Uses a temporary table to hold the values..Bad part is the SQL that is generated can have no more than 4000 Characters..If not using any NVARCHAR characters, could make the sql up to 8000 […]
2002-11-18
2,007 reads
By Steve Jones
I was asked about state-based deployments in Flyway Teams, so I decided to show...
By Steve Jones
The main thing is to keep the main thing the main thing. – from...
When Covid took out the PASS organization, I had someone say to me, “Well,...
Comments posted to this topic are about the item Dynamic T-SQL Script Parameterization Using...
I have a SSRS report for which users are complaining to be slow, but...
Hi I set this up today. I wanted to get some feedback. I have...
What do these two selects return?
SELECT BIT_COUNT (CAST (-1 as smallint))
, BIT_COUNT (CAST (-1 as bigint))
See possible answers