I didn't see that Rups had replied. You can do the...

Hey, I cannot really understand why you have to do all these. Try the following query and check if it gives you the desired result.

update XXX set account_nbr = '00'...

🙂 Didn't see the other responses. Good to find multiple people responding so fast though.

- arjun

You gotta use left outer join

SELECT TT.ID, CASE TT.ID WHEN -1 THEN 'NOVALUE' ELSE T.IdName END IDNAME ,VALUE1

FROM #tmpTran TT

left outer join #TMP T

on T.ID = TT.ID

-...

Thanks a lot Stefan. I didn't know about the update scenario.

- arjun

A couple of good resources on parameter sniffing -

http://elegantcode.com/2008/05/17/sql-parameter-sniffing-and-what-to-do-about-it/

http://blogs.msdn.com/queryoptteam/archive/2006/03/31/565991.aspx

- arjun

noelconroy15 (5/17/2010)

---

Hi All,

I am scoping a development for a vendor developed application. Historically the reports for this system (SQL Server Reporting Services) simply displayed values from a table in our...

Jacob, how would he use sp_msforeachdb. He wants to execute the statement for a particular DB.

Can you explain?

-arjun

with that in mind, here is how you would use xp_cmdshell to call the program and get it's results in a table...you'd then need to parse the results.

create table #Results...

Well it sounds greek to me Raju. Someone who has better exposure will help you soon. Stick around.

- arjun

Your requirement somehow sounds very weird - Passing the database name as a parameter!

If you do not want to 'hard-code' DB name, you can use synonyms.

You can read more...

Do you mean version? Please be more specific in your questions. Otherwise you will find that your questions remain unanswered for a long time.

If you mean version, use the following...

🙂 you are welcome.

-arjun

Is this what you need?

----

----

where

((SELECT Value FROM Parameters WHERE Parameter = 'Export') = 'all')

or (id in (SELECT ID FROM LIST))

- arjun

Mushana, read this article. It describes how to solve your problem.

http://www.sqlservercentral.com/articles/APPLY/69953/

- arjun