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 |
|
lebz
Starting Member
7 Posts |
 Posted - 2011-07-11 : 10:12:05
|
| Hi,How do i create an indefitite period number? I have created a quesry below that brings up wbs1,wbs2,wbs3,period numner and pr umber up to period 24 but i want the query to bring more periods with having to write more "period numbers"?here is the query:SELECT pr.PRNumber, w1.Code as 'WBS Code1', w2.Code as 'WBS Code2', w3.Code 'WBS Code3',(Case When pp.periodnumber = 1 Then Sum(a.value*c.Ratio/100) else 0 end) as 'Period1',(Case When pp.periodnumber = 2 Then Sum(a.value*c.Ratio/100) else 0 end) as 'Period2',(Case When pp.periodnumber = 3 Then Sum(a.value*c.Ratio/100) else 0 end) as 'Period3',(Case When pp.periodnumber = 4 Then Sum(a.value*c.Ratio/100) else 0 end) as 'Period4',(Case When pp.periodnumber = 5 Then Sum(a.value*c.Ratio/100) else 0 end) as 'Period5',(Case When pp.periodnumber = 6 Then Sum(a.value*c.Ratio/100) else 0 end) as 'Period6',tshepotshepo |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2011-07-11 : 15:14:06
|
you will need to use dynamic SQL to do that
KH[spoiler]Time is always against us[/spoiler] |
 |
|
|
|
|
|
|
|
dates