Oh OK. I understand why my query didn't work.

Thanks for suggesting crosstab ..I haven't used this much before.

If I want print all CompanyPrevName instead of just 2, how can I...

sorry posted in the wrong forum. I copied this over to SQL 2008 forums.

This is the data we got from vendor and there are several thousands of records with this issue. I am guessing somebody who did data entry, fat fingered this... our...

I forgot to add ROLLUP(Department COLLATE SQL_Latin1_General_CP1_CS_AS) to the query and COALESCE(Department COLLATE SQL_Latin1_General_CP1_CS_AS,'Total') Department in the select clause ...Now I got it to work

Thanks so...

Ok, I used your logic but still cannot do a case sensitive rollup.

SELECT *

FROM ...

I just added the expected output

wow! never thought of that approach. It took me a day :-(..and the only solution I thought was creating separate temp tables for each ColumnID with primary key as SchoolID...

oops..I updated my scripts

I completely messed up the table.. I am so sorry..

Create table Test(schoolid int, ColumnID int, Value varchar(100), insertedDate Date)

Inserteddate - date when it was collected

Insert into test values(1000,1,'2001-01-01','2005-12-31 00:00:00')

Insert into...

Thanks for helping me.. I had to add more conditions on top of this but this foundation really helped me

I don't think we have are approved to use CASS in our company.

Thanks

R

Thanks for the reply. I had one more question. I added a field called 'Ignoreflag' to the table with default value= -1.

It is set to one if Name,Address is...

I probably posted the question without trying this.

Adding N' before the string. I tried and it works.

Business needs. Non-IT/non-database people need to see this and we thought if we can do 10,000 in each html file. they can scan through it and report us of any...

I do think it is some setting that needs to be changed. I looked in Tools->options & changed the max number of characters displayed to 8192, Results to grid ->...