Not to mention the leading quote in the...

No casting needed when you used DATENAME, Lynn. 🙂

Lynn Pettis (3/19/2009)

---

Jeff Moden (3/19/2009)

---

foxjazz (3/19/2009)

---

I think this is the query I arrived at for getting the next PK value.

select @currentval = max(Convert(int,substring(GenLevelAddFieldID,len(@@servername) + 1,10))) from tblLevelAddFieldRel where GenLevelAddFieldID...

Bruce W Cassidy (3/19/2009)

---

True. But neither will server...

J (3/19/2009)

---

And as was mentioned before, a LineNo is the normal way of forcing a specific order. Using the script already posted to increment the LineNo to be consecutive allows...

If it must be done that way, then multiple tables...

Bruce W Cassidy (3/19/2009)

---

foxjazz (3/19/2009)

---

As far as the varchar(50) pk numbers, there is no other way to do it.

We do it by computername for a reason, our sync processes depend...

foxjazz (3/19/2009)

---

I think this is the query I arrived at for getting the next PK value.

select @currentval = max(Convert(int,substring(GenLevelAddFieldID,len(@@servername) + 1,10))) from tblLevelAddFieldRel where GenLevelAddFieldID like @@servername + '%'...

JacekO (3/18/2009)

---

I would keep it simple. Deal with one record at a time. If your Stored Procedure is designed to work fine with one record you can call it sequentially...

Heh... either that or it's the low glow from a slow burning fuse... 😉

Always, Bob.

I cannot believe...

That's why I suggested attaching the first 10 lines of the file... so I can see what the termination character is in binary.

Thanks for the feedback... and yes, that's precisely what I was talking about. You also don't need to spend a lot of time deleting that way, either (although, like...

She's confusing things like the use of triangular...