I have a table"production" with fields of
How can i get a result mentioned below.
Heading1 Day1 day1 Day1 Day2 day2 Day2
Heading2 shift1 shift2 shift3 shift1 shift2 shift3
result Item1 Line&qty Line&qty Line&qty Line&qty Line&qty Line&qty
Please Help ME Thanks Andrew
Sounds like you need something more than just a query. SSRS reports are fairly easy to create
answered Nov 06, 2009 at 04:11 PM
It seems you want a dinamic table result set, in this way i would suggest using using "WITH CUBE" or "WITH ROLLUP".
Anyway, try using a dynamic table or reporting services to return this query, it should be easier.
answered Nov 18, 2009 at 02:00 PM