Not quite, a single constraint could validate this requirement but I feel that my suggestion allows for more possibilities if the rules (gob forbid) ever change. The overhead would...

CHECK THE DATA.

Maybe I'm wrong but it looks like you could have a delivery type column with a lookup table. If you make that column not null then 1 value can...

Do you get a syntax error or no rows back?

Here's a good one : Why not just WHERE User.UserID = 49

?? If that doesn't do it for you then check the data, there's surely a type...

Seems strange to request that, what is the business rule you have to enforce?

Test that on a 1000 rows table with 25 left joins... Now test mine after that...

Yes but this doesn't allow for a dynamic number of parameters.

IF EXISTS (Select * from dbo.SysObjects where name = 'fnSplit_Set' and XType IN ('FN', 'IF', 'TF'))

DROP FUNCTION dbo.fnSplit_Set

GO

IF EXISTS (Select * from dbo.SysObjects where name = 'Numbers' and XType =...

Make sure the so is working correctly before debugging in the vb code... that way it's easier to find the real cause of the problem.

I think you need to close the recordset before accessing the return value (or is that the connection, I can never remember that one).

That's it... I'm never comming back. I'm not always right but if you guys can't live with the fact that I'm rarely wrong then Goodbye.

Since when is left sargable?

Cool, pick out the right answer from that list now .

I don't understand why you need to do this. Aren't you using some sort of primary keys in the main table? That way the name could change without...