2022-05-20 (first published: 2019-02-05)
3,099 reads
Mike Tanner
2017-09-19
1,053 reads
2016-11-04
1,520 reads
Converting to data-driven code
How converting extensive, repetitive code to a data-driven approach resolved a maintenance headache and helped identify bugs
2015-03-16
6,637 reads
2012-10-24
2,242 reads
Blogs
Daily Coping 31 Jan 2023
By Steve Jones
Today’s coping tip is to take a small step towards and important goal. One...
Tales From The Field Weekly Wrap Up for the Week of 01-23-2022
By SQLBalls
Hello Dear Reader! It's been a while since I had time to sit down...
CONCAT_WS Function Truncates Text
I was writing some dynamic SQL that generates some SQL statements to load my...
Forums
parameterizing a sql server connection
I am parameterizing an sql server connection. There are the following fields: username password...
'DATE' is not a recognized built-in function name
Please assist. I am getting the above error: CREATE VIEW DailyAccountBalances AS SELECT DATE(TransactionDate)...
SSIS Sort Alphanumeric?
Hello, I'm pretty new to SSIS, but I have an Excel source that I...
Ask SSC