Comments by Rak_Avasthy.

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

Rak_Avasthy. 2-Dec-13 6:11am View

Looping is actually not required in sql for this operation, it can be directly be done by using statement in solution 1 below.... kudos

Rak_Avasthy. 12-Nov-13 0:33am View

why cant you use a join with project table ?

Rak_Avasthy. 8-Nov-13 1:31am View

use
ExecuteSQL("INSERT INTO SalHikes(Empid,Hike,Date) SELECT '"+ EmpId +"','"+ Convert.ToDecimal(dt.Rows[i][j].ToString()) - maxSal +"','"+ dt.Columns[j].ColumnName +"'")
to insert the hike and date in a temporary table or permanent table and then
fetch this data in data table and bind to the grid.

Rak_Avasthy. 7-Nov-13 4:49am View

you need c# code or sql query for that??.... and this is a query.. it does not run in visual studio, you have to meke an sql connection and sql command to execute this command

Rak_Avasthy. 7-Nov-13 3:50am View

i have updated the answer kindly check

Rak_Avasthy. 7-Nov-13 3:39am View

yes there is no particular need for keeping it in a table unless you need it later to display somewhere....and using temporary table is definitely a suitable option for me to keep that data

Rak_Avasthy. 7-Nov-13 3:27am View

Deleted

sorry i dint understand wat do you want to ask .... plz clarify

Rak_Avasthy. 7-Nov-13 3:24am View

so that max. salary corresponding to each employee can be obtained

Comments by Rak_Avasthy. (Top 13 by date)