CORRECTION:

poll_id is not a primary key or unique value, sits in a local dev table

Thanks!

Thanks, as this approach works, I had the rotation #s backwards, home teams are always denoted with an even number, so i did the processing with rotation%2 = 0

The reason why this is an nchar (string) in this example is the data did not come across in the import as a dated format. Some of the data in...

Thanks, this is the right track: it renders both Illinois (the queried team parameter) and its opponent for that date  in one record. I'll play around with this a bit...

HI, thanks for the answers and the time presenting your insights. I've tried using the arg value available to LAG function lag(score,1) in various combinations with and without Case When,...

• This reply was modified 2 years, 5 months ago by  Zososql.
• This reply was modified 2 years, 5 months ago by  Zososql.

Thanks - the problem lies within the sourceid will appear multiple times in both tables that are associated with the customerid , and need to devise a JOIN between the...

OK, thanks for all insights / advice, if I have more roadblock with this, i'll come back with more indepth questions/sample data.
Zo

OK, thank you for this- if it can still exist as a derived column format (and the CTE can be recognized as a "column"), then yes, thats the desired format.

Thanks for your insights and help Luis.Here's what i really want to do is group all the customerids and add up the instances that these statuses occur, but here...

Steve , I reassign aliases to the orders table reference in the subquery, and try this subquery, i get null for the Total summary (on the rollup), tried doing IsNull...

Thanks Steve, let me see if this is on the right track, which it could be . Appreciate your insight.
Z

OK thanks... again the problem lies with each unique customerID has to produce a result with the above formula, the output needs to be something similar to

CUSTID  HOLDING