You say ID is unique.  So after inserting the row into TableB and doing other updates, do you need to check the Status again before deleting?  It's only going to...

Have you even tried the sample code you posted?  Because it sure looks to me that it will fail the integrity constraints.

I'm confused.  What is the point of creating an order if you don't have a customer who ordered that order?

Tables don't "automatically update" by themselves.  (Egad, would that be a mess if they did!)  You need something to make the table update.

Usually that would be a stored...

Would a simple IF/THEN/ELSE structure suffice?

IF @status = 'Y'
BEGIN
       Select Top 500 COUNT(*) OVER() TotalRows, Column1, Column2 from table
END
ELSE

I want my points back.  This question was as badly conceived as the other coffee card question a couple weeks ago.  The only reasonable answer is to use FLOOR(ABS(n)), and...

Do any of these file formats have an industry "standard"?  I ask because I used to work in a finance company and there were a fixed number (unfortunately more than...