Why not just exclude those fields from the temp table? Do you really need them?

Mark

Look at except:

http://msdn.microsoft.com/en-us/library/ms188055.aspx

Mark

Happens to me all the time at work but we're trying to utilize the project management group as part of our regular process. The business knows they must supply...

I'm a huge fan of the book SQL Server 2008 Bible. Look in to that one if you'd like to learn more about programming in SQL Server.

Someone else mentioned...

If you need this added to a query where you don't always know the value, try this:

select replace(YourColumnNameHere, '.00', '0.00')

This worked when I tested it using this code:

with cteTable(TextString)

as

(

select 'Qty:...

As Jeff poinged out you have a typo unless you were typing from memory and that's not how it is in your query. If that's the case, please let...

+1 for the normalized approach. It may be 2 players today but it likely to be expanded upon at some point and you can have that addressed in your...

The rollback after the error trapping is the issue. It's rolling back your error record. Move it before that insert.

RBarryYoung's code works although there's an extra "begin catch"...

There's no need to do that when SQL server can manage the ID itself like stated in the post above.

If you have permission to alter the table, add a new...

Thanks to everyone for your input. I really appreciate the feedback.

Taking all this in, I decided to contact the person sending the post and politely asked them for the...

Great feedback. Thanks guys.

Mark

Steve Jones - SSC Editor (8/22/2012)

---

Mark Eckeard (8/21/2012)

---

I bought my wife the new iPad and the display is nothing short of amazing and it's very responsive but you'd think at...

I bought my wife the new iPad and the display is nothing short of amazing and it's very responsive but you'd think at that price apple would include something as...

You can get by storing the data once and removing the formatting for reporting purposes if needed.

I used this free tool to build a wysiwyg kind of editor within a...

.NET has the ability to capture and pass the HTML to a sproc and you can store it as varchar(max) like you said. I did this on a few...