Nice complicated question. I could do it easily putting two select statement (order & ordertable), before and after delete command. Scored 1 mark.

Scored 1 mark. Read somewhere before so could able to apply and got mark,

Fairly Simple. Got 1 mark.

It worked.

How max degree of parallelism and CPU cores are intercinnected???? Can you give some more inside?>

Friday Fun. Scored 1 mark.

Hi Jeff,

As of now, I m keeping output to s shared location accessible by dev n testers. Req may change in future. No specification of output names, but i m...

Thanks Everyone, Jeff,Luis, & DBACold.

I will have further look per your suggestions.

Let me tell what was the requirement and till what point I did.

Guys were not intersted to use reporting...

Thanks.

Anyway you can help me getting the script in xp_cmdshell?

select * from sys.messages where message_id = 220;

It says, "Arithmetic overflow error for data type %ls, value = %ld."

Good one.

Wao..I scored 1 Mark.

I could successfully able to Insert a record which had a "saleTotal" of 25.1000.

Thanks to everyone for your suggestion & feedback

Tomorrow I will do the required changes and will post you with the results.

Now, THROW is an option available in SQL 2012 and after. So can't use that for lesser editions.

Can anyway, I can check that if my SQL edition is older than...

Thnx Jacob. Appreciate that you spend your time on Sunday. I'm going thru the links which you provided.

One more question here. I mostly use my catch block in the procedures...