I have not. Do you have an example of connecting to ADSI with ADO.NET?

lmu92's comments got me going in the right direction. Executing the CTE query worked except that I had more than one years worth of tickets in my production table...

Thanks but that doesn't get me what I'm looking for. I don't need a running total for every ticket. Just at monthly intervals, maybe weekly would be nice. ...

Modifying the SQL Agent job to check for rows would be a challenge since my datasource for my reports is not the same server as my SSRS database. It...

It appears you can't specify a username and password while using a trusted/integrated security connection string.

Data Source=myServerAddress;Initial Catalog=myDataBase;Integrated Security=SSPI;

So what I had to do was create an application pool to...

I have an additional question about this. Now what if I wanted to create a table of users so I could see if one of my users had both...

I have a 64 bit SQL server but could not get a 64 bit ODBC to connect to Informix to save my life. When I get time I'll have...

Sure, let me elaborate. The Informix data is from a help desk application. The data itself are help desk tickets. But I am only concerned about the...

By the way this worked great on my SQL 2005 server but I had a SQL 2000 server that was appearently not compatible with Common Table Expressions. So I...

Ah that did the trick. Thanks so much for the help!!!

Thanks for the reply. It did get me the results I need but now that I try to get the date in there where I can add query for...

I just thought stored procedures where the way to go.  I'm all the time hearing about how they are supposed to improve performance but everytime I go to try and...

My goal was to simplify things and most importantly increase the speed of my querys.  Currently I'm not using stored procedures.  My statements have become complex with table JOINs.  And once...