Well, a couple of years later and I have just run into the same problem...

Here's my error:

"'perl' is not recognized as an internal or external command, operable program or batch...

Unless you actually want to send mailings with a readable SSN, I would probably create a match table so that you wouldn't need to actual send out any variation/encryption of...

Looks like it comes from the following sub statement...

Substring(Ltrim(Rtrim('0' + @string)), 3,1)

eg..

DECLARE @string CHAR(11)

set @string = '1A097686283'

print Substring(Ltrim(Rtrim('0' + @string)), 3,1)

select Substring(Ltrim(Rtrim('0' + @string)), 3,1) *2

When you try to multiply...

Sorry I didn't respond on this. I guess I figured something out with the help from all knowing andy and ran with it.

The scenario I was dealing with inserts ~2...

To follow up on the experimentation:

The strange thing about this is that the time stamp (milliseconds) that I printed here indicates that the first delete method runs much faster than...

Thanks for that suggestion... I was kind of hoping that I could use some type of conditional truncate on that table, but I guess not.

I use the truncate table command...

I have a similar complaint.

I'm using Bulk Insert with the following stipulation:

If any lines in the import file error on insert, I want to be able to edit the lines...

My scenario:

Our intranet (running on IIS) uses WA. From there we connect to the db using a common sql login. As far as I know, this results in having no...