Viewing 15 posts - 1 through 15 (of 21 total)
CORRECTION:
poll_id is not a primary key or unique value, sits in a local dev table
October 4, 2024 at 9:42 pm
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
December 6, 2023 at 12:05 am
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...
December 5, 2023 at 5:01 pm
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...
July 26, 2022 at 10:32 pm
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,...
July 25, 2022 at 6:45 pm
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...
June 9, 2017 at 9:59 am
OK, thanks for all insights / advice, if I have more roadblock with this, i'll come back with more indepth questions/sample data.
Zo
May 26, 2017 at 4:15 pm
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.
April 19, 2017 at 7:53 am
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...
April 18, 2017 at 11:04 pm
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...
February 19, 2017 at 2:18 pm
Thanks Steve, let me see if this is on the right track, which it could be . Appreciate your insight.
Z
February 19, 2017 at 12:38 pm
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
February 18, 2017 at 12:49 pm
Viewing 15 posts - 1 through 15 (of 21 total)