Expand Template with Values from Result Set
This stored procedure extracts template variable names and values from a SQL result set in order to process the template.
2016-10-13 (first published: 2016-09-14)
338 reads
template processing
RE: Date Comparision of the Month Part
If I see this right, you want to query for a specific month, right?If so, why extract dateparts and convert anyway? You could also query for something like this:WHERE < your date > >= DATEADD(MONTH,DATEDIFF(MONTH,30,GETDATE())-2,30)+1 AND < your date > < DATEADD(MONTH,DATEDIFF(MONTH,30,GETDATE())-1,30) +1That example above would query the previous month. You might need to tweak this […]
2004-11-23
RE: Remote SQL Server Administration
My recommendation is to use Microsoft Terminal Client. It's better than PCA, you can have multiple connections, and the Remote server can still be locked while you access it from here.I used to control many servers in Saudi Arabia from Sri Lanka with a 128k line without any problem.you can also copy and paste easilty […]
2004-11-15
RE: Adding Column to a Table with Desired Order
I realize position doesn't affect anything and EM is not an option for me.Here is a script I found that reorders columns in sequential order. I thought someone has the script to do more.How to Fix Inconsistent Metadata ErrorsWhy does changing a table on a SQL Server 7.0 server cause "OLE DB provider 'SQLOLEDB' supplied […]
2004-11-12
Blogs
Simple Talks Episode 7
By Steve Jones
The season 1, seventh episode of Simple Talks is out. Check it out, with...
A New Word: the McFly effect
By Steve Jones
the McFly Effect – n. the phenomenon of observing your parents interact with people...
Key mappings in Visual Studio Code
At a recent conference I was asked how I executed code during my presentation....
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers