Run them both and look at the actual execution plans. You may be surprised to find they are the same or "trivially different" - maybe.

Guessing that your unique ID's are integer, you will need to cast them to a string type, preferably a CHAR of the correct length.

Why do you want to do this?

You're welcome 🙂 Thanks loads for providing scripts and a perfect spec!

You're welcome.

If you choose to go down the table route, you could "encapsulate" the code within a (CROSS) APPLY to provide a very fast solution.

LOL thanks! It's not the manflu which...

Don't worry, we'll get there.

;WITH OrderedData AS (

SELECT tradeId, pctAccountRisked, profit, tradeDateTime,

...

Thanks for posting.

Here's a handy reference for you:

http://msdn.microsoft.com/en-us/library/ms187489.aspx

Which would make your code much more compact for the next step:

---------------------- Albania POSTCODE VALIDATION ----------------

ELSE IF @COUNTRY = 'Albania'

set @Result=(SUBSTRING(@ADDRESSLINE,...

Deepthy (10/27/2010)

---

Hi ,i have 180 nested if statements and when i run function i get this:

Some part of your SQL statement is nested too deeply. Rewrite the query or...

Brandie Tarvin (10/27/2010)

---

I'm not sure I get Chris's comment of "It will also fail on duplicated rows from TempCustomer because the column ContactID in table ContactAudit is specified NOT NULL."...

Put this at...

It's perfectly valid code as others have pointed out. It's interpreted by SQL Server as this:

select s.SSN from #Select s where s.SSN in (Select s.SSN from #SubSelect ss)

Wow, what a great question! And I'm stuck at home with manflu and an expired evaluation copy of SQL2k8.

Ok here goes:

;WITH OrderedData AS (

SELECT accountPerformance, tradeId, pctAccountRisked, profit, tradeDateTime,

rn =...

Maina-456685 (10/27/2010)

---

Hi,

I hope it makes sense now: i need an sp that does the following:

Condition 1: If an entry is duplicated in TempCustomer, insert into ContactAudit table.

An entry...

Sharon, can you post up the actual execution plan for this query?

You need to write the query properly first - if this returns the correct rows, it's by accident, not by design. Something like this:

select t1.*, t2.*, t3.*

FROM TABLE1...