Drew,

No one is asking you to spoon feed anything, you made a comment so back it up with the intend results. If you wanted to contribute to the question by...

Drew,

To better understand can you please supply a re-structured query that would achieve the same results. This would help to put a method to result. Which I assume is just...

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

To add to Phil,

You can also highlight and object in the object explore and then hit F7 to open Object Explorer Details.

Once in the OED you can navigate to folders...

I went on the assumption you wanted the UP & DOWN.

SELECT
   [WeightDte],
   [WhatWeight],
   CASE
     WHEN LEAD([WhatWeight],1) OVER...

• This reply was modified 5 years, 2 months ago by  inkosi_dba_dev.
• This reply was modified 5 years, 2 months ago by  inkosi_dba_dev.
• This reply was modified 5 years, 2 months ago by  inkosi_dba_dev. Reason: Missed a ")" on second line of case statement