Here is what would greatly help getting you what you are requesting, DDL (CREATE TABLE statement(s)) for the table(s) involved, sample data (a series of INSERT INTO statements (some people...

Run sp_who2 at a minimum?

In simple terms, wrap the three steps in an explicit transaction.

BEGIN TRANSACTION

step 1;

step 2;

step 3;

COMMIT;

There may be more to this if you are looking at adding any kind of error...

This:

select datename(weekday,getdate())

For more information:

http://msdn.microsoft.com/query/dev10.query?appId=Dev10IDEF1&l=EN-US&k=k(DATENAME_TSQL);k(SQL11.SWB.TSQLRESULTS.F1);k(SQL11.SWB.TSQLQUERY.F1);k(DevLang-TSQL)&rd=true

The Dixie Flatline (3/6/2014)

---

But when semicolons are required between statements as separators, it would just be so EASY to start each new statement with a semicolon. Besides,...

wendy elizabeth (3/6/2014)

---

In existing t-sql 2008 that I need to modify, there is already an existing cte that looks like the following:

;WITH rCust AS ( SELECT CustuserSK] ...

Glad to hear it worked out.

Based on what you have posted, really can't provide much help.

Please read the first article I reference in my signature block below. Following the instructions in it regarding the...

Using a trigger will allow you to audit changes to the table whether the update/insert/delete occurs from a stored procedure or SSMS.

Have you looked at CDC as an audit solution...

After reading Jeff's post, just a couple of minor changes and my code returns the same results.

--===== If the test table already exists, drop it

IF...

Give this a try:

--===== If the test table already exists, drop it

IF OBJECT_ID('tempdb..#history') IS NOT NULL

DROP...

pixeldude (2/28/2014)

---

Thanks for the compliment. I appreciate the help and I'm happy to provide whatever you need/want to help me. 🙂 I didn't want to quote your...

Count me in, whether I am State side or in Afghanistan. I think I'll go back to what works for me though, and skip the draft. 🙂

Count me in for the next two years.

It was a great time...