I've bee perusing the eBook "Best of SqlServerCentral Volume 7" and there is an article on deleting dups. It is written in the book using SqlCmd script. I tried to...

Do geeks always have this much trouble getting a date?!

If I'm not mistaken, SELECT CAST(GETDATE() AS DATE) will only work on SS2008 and above, as the DATE type is new in 2008.

I'm using Bulk Insert. It seems that it ignores row delimiters, unless the row has all of the columns present. Is this working as designed? In other words, if the...

Okay, I think I see... I'll try this.. thanks!

To simplify the problem, really, all I need is a sequential "Set" number. The first set of records from INS through COB would all have "SET000001" in the last column,...

I tried to simplify the problem in my example, but this is more like what the data actually looks like coming in:

INS*Y*18*030**A*D**FT

REF*0F*123456

REF*1L*FL103

REF*F6*999999999A

NM1*IL*1*JONES*WALTER*J

PER*IP**TE*6665550207

N3*5400 17TH AVE N

N4*ST PETERSBURG*FL*337105704**CY*PINEL

DMG*D8*19351211*M**7

LUI*LD*ENG

HD*030**HMO*311-014*IND

DTP*348*D8*20090101

LX*1

NM1*P3*2*JONES*HEMANT*R***SV*14911*25

N4*ST PETERSBURG*FL*337107127

COB*U**1

INS*Y*18*030**A*D**FT

REF*0F*657933

REF*1L*FL033

REF*F6*381343567A

NM1*IL*1*ADAMS*KAREN*I

PER*IP**TE*8135555039

N3*3222 N FLORIDA AVE

N4*TAMPA*FL*34603**CY*HILLS

DMG*D8*19330501*F**7

LUI*LD*ENG

HD*030**HMO*456-024*IND

DTP*348*D8*20090101

LX*1

NM1*P3*2*HANKS*ASHOK*K***SV*411180*25

N4*TAMPA*FL*33802

COB*U**1

I'm...

It fails to create the create or insert procs. The delete proc is successfully created.

I only modified this to use the prefix "PEC_" rather than sp_, and my table is PEC_edi_834

The proc gets created with no error, but when I try to run the...