Again, I'd like to know why we're perverting email addresses in such a fashion.  There has to be a reason.

Hi Thom

First i get data saved in Temp table like below

CodeNameQuantityDscription
32Rohan1        Item 1
32Rohan2      ...

Some real or better-simulated data for the file is absolutely necessary for us to help you here or the answer will be either to create a BCP format file or...

To go along with what Scott stated, when is the last time you rebuilt statistics on the date column?  How many rows have been changed according to the modification_counter column...

WHY????  It seems to me that you're removing a necessary part of a correct email address. 🙁

I have the same concerns about a PoSh script as I do with an SQLCMD script.

I'll say, Absolutely.  It's a very necessary form of communication no matter what you do in life but especially in the world of IT.  And, it's not limited to just...

I REALLY enjoyed the "Programming Sucks" article you provided a link to, Steve.  The funniest part about it is that it's all true!  😀

Shifting gears a bit, thank you for...

I have a question just out of curiosity... what are you going to do with the zeroes once you have the correct...

There are actually several massive differences between Truncate and Delete.  You can read about most of them simply by looking up the commands and reading about them.

One not so well...

It sounds like a "connection leak" built in.  Either that or connection pooling on steroids that has gotten a bit out of hand and forgetting to deallocate a cursor or...

BWAAA-HAAA-HAAA! 😀 NCHAR(MAX).  I wonder if anyone will bite on that. 😀

I don't know and I actually try to avoid all forms of "replication" but posting your question to Google came up with this.  They have a link at the bottom...

Are you just trying to LPAD zeros for a total length of 5?  If so, this will make your life easier...

DECLARE @SomeInt INT = 22;
 SELECT RIGHT(CONCAT('00000',@SomeInt),5)
;

Note...

Doesn't matter... sounds like you need more RAM for whatever you having the server do either way.