Heh... I didn't say anything about evil intent... I just meant to say the original post is correct... the questions are definitely getting worse and more ignorant.

... And, if the combination of ID and Countries forms unique pairs, here's another way that's super easy to expand to additional countries...

SELECT ID

FROM #Test

...

jmucherla (3/9/2009)

---

My table structure is actually like this.

TABLE: TEST

ID Countries

100 IN

100 AU

100 GB

100 ...

Bevan keighley (3/9/2009)

---

Or this works as well:

Select t3.ID From #TEST t3 Where t3.COUNTRIES in ('AU', 'IN')

except

Select t3.ID From #TEST t3 Where t3.COUNTRIES not in ('AU', 'IN')

Looks slower based on execution...

Think not of what to do to the row... think of what to do to the column... and, you don't have to do it all at once... Divide'n'Conquer. 😉

--===== Create...

You may want to consider loading the data into staging tables first. That way you don't have to worry about such stuff.

Look closer.... will someone actually have a table name of ['table1, table2']? As it currently stands, this code gives no returns... so what's the actual code and declarations?

A Little Help Please (3/9/2009)

---

Somthing strange is happening?!

I have restored a SQL 2000 DB on to a new SQL 2005 DB.

When I run:

select top 100 * from tbldeals

order by trade_date...

jmucherla (3/9/2009)

---

Hi,

My table structure is like this.

TABLE: TEST

ID countries

100 IN, AU, GB, FR

101 GB, FR, IN

102 ...

So no problem, right? Just ask that person for the encryption key. If (s)he doesn't give it to you,...

Heh... don't be sorry that you don't see it... be glad.

And, finally, the thread devours itself...

As the others have suggested, there's something wrong with that picture, Mike, and we probably won't be able to help from here.

First, check...

john.clyma (3/9/2009)

---

Jeff,

Thanks for the response! I have used 'If exists(blah)' in the past, it slipped my mind. Is there a way to mark the post as 'complete' or...

So, after 2 weeks, have...