Viewing 15 posts - 3,481 through 3,495 (of 4,080 total)
Just as a matter of practice, you should probably have a lastUpdated column in your tables, as well as a dateCreated column, so that you can tell when each row...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
March 11, 2009 at 8:41 am
Lucky you. I got the question wrong without even answering it.
ME TOO !! 😛
Has anyone else applied the latest HotFix to sp_MSGoBackInTime ??
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
March 11, 2009 at 8:32 am
Metro, you need to put forth a little more effort, please. Work with us. Did you even TRY to do what I asked you to...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
March 11, 2009 at 7:51 am
you may have your result being calculated in a cursor
Oh no.... you said the "C" word !!! :w00t:
Do you use cursors a lot, Aram?
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
March 11, 2009 at 7:41 am
You're welcome, VM.
Flo, yes it's the wrong thread. I'm trying to figure out how I posted it here AND why I can't delete it now.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
March 11, 2009 at 7:38 am
or use (gasp) COALESCE 😉
select @searchvar = case when COALESCE(@var1,@var2,@var3) is null and @var4 is not null then 'RESULT' else '1' end
But we believe the OP is trying to use...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
March 10, 2009 at 10:11 pm
Then why are you using IN? All you need is equals.
AND
Table3.col11 = @inputParam
At this point it would be very nice to have some data. ...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
March 10, 2009 at 8:36 pm
PS
is it at all possible to modify that logic for multiple records to handle an "empty return" ?
That was the original question and that's what the examples from Jeff...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
March 10, 2009 at 6:59 pm
Here is an alternative to dynamic SQL. The code at the bottom will quickly parse a delimited list of values out of an input parameter for you. ...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
March 10, 2009 at 6:36 pm
I'm currently investigating SQL Server 2008...
No problem. But if you are asking questions about 2008, there is a separate forum for that 🙂
SS2k5 == SQL Server 2005.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
March 10, 2009 at 6:23 pm
POST PostScript:
Row Constructors [ex: Values (1,'hello'), (2,'hello')] are new to 2008.
Be mindful that you are in a 2005 forum.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
March 10, 2009 at 6:09 pm
Flo,
I'm afraid I'm unable to duplicate your results. I'm comparing an insert into/SELECT ... union all against a insert into VALUES for 1000 rows. ...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
March 10, 2009 at 6:07 pm
Flo,
I'm afraid I'm unable to duplicate your results. I'm comparing an insert into/SELECT ... union all against a insert into VALUES for 1000 rows. ...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
March 10, 2009 at 6:05 pm
I notice the MIN function, JA. Can you make it work with multiple rows?
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
March 10, 2009 at 5:29 pm
He's a Jedi master wannabe?
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
March 10, 2009 at 1:19 pm
Viewing 15 posts - 3,481 through 3,495 (of 4,080 total)