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 |
|
anup_snwn
Starting Member
6 Posts |
 Posted - 2008-02-04 : 05:52:53
|
| hi friendsi am using pivot keyword in query& i want passing parameter in query's "?" wordplz help me......query----------------------------------------------select * from (select no,row_number() over(Partition by [no]order by[no])as id,name,marks from q)as apivot(max(marks)FOR id in (?))AS MyPIVOT |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-02-04 : 06:00:45
|
quote:
Originally posted by anup_snwn
hi friendsi am using pivot keyword in query& i want passing parameter in query's "?" wordplz help me......query----------------------------------------------select * from (select no,row_number() over(Partition by [no]order by[no])as id,name,marks from q)as apivot(max(marks)FOR id in (?))AS MyPIVOT
you have to use dynamic sql. something like:-DECLARE @Sql varchar(8000)SET @Sql='select * from (select no,row_number() over(Partition by [no]order by[no])as id,name,marks from q)as apivot(max(marks)FOR id in (['+ REPLACE(@param,',','],[') + ']))AS MyPIVOT'EXEC(@Sql) |
 |
|
|
|
|
|
pivot (passing parameter problem)