Everyone: Thanks a lot for your input. I knew i could count

on you guys!

Thanks Peter.

Peter, thanks for you reply. Could you elaborate on what you mean by consuming a rowset?

do you mean something like myreader.NextResult()  ?

before i start reading the values?

Thanks

Thanks. I'll give this a shot.

Thanks a lot. Exactly what i wanted.

SELECT TOP 10 OrderID

FROM dbo.Orders

ORDER BY OrderDate

Does exactly what i wanted! Thanks a lot.

Thanks CColson, That's what i ended up using.

I actually tried it before but for one reason or another could not get it to work so i went with the long...

Thanks, will try that.

thanks. I went with the split string option.

works like a charm.

🙂

Thanks i figured it out. The thing was just bogged down beyond all recognition.

Dan, that worked like a charm. Thanks a bunch!

Thanks Dan but i still get that blank record.

I dont know maybe there is some invisible character stuck in there. Is there any way to tell? I looks blank in...

Thanks Klaas but that will not work.

First of because it returns duplicates and second it STILL returns that blank one.

great idea nickel! One problem though...

i have no clue where to even start with a thing like that!

If you are willing to help, i'll try it that way.

ok thanks. That's getting a bit too involved.

Like i said i dont really know anything about sql other then simple select update delete insert statements.