Never mind!  the DB is set to SQL Server 2008.

Thank you anyway!

Gurus,

Thank you for your infinite wisdom, and Thomas in particular for the recommended link, that was a very interested read and time very well spent.  I found the...

Thanks gurus!

Doesn't the incremental backup sets the checkpoint?  this DB has full backups every friday night and daily incrementals.  While this is a production DB, there aren't many...

Thank you, David and Scott
 Yeah, I got that the rollback just undoes the create.  😉 
Question answered!

Thank you, again and have a great day!
JCR

We compared the settings of both SQL servers and they are identical.  However, in deeper research, I've found what was causing the issue and had nothing to do with the...

Thank you Luis!

The weird part is that when it was running on SQL Server 2008, we did not see this happening.  Now, while the server is running SQL...

Thanks Luis! Very clean and precise, I like it. If I may take advantage of your disposition to help, I have instances when an OrderID will have a...

Jeff,

Each of the ten items have key elements I need to report on and the contract only has one receivable item. Let me try to paint a clearer picture:

A...

Hi Jeff,

Yes, you might remove the dilemma here. And obviously I am going about it the wrong way. The root problem is that each contractID has tow separate...

Sean,

Thanks for the links. I learned a bit more today. But I believe I am too "squared-eyed" already and thus not being able to construct my query accordingly....

Eugene,

From that link you placed:

For ease of reading, numbers with many digits before or after the decimal mark may be divided into groups using a delimiter, with the counting...

Thank you all and yes, I agree that all this should be done at the presentation layer and not at the DB level, but this is one of those things...

Thanks Lynn!

I guess I was just looking for confirmation. I did end up using a temp table for the rest of the manipulation and it is all good now.

Again,...

Thanks Jack!

If I may abuse of your knowledge a bit more, I have moved my availability check inside the BEGIN TRY BEGIN TRANSACTION block but I am at a loss...

I used XACT_STATE just for troubleshooting or debugging and it won't be in the production version. Sorry, I should've put that in the code.

As for the isolation level, I...