Getting LEAD and LAG values manually
LEAD and LAG functions are new in SQL Server 2012 , This short Script could be used to get these values in Earlier versions also
2016-06-28 (first published: 2016-05-18)
763 reads
LEAD and LAG values manually
The OLE DB Command Transformation
Comments posted to this topic are about the content posted at http://www.sqldts.com/default.aspx?309
2004-10-15
2 reads
RE: Set Options
The only way I know of right off is thru a trace. Using Profiler look at the event unde TSQL "SQLStmt:Starting" and if using SQL 2000 you can filter the TextData with like "Set" to watch only for that.
2004-10-14
Blogs
SQL Saturday Boston 2024 Slides
By Steve Jones
Thanks to everyone that came to my talks. Slides are below. Best Practices for...
Small Data SF 2024
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
A New Word: Moledro
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
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