Hi Luis

Thanks for the suggestion. I may misunderstand you but I do have a parameter list - the parameter values are made by the user selecting a cell within...

Hi

I've managed to get it working by allowing the report parameter to accept nulls and using COALESCE within the query code e.g.

WHERE SalesArea = @pmArea AND Days LIKE COALESCE(@pmDays,'%')

If there's...

Hi Wayne

That's beautiful, Thank you!

I've also learnt something as I had no idea the LAG function existed. I've replicated the concept into my actual scenario and am achieving...

Hi

That is a really fantastic solution, it works perfectly and I've learnt that changes to a cte are cascaded to the source table, I will have to read up more...

Hi

Firstly, if I understand your question correctly, no the order within a period doesn't matter as each record is already an aggregation of lower level transactions.

Secondly, I have arrived at...

The Transaction_Period_Index is the ordering column. it shows the period when any activity occured on an account.

thanks but that's not an option, the base tables just show payments, positive or negative, what I'm trying to do is create a statement style table. Which I've done...

Hi

It's a simplified example and i do have more detailed data i.e. the transactions and payments. Nevertheless I need the data in this format, as it is supposed to...

Sean you were correct about the nulls. I discovered a workaround which is detailed below for reference, a fuller explanation is available via the link, perhaps it will be...

Hi Sean

It's not a null, haven't found what it is yet but it's something like a line feed, I'll keep looking...

I'm not planning on storing these values permanently in one...

Hi

Firstly thanks. Secondly, the example was a simplified version of what I'm trying to do just to get the concept across, the actual tables are a better design.

The suggestion...

Thanks for you help on this.

I've moved the update table topic to

http://www.sqlservercentral.com/Forums/Topic1558119-3077-1.aspx

Sorry me again

I've managed to build a comma separated string using a set based approach. but I'm struggling to perform an update to another table using the result.

Is it...

Hi

Yes a comma separated list of values from multiple rows is essentially what I'm trying to do and a set based approach would be great.

That said I'm still interested in...