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

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/

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

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

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...

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

Hi Mukesh Kumar Tiwari,

User Case like following u will get ur output.

select studentName,Address,

      case when Marks<=30 then GradC else null,

      case when Marks >=30 and Marks<=60 then GradB else null end

same way u can use ur condusion.