We are going through SOX as well.  Have already implemented a lot of "SOX" items.  SOX for our company includes but is not limited to:

SOX, HIPAA, Segregation of duties, Plain...

Have you looked at the WHERE you call this from to ensure that this is not in a loop???  I don't see anything wrong with the SP.

I have found (personal experience) that when you declare a variable as VARCHAR() without telling it HOW LONG then it will DEFAULT to VARCHAR(1).

Try telling the system how long you want the...

As your query is currently written you will get a "random" customer every time you do the following:

1.  Give me approx 1 million customers

2.  Ok now rerun #1 and give...

Ok, I'll bite.  You are 1st looking at approx 1 million records and grouping them.  Next you are saying out of that I only want where rownum is less than...

Sounds like IF you leave the ON DELETE CASCADE you will wind up in a viscious endless loop.  I would look and see if there are triggers that are already...

Probably the easiest way is to create a job and have it scheduled daily to either A.  run a stored procedure with the code or B.  run a DTS package...

I guess I need to ask the question...  IF you understand that the ID may skip numbers for various reasons "What is the burning desire to NOT skip numbers"?

You cant do that HOWEVER you can use a user defined function like that.  See BOL for more information

If you are already building dynamic SQL why not add

+ CHAR(34) + around credited ?  May take some work but this should help...

I would start by contacting RedGate http://www.red-gate.com and see if any of there VERY inexpensive pieces of software can help you.  They are very friendly and helpful as well.

Read up in BOL about DTSRunUI.  This will talk about the different parameters that you can configure for this...

Prior to shoveling the poop up and throwing it away...

I would have your customer look at task manager and see if anything has run away and/or there are a lot...

Steve,

You are absolutely correct, there are multiple different types of DB-types out there.  Some of the types you listed could be considered flat-files as well.  I was just trying...

I didn't think you could have a RETURN in anything other than a stored-procedure??