SSIS Package documentor
Read and document multiple SSIS packages in an Excel file. The document can be used to do further code analysis.
2016-11-04 (first published: 2015-09-01)
14,537 reads
Divya Agrawal
Finding the Correct Weekday Regardless of DateFirst
In this article, learn how to get the correct weekday regardless of the DateFirst setting on your server.
2010-02-19
9,259 reads
Problem with scripting objects through query
This article from Divya Agrawal might help you to overcome the problem when multiple objects or statements are scripted together. This is technique that can eliminate errors from scripts built dynamically.
2009-10-30
1,953 reads
Compatibility issue and CROSS APPLY
This article would help to solve a strange error dealing with compatibility issue while using CROSS APPLY
2009-08-06
5,574 reads
Split string using XML
Learn how you can split a delimited string in a single query using XML with Divya Agrawal.
2009-06-25
14,177 reads
Execute SQL job through batch file
This article will show you how you can execute a SQL job with one click, allowing anyone to do this. Author Divya Agrawal shows a technique to let other users run jobs that do things such as perform a backup with a batch file.
2009-06-05
19,407 reads
2009-05-25
1,059 reads
Calculate the Running Total for the last five Transactions
Calculate the Running Total for the last five Transactions on an Iterative basis
2008-11-27
4,763 reads
Compare Dates in an iterative manner for a particular set of records
Compare Dates in an iterative manner for a particular set of records in a single query using SQL Server 2000
2008-11-12
3,831 reads
Blogs
Career: Talk To References
By Steve Jones
As we try to get through these strange times in the world, I am...
This Saturday: #DataWeekender, DataSaturday Southwest
By Will Assaf
Geeked to be speaking 2x on Saturday May 14, my second time speaking at...
Daily Coping 14 May 2021
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Forums
Why doesn't the Secondary failover?
Hi, I hope someone can help. I will try to summarise as best as...
How to rewrite sql query after where condition with another query ?
I work on sql server I need to rewrite statement after where statement so...
Incorrect syntax near the keyword 'AS'
Hi Everyone. I'm hoping someone can take a look at my code here to...
Ask SSC