Viewing 15 posts - 12,196 through 12,210 (of 18,923 total)
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...
November 23, 2005 at 4:15 pm
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...
November 23, 2005 at 11:41 am
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...
November 23, 2005 at 9:45 am
Seems strange to request that, what is the business rule you have to enforce?
November 23, 2005 at 9:43 am
Test that on a 1000 rows table with 25 left joins... Now test mine after that...
November 22, 2005 at 12:28 pm
Yes but this doesn't allow for a dynamic number of parameters.
November 22, 2005 at 10:23 am
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 =...
November 22, 2005 at 9:25 am
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.
November 21, 2005 at 12:39 pm
I think you need to close the recordset before accessing the return value (or is that the connection, I can never remember that one).
November 20, 2005 at 9:26 pm
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.
November 15, 2005 at 1:28 pm
Cool, pick out the right answer from that list now
.
November 15, 2005 at 11:46 am
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...
November 15, 2005 at 10:54 am
Viewing 15 posts - 12,196 through 12,210 (of 18,923 total)