Yeah that's what we had to do too. The cyborg got all bummed out about it and walked off muttering something about going into politics.

😎

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...

ME TOO !! 😛

Has anyone else applied the latest HotFix to sp_MSGoBackInTime ??

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...

Oh no.... you said the "C" word !!! :w00t:

Do you use cursors a lot, Aram?

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.

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...

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. ...

That was the original question and that's what the examples from Jeff...

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. ...

No problem. But if you are asking questions about 2008, there is a separate forum for that 🙂

SS2k5 == SQL Server 2005.

POST PostScript:

Row Constructors [ex: Values (1,'hello'), (2,'hello')] are new to 2008.

Be mindful that you are in a 2005 forum.

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. ...

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. ...

I notice the MIN function, JA. Can you make it work with multiple rows?