I have been using the template below and it has worked great for me. The article is really good too.

http://www.sqlservercentral.com/articles/Development/anerrorhandlingtemplatefor2005/2295/

Hope this helps.

Jeff,

Thank you for the feedback. Here are a few things I tried:

- with recompile

- drop and re-created the procedure

- reindexed the entire database

- ran dbcc checkdb

Never heard at parameter sniffing...

Thanks a lot for the advice. I will run the sp_configure and split the amount of memory so that it adds up to 3GB. Our UAT server will probably get...

That is an interesting parallel Steve is making with sports. I used to play professional tennis back in my home country and college in the US. I stopped after college,...

Like everyone else, the most difficult part to accomplish to get into a peaceful and focused mental state of mind is related to distractions from colleagues, emails, phone calls,... and...

Ken, Thank you so much. I tired to reformat the script many times and it would keep giving me syntax errors. Thanks again.

Jeff' link is really thorough and provides a great explanation of the pros/cons. In the meantime, here is a simple way to solve it. Hope this helps.

declare @table table

(

salespid int

,salesamount...

My bad. I did not see that the number needed to be appended. John's suggestion works great. I thought you only needed what was left of the ".". Sorry for...

If the pattern is consistent, meaning there is only one instance of the "." in the string, you could use something like this.

DECLARE @String NVARCHAR(50)

SET @String = 'E955.0'

SELECT SUBSTRING(@String,0,CHARINDEX('.',@String))

Hope this...

I would suggest the following checks:

1. make sure there is a line terminator after the last line of the BCP file.

2. make sure the columns of the BCP file match...

I could not agree more with Steve. I am fairly young to the world of IT, under 10 years, and I have only worked for small companies, witnessed first hand...

If you are trying to compare 2 tables that have the same fields, you could try using a FULL JOIN.

I just wanted to add the link to the appropriate resource. The paragraph giving the explanation was already posted by Jeff Deluca right above but if someone could replace the...