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
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
2014-01-28 (first published: 2013-01-16)
2,222 reads
This script will generate a report providing all normally expected statistics for data Profiling .(ie.. Min, Max, Unique Count, Pattern etc....)
2014-02-12 (first published: 2012-05-21)
4,035 reads
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
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
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
Ray -Since there is no clustered index on this table, I would assume that data rows are stored sequntially. Regardless of what is in my select statement, as long as I have the right where clauses, the query engine should use index seek to get to the addresses of the desired rows and then get the information […]
2004-03-18
I thought this was pretty tough also since it was an undocumented DBCC. But I luckily guessed the right thing knowing how most of the DBCC commands are worded. Have a good day!Pat
2004-01-20
quote: what I am talking about is that you can CREATE the FORMAT file not the DATA file every time before you import. Oh, I see. Thanks a lot for the clue! Sabina
2003-12-03
1 reads
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers