Reputation
251
Top tag
Next privilege 300 Rep.
Create new tags
Badges
2 8
Newest
 Yearling
Impact
~5k people reached

  • 0 posts edited
  • 0 helpful flags
  • 8 votes cast
Mar
23
accepted Compare Past Records to Most Recent Record
Mar
23
revised Compare Past Records to Most Recent Record
updated post
Mar
23
revised Compare Past Records to Most Recent Record
updated post
Mar
23
asked Compare Past Records to Most Recent Record
Feb
25
accepted How to compare and aggregate data in a table
Feb
23
comment How to compare and aggregate data in a table
I simply copied and pasted. Actual query is part of a larger query.
Feb
23
comment How to compare and aggregate data in a table
Good call on comparing Execution Plan.
Feb
23
comment How to compare and aggregate data in a table
Thank JohnG, but that was catching all cases. I believe I figured it out. I just posted the solution.
Feb
23
answered How to compare and aggregate data in a table
Feb
23
comment How to compare and aggregate data in a table
There are no more than 3 levels
Feb
23
comment How to compare and aggregate data in a table
if I change the last record for 100 to: ,( 4, 100, 1, 2, '2016-01-10 07:35:02.123' ) the query still return ispassed = 0. Would expect it to be 1 since there are 2 PASSes for 2 different LEVELS.
Feb
23
comment How to compare and aggregate data in a table
@Aaron Bertran I added more information to the post. I am coming up a little short on my solution. Any help is very much appreciated.
Feb
23
revised How to compare and aggregate data in a table
Added additional information
Feb
23
accepted How to compare current record with previous records
Feb
23
comment How to compare and aggregate data in a table
@RLF yes it would still produce an ISPASSED = 1 because there are still 2 PASSes for 2 different LEVELS
Feb
23
asked How to compare and aggregate data in a table
Feb
23
revised How to compare current record with previous records
updated post with additional information
Feb
22
asked How to compare current record with previous records
Feb
18
awarded  Yearling
Feb
16
accepted How to use CTE to Compare Values