Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
Niki
Yak Posting Veteran
51 Posts |
Posted - 2014-06-16 : 17:13:28
|
Hello,I want to build the dynamic column header as K(s), 1(s)....12(s) etc based on student 's grade level. Is it possible ? How?select distinct Count(s.Student_Number) OVER (PARTITION BY s.Grade_Level) as '''s.Grade_Level''' + '(S)' FROM Students sNiki |
|
Mar
Starting Member
47 Posts |
Posted - 2014-06-17 : 07:36:29
|
Without any definition of your data it is impossible to help. Look at this http://www.sqlservercentral.com/Forums/Topic623711-145-1.aspx |
|
|
|
|
|