Filed under Useful T-SQL

SSIS Date Time Issues with Parameterized Queries

We ran into a major issue with Integration Services, which caused us a major scare, so I wanted to share it. We had a query, which was pulling out a list of items to compare to determine what to load. This list was generated with a simple query, where the date was calculated like this: … Continue reading


Dynamic Pivot Table SQL Server 2008

We have a scenario where we need a dynamic pivot table from SQL data. I’m going to try and make this generic, so if there is confusion, please let me know. The scenario: We have a parent database and a child database. The child database has “attributes” for the parent database with values. SQL to … Continue reading

Logon Auditing in SQL Server

Currently at our business, the need for auditing Logons to a server, and some basic activity has came up recently. While the solution below was not implemented in our corproration. This is an elegant solution for a small SQL Server farm, with only a few instances of SQL Server. Some people may chose to do … Continue reading

Reporting Services 2005/2008 Job Lookup

Ever needed to manually run a report from Reporting Services, following the rules of a subscription, but don’t want to go through the effort of editing an existing subscription, letting it run, then editing it back or creating a new one? The following T-SQL Statement, when ran against the Reporting Services Database will allow you … Continue reading