Right, I was afraid that's what it would come down to. That means I'm going to have to create 30 sub-procedures.

I'm interested in the occurance of the semicolon in...

Here's the code that builds the table, but there's nothing extraordinary about it.

IF (@Discipline IS NOT NULL)

BEGIN

SET NOCOUNT ON

SET @l_List=@Discipline

...

Mine is slightly different, but doesn't work. If @NULL is not null, then there will be a temp table that I want to search on. I'm...

Yes, there probably is. But this is for a client, and they really want to do it the Dumb(tm) way. So, picture a page with five *muli-select* boxes......

Yes, I would if I could. But, in reality the example I'm using is just for brevity. I actually have five temp tables that may or may not...

Ok, I think I need to rephrase. This is for a search, and I have a table with an int field that's a foreign key. My search may...

Nope, but I think that's exactly what I need.

Thanks!

Yes, I've heard that before, and it does work fine. However, when I setup a connection that way, it's completely plain text across the Net! If I 'force...

Right, but that would execute one command, and then the other. I actually want the data that comes back from the stored proc to be included as a column...

Hmm, since that was too easy, now let me complicate it

I want to generate a view (not hard) combining a regular query and a stored procedure....

Yeah, I already did that, and it turned up nothing.

Well, I hadn't tried checkdb, so I gave that a try. Nothing worked accept repair_allow_data_loss, which scares me to hell. Is there any way to find out what...

Well, it still needs to address the issue of 10 rows for the first category (leaving 1), and 10 for the second (leaving 1). Your example leaves 12. ...

Ok, let's say I have a table of events, and each has a category. Ok, two categories with 11 events in each, each event one day into the past,...

Right, I guess I'm having trouble understanding why. Why can't/doesn't it look inside words? Why is it pushed as being wonderful when it's not even as flexible as...