Click here to Skip to main content
15,883,278 members

Comments by Rak_Avasthy. (Top 13 by date)

Rak_Avasthy. 26-May-15 2:34am View    
No its not a homework. I have some huge data and this is just a sample data for the condition I need. I needed help coz sometimes when we are fed up with work our mind stops thinking the PIVOT may do the trick
Rak_Avasthy. 26-May-15 2:33am View    
Thanx. That did the trick
Actually this query gave the correct result

SELECT [1] AS Alpha1, [2] AS Alpha2, [3] AS Alpha3
FROM (
SELECT *, ROW_NUMBER() OVER(PARTITION BY Num ORDER BY Alphabet) AS Alpha
FROM @tmp
) AS DT
PIVOT (MAX(Alphabet) FOR Num IN([1], [2], [3])) AS PT
Rak_Avasthy. 26-May-15 2:24am View    
Thanx anyway
Rak_Avasthy. 20-Jan-14 5:09am View    
I think this is not possible, instead i recommend using a GIF image if percentage of work done is not required
Rak_Avasthy. 20-Jan-14 5:07am View    
Use application config file to store many connection strings and use a mechanism to choose specific connectionstring for specific user. That should do it i suppose