sp_wcProject
A stored procedure which provides wildcard column selections plus some additional bells and whistles
2009-02-03 (first published: 2009-01-28)
849 reads
Anthony Zackin
Two scripts to spell out numbers in words
These SQL functions will allow you to convert decimal numbers to words
2009-02-02 (first published: 2009-01-22)
1,655 reads
Blogs
Daily Coping 18 Sep 2020
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Optimize for Unknown for Inline Table-Valued Functions
I had a curious performance issue today. An inline table-valued function (iTVF) was performing...
Daily Coping 17 Sep 2020
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Forums
How to create a minimal tally table and to describe its advantages (if any)
What is the minimal way to create a tally table/tvf/cte and to describe its...
Need some help with log file
I have an issue with a log file which I am trying to solve....
Querying a table to get the columns with values
Morning, i have a table with over 100 columns and i need to query...
Ask SSC