Your best option would be to use a tool that is built specifically for this. Melissa data (http://www.melissadata.com) is one of the better recognized providers.

They have the ability to...

Since you are on SQL Server 2005 - you might want to look into using synonyms instead of using the four-part naming convention in your code. I would recommend...

Yeah - I...

antonio.collins (12/3/2008)

---

Jeffrey Williams (12/3/2008)

---

Is this what you are looking for?

;With history (regid, status, history_date, rn)

As (Select reg_id

,status

...

Your data file is restricted - what is the max size allowed? What is the auto-growth increment? How large is the transaction log (goes to determine how much...

Is this what you are looking for?

;With history (regid, status, history_date, rn)

As (Select reg_id

,status

...

Tempdb will grow as large as is needed to support the queries being run on your system. Once the database has grown - it will not shrink until you...

Bummer - my new slingshot is back-ordered. Should be available and delivered in the next 6 to 8 weeks, shipping & handling charges extra (of course) :hehe:

If the only thing the process is doing is inserting data into table variables and/or temporary tables, and then selecting from those tables - then there is no reason to...

Review the following:

Select dateadd(month, datediff(month, 0, current_timestamp), 0)

,dateadd(month, datediff(month, -1, current_timestamp), -1)

,dateadd(month, datediff(month, -1, current_timestamp) -...

Naw - have plenty of pork chops, I just need something to sling them with :w00t:

One thing you can try is adding a clustered index to those tables. Once the clustered index has been built, you could then remove it if you really need...

I am still curious as to why you need to know if a parameter was passed in or not. It really shouldn't matter.

No way that I am aware of. Why would you need to know that information anyways? If you are going to do something different based upon whether or...

Also verify what level you are at in Object Explorer. You will see different reports available based upon where you are at. For example, you will see the...