Thank you very much for your help with this.

I just added this to my stored procedure and it worked perfectly. I guess that I need to read more about...

I understand how to do "sub queries" as in the bolded line below. What I do not understand is how to tell the T-SQL statement to which ticketnumber to...

Thank you very much for all of the help you guys have provided me so far. When I run the above code in a view, selecting a specific agent,...

Thank you very much for your help with this question. I have spent three days trying to do this in asp.net (web page) and was starting to get frustrated.

I...