At what level are you sequencing STORE2 and STORE, ItemID , ItemProgramPricingID or combination of columns?

How will UNI and UNI2 fit in this processing?

*Edited*

p.s. Please post your expected results for...

:ermm: Hope the job does not ride on this solution alone :pinch:

Just something I pieced together from what...

Third time lucky 🙂

WITH cte (itemID,ItemProgramPricingID,Price,Quantity,Points,ProgramCodeName,RowID)

AS (

SELECTipp.itemID,

ippv.ItemProgramPricingID,

ippv.Price,

ippv.Quantity,

ippv.Points,

p.Code,

ROW_NUMBER() OVER (

PARTITION BY ipp.itemID,ippv.ItemProgramPricingID,ippv.Price,ippv.Quantity,ippv.Points

ORDER BY CASE WHEN p.Code = 'STORE2' THEN 1 ELSE 2 END ASC)

FROMItemProgramPricing ipp

JOIN ItemProgramPricingValues as ippv on ippv.ItemProgramPricingID=ipp.id

JOIN Programs...

Deleted

Deleted

SELECT a.ID

,DATEADD(day,ISNULL(SUM(b.AddDays),0),GETDATE())

,DATEADD(day,a.AddDays+ISNULL(SUM(b.AddDays),0),GETDATE())

FROM #mytable a

LEFT JOIN #mytable b ON b.ID < a.ID

GROUP BY a.ID,a.AddDays

https://www.simple-talk.com/blogs/2007/07/13/using-bcp-to-export-the-contents-of-max-datatypes-to-a-file/

Why are you posting this again when the solution was posted in another topic?

You cannot pass a variable number of columns to reporting services.

You have to use a matrix...

;WITH cte (RowID, slot_col1, time_sched_start_dt, time_sched_end_dt)

AS (

SELECT ROW_NUMBER() OVER (ORDER BY a.time_sched_start_dt),

slot_col1, time_sched_start_dt, time_sched_end_dt

FROM #return_schedule a

),

cte2 (GroupID, time_sched_start_dt, time_sched_end_dt)

AS (

SELECT RowID-ROW_NUMBER() OVER (ORDER BY time_sched_start_dt),

time_sched_start_dt, time_sched_end_dt

FROM cte

WHERE slot_col1...

Removed as wrong solution

You will have...

Set the expression for the Hidden property for the January column to

=Switch(1<Month(Parameters!StartDate.Value),True,1>=Month(Parameters!EndDate.Value),True,1>=Month(Today),True,True,False)

February to

=Switch(2<Month(Parameters!StartDate.Value),True,2>=Month(Parameters!EndDate.Value),True,2>=Month(Today),True,True,False)

etc

Note that based on your requirements no data will be shown when the report is run in January

Why would having it as a table or matrix make any difference to the output?

If you want to persist with a table then hide columns that do not correspond to...

Removed as per previous post :doze:

Except that in one match already, with two different views of the goal line, one clearly showed no goal the...