get 1column thrice time on diffrent cond. from same table.

Question

i want to get one column three time on the based of diffrent condion in sql server.

Manish Kumar Choudhary · Answer

Hi Mukesh Kumar Tiwari , Read these links it helps u http://www.mssqltips.com/sqlservertip/2783/script-to-create-dynamic-pivot-queries-in-sql-server/ http://stackoverflow.com/questions/14797691/dynamic-pivot-columns-in-sql-server https://www.simple-talk.com/blogs/2007/09/14/pivots-with-dynamic-columns-in-sql-server-2005/

Mukesh Kumar Tiwari · Answer

i want to generate dyanemic three column in result set of a single column based on diffrent condtion.

Joginder Banger · Answer

you mean add dynamic column based on condition. explore more what's you try man

Mukesh Kumar Tiwari · Answer

suppose there is a column name the i want to generate 3 column in result of name field based on diffrent condition. i tried but not succes using case and subqueries and union...

Joginder Banger · Answer

sr No name age Class 1 Mukesh 20 BCA 2 Mike 25 BCA 3 Jogi 21 BCA select case when age=20 then Name else 'null',case when age=25 name else 'null',case when age=21 then name else 'null' from your_table_name

Manish Kumar Choudhary · Answer

Hi Mukesh Kumar Tiwari , User Case like following u will get ur output. select studentName , Address , case when Marks then GradC else null, case when Marks >=30 and Marks then GradB else null end same way u can use ur condusion.

get 1column thrice time on diffrent cond. from same table.

Answers (6)