Thanks to all that replied. Forget the last question, it's trivial now.

Thanks, do you know how to retrieve multiple result sets in C#?

thanks in advance.

the parameters that are passed are @plid and @id. when @plid is 0(the first if > -1 statement, which I need to combine with the second if > -1...

yes, but I typed my computer's name and it did not find a server there, it gave me an error that I did not copy. I did not try typing...