SQLCMD Mode; Run all SQL files in a directory

SQLCMD Mode gives you the ability to access command line executables via SSMS. Using creative approach, you can automate the execution of all files within a specified directory.

Create MERGE statements with data!

A script to create MERGE statements with data for specific tables.

ANSI_PADDING

OUTPUT & NEWID()

Dynamically name report/file export in SSRS

Wouldn't it be nice if you could have the report's name and filename be changed to something more specifically related to the particular run of that report.

Data Driven Subscriptions for Reporting Services (2000 and 2005)

Reporting Services has proven to be one of the more useful subsystems of SQL Server. However the standard editions of both SQL Server 2000 and SQL Server 2005 have limitations with regard to the subscription features. Jason Selberg brings us an updated version of his
code for extending the subscription feature.

Data Driven Subscriptions in SQL RS Standard

As many of you know, data driven subscriptions is not a feature available with SQL 2000 RS Standard Edition. However, you can accomplish this using the supplied stored procedure. It may not be as pretty as the version in SQL Enterprise, but this one gets the job done, and it is very ……useful!I have not […]

Data Driven Subscriptions

Reporting Services is a great subsystem for SQL Server that fulfills quite a few needs. However just like SQL Server, there are some features that are limited to the Enterprise Editions, something that not every user can afford to implement. New author Jason Selburg brings us a way to implement subscriptions to reports using Standard edition.