karthikeyan (12/21/2007)

---

Madhivanan,

Thanks.Suppose if i have like this,

Declare @Str varchar(300)

@Str = 'Karthikeyan,Madhivanan,JeffModen,Steve-Jhones,MattMiller,GilaMonster'

do we have to repeat your code for 6 times? Suppose if i have around 20 names do we repeat...

I don't believe so... other than running it or taking it apart and running the peices...

You could always setup to exec it and run an estimated execution plan on it,...

Heh... I hate Oracle...

I create a linked server to the Oracle DB, grab the data I need and store it in permanent "working" tables in SQL Server, and then all...

THAT would be the ticket...

p.s. Don't forget to close the spreadsheet after you save it or you WILL get an access error... 😉

No, no... it's much easier than any of that. This is a common problem and DTS frequently messes up imports especially if there are some merged cells above the...

Ok... here's the code that proves what the problem is... it's not my code, but I forget the name of the good fellow that wrote it for me as a...

Basically it is a proprietary SP provided by a SQL based web application for the purpose of generating unique integer based row IDs. It does several things including calling other...

Thanks for the feedback, but to be sure... cursors are never an option for me. Maybe the occasional WHILE loop to act as a control for managing "dips" to...

Bottom line, sometimes it's just like magic to make the code work Not to mention the ohs and ahs from the staff who were just going to open the...

It was in 2k... Heh... I'm thinking that there's a hidden "bookmark" that didn't show up in the EP. But, correct, it does show that just because an index...

Thanks for the high compliment, Dionisis :blush:

FP = Farrukh? You got two logins?

You should wait forever for that... it's just another way to screw up dates and times.

karthikeyan (12/20/2007)

---

Jeff,

Really i am wondering about your skill.

Can you explain me your two different queries in detailed ?Also,

1. What do you mean by @Delim+Remarks+@Delim ?

i.e...