Chris Morris-439714 (4/16/2010)

jcrawf02 (4/16/2010)

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)

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)

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

Also:

select ServerProperty('IsClustered')

From SQL? try:

select serverproperty('ComputerNamePhysicalNetBIOS'), @@ServerName

(See BOL for this). If they are the same, no cluster.