Viewing 15 posts - 2,386 through 2,400 (of 4,080 total)
So we have several possibilities at least:
(1) The presence of the byte is itself a flag of some sort.
After all it DOES tell you whether an...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
September 9, 2009 at 7:35 am
Neither are coconuts.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
September 8, 2009 at 12:59 pm
Another alternative is to rewrite your stored procedure as a table-valued function.
select * from dbo.tfn_YourFunction(parm1,parm2,parm3)
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
September 8, 2009 at 12:11 pm
EXISTS is true whenever any rows would be returned by the query. You should pair it with a subquery that has a where clause.
IF EXISTS (select 1...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
September 8, 2009 at 12:02 pm
It can and will do just that when it decides that is the least amount of work. But remember, whenever you use an index and have to get...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
September 8, 2009 at 11:14 am
Nice technique, Paul.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
September 8, 2009 at 8:51 am
Thanks so much for posting up sample data!! Applause!!
select E1.id,E1.Fname as Fname1, E2.Fname as Fname2, E1.Lname as Lname1, e2.Lname as Lname2
from Employee1 E1
join Employee2 E2 on E2.id =...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
September 8, 2009 at 7:07 am
"Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, , >= .... "
You subquery is returning a set of values. ...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
September 8, 2009 at 6:52 am
MY thread.. ?!? Just because I don't accept an execution plan for a table with 7 rows of data?
For the luvva small, fluffy bunnies....
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
September 8, 2009 at 6:40 am
SOM 😛
"For the love of small, fluffy bunnies?"
We're even on coffee for the day, Paul.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
September 8, 2009 at 6:36 am
the most amazingly cross-purposed debate ever
Where did this take place?
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
September 8, 2009 at 6:12 am
Without commenting on the wisdom(?) of your approach, I will say that lists of values are tested using IN, not equals (=). Another method would...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
September 8, 2009 at 6:11 am
Paul, does it add a new byte EVERY time? If you rebuild the same index 5 times, does it increase by 5 bytes? Or...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
September 8, 2009 at 6:00 am
I assume this has to be IPoAC / PPTP - compliant?
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
September 8, 2009 at 5:53 am
Use DATEADD, with a negative number of days.
select getdate(),DATEADD(day,-3,getdate())
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
September 8, 2009 at 5:49 am
Viewing 15 posts - 2,386 through 2,400 (of 4,080 total)