One of the best reference site for c#...

One of the best reference site for c#

Click here to go ...

Best reference site for Javascript

Best reference site for Javascript

Click here to go ...
Here also you can ...

This is somewhat usefull to convert from row-wise to column-wise display

This is somewhat usefull to convert from row-wise to column-wise display

Using SQL Server ...

/*create table R2C
(
YKEY varchar(100),
value tinyint
)

insert into R2C values ('BF55CA', 70)
insert into R2C values ('BF5CCA', 80)
insert into R2C values ('BFE5CA', 90)

insert into R2C values ('AFCCAB', 70)
insert into R2C values ('AFC5CA', 80)
insert into R2C values ('A5E4CA', 90)

insert into R2C values ('XFC5CA', 70)

insert into R2C values ('ZF5EC5', 10)
insert into R2C values ('ZEC5CA', 20)
insert into R2C values ('ZF5ECA', 30)
insert into R2C values ('ZF55CA', 40)
insert into R2C values ('ZF5EC5', 50)

insert into R2C values ('EC5CA1', 70)

select * from R2C
*/

drop table #temp
SELECT YKEY, VALUE, CAST(0 AS INT) AS KEYVAL
INTO #temp
FROM R2C

--Index - so we can put correct values for KEY coL
-----CREATE CLUSTERED INDEX Composite ON #temp (YKEY, VALUE) --removed by Senthil


DECLARE @PrevYKEY varchar(100)
SET @PrevYKEY = 0
DECLARE @keycnt INT


--Create running count in the KEY Column
UPDATE #temp
SET @keycnt = KEYVAL = CASE WHEN YKEY = @PrevYKEY THEN @keycnt+1 ELSE 1 END,
@PrevYKEY = YKEY
FROM #temp ---WITH (INDEX(Composite),TABLOCKX) --removed by Senthil

--Now create a dynamix SQL to produce the reqd output
DECLARE @SQL0 VARCHAR(8000)
DECLARE @SQL1 VARCHAR(8000)
DECLARE @SQL2 VARCHAR(8000)

SELECT @SQL0 = 'SELECT YKEY,'

SELECT @SQL1 = ISNULL(@SQL1+',','')+CHAR(10)
+ 'MAX(CASE WHEN KEYVAL = ' + CAST(d.KEYVAL AS VARCHAR(10)) + ' '
+ 'THEN VALUE ELSE '''' END) AS VALUE' + CAST(d.KEYVAL AS VARCHAR(10))
FROM (SELECT DISTINCT KEYVAL FROM #temp) d
ORDER BY d.KEYVAL

SELECT @SQL2 = CHAR(10)+'FROM #temp GROUP BY YKEY'

--Execute the dynamic SQL
PRINT @SQL0+@SQL1+@SQL2
exec (@SQL0+@SQL1+@SQL2)

select YKEY, MAX(value) from (select distinct YKEY from R2C) d

/*
output of @SQL0+@SQL1+@SQL2 is

SELECT YKEY,
MAX(CASE WHEN KEYVAL = 1 THEN VALUE ELSE '' END) AS VALUE1,
MAX(CASE WHEN KEYVAL = 2 THEN VALUE ELSE '' END) AS VALUE2,
MAX(CASE WHEN KEYVAL = 3 THEN VALUE ELSE '' END) AS VALUE3,
MAX(CASE WHEN KEYVAL = 4 THEN VALUE ELSE '' END) AS VALUE4,
MAX(CASE WHEN KEYVAL = 5 THEN VALUE ELSE '' END) AS VALUE5
FROM #temp GROUP BY YKEY
*/

Best site for all Interview Q & A

Followings are the best sites i found for FAQ.... Enjoy!....

Click here to GO !
1. Answer with Samples
2. Just FAQ