Good answer Steve.

My answer was based on

, where the only difference...

Hey Jack, how about keeping me...

Chris Morris-439714 (4/16/2010)

---

jcrawf02 (4/16/2010)

---

Having a good day today. Working through a problem comparing two datasets and finding those that don't match from either. Thought about it, mocked up some data...

Thanks. I was thinking about using this one (about 1/2 way down the page), but I figured that Steve would ask me to...

Yep, it's not perfect. It would be much better to normalize that data... then data can point to data, and not to columns.

Move the sub-query from the select's column list, and make it a derived table in the from clause, with the appropriate join condition to the [place-ref] column. Name the aggregrated...

SSIS has to double-up the slashes, so I don't think you need to worry about it.

splinter-740692 (4/16/2010)

---

Hi,

I have a SQl table which has a primary key defined onthe three columns. The index description for the primary key states as 'clustered, unique, primary key on PRIMARY'.

My...

Sasidhar Pulivarthi (4/15/2010)

---

hi,

The @rid is taking the multi values by comma seperated....

ex: 12,45,24,3,78 ..

So the datatype int only takes single value of int only...it doesnot allow the above value...

For...

Just gotta love it... you're query is taking denormalized data and normalizing it.... and you'd rather keep it this way :w00t:

With 200 columns, you're looking at dynamically performing an UNPIVOT...

I would suggest that you replace the #Main table with this:

CREATE TABLE #HouseRooms (NoID int, RoomName varchar(25), RoomValue float)

This allows you to run this:

-- Your original tables / code here

if...

Since you are determined to run it in a loop, this is as good a method as any other.

BTW, you ought to remove your "IF" statement... with it, you're not...

Check out ALTER TABLE in BOL.

Gregory,

While I'm thinking of it, RBarryYoung wrote a couple of articles (and, supposedly, more are forthcoming) on how to eliminate cursors from your code. Check it out here[/url].

That month-long...