Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Guest Columnist: Sloan Holliday

SQLServerCentral.com profile

   Items 1 to 3 of 3   
 

The Zero to N Parameter Problem (Sql Server 2005 and Up -- Update)

This article uses XML to deal with optional parameters along with multiple parameter passed into a stored procedure. (Note: We are re-running this as we had a newsletter issue last week)  Read more...
By Sloan Holliday 2013/12/16 (first published: 2013/12/10) | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 7,142 reads

The Zero to N Parameter Problem

T-SQL has some well known limitations when working with parameters for a stored procedure, not the least of which is a variable number of parameters. While there are some solutions, they can be cumbersome to work with. Sloan Holliday brings us a creative solution using XML that can solve many issues.   Read more...
By Sloan Holliday 2006/02/28 | Source: SQLServerCentral.com | Category: stored procedures
Rating: |  Discuss |   Briefcase | 11,764 reads

Leveraging XP Excel , XML, and OPENXML for Data Imports

DTS is a fantastic ETL tool and it is often used to import Excel documents. However this can be a manual process in many cases in setting up the package. New author Sloan Holliday brings us a way that you can leverage Office XP's automation facilities and XML to import data into SQL Server.   Read more...
By Sloan Holliday 2005/11/22 | Source: SQLServerCentral.com | Category: dts
Rating: |  Discuss |   Briefcase | 10,640 reads
   Items 1 to 3 of 3