Forum Replies Created

Viewing 15 posts - 1 through 15 (of 19 total)

  • RE: Create new Central Line based on Trend

    drew.allen - Monday, March 25, 2019 10:41 AM

    There are several things I don't understand about how your trend line is working.

    1)  I...

    March 25, 2019 at 10:57 am

    #2031700

  • RE: Create new Central Line based on Trend

    drew.allen - Thursday, March 21, 2019 10:00 AM

    You say that the central line depends on the trend, but you...

    March 25, 2019 at 6:52 am

    #2025371

  • RE: Create new Central Line based on Trend

    drew.allen - Thursday, March 21, 2019 10:00 AM

    You say that the central line depends on the trend, but you have two trends,...

    March 21, 2019 at 10:19 am

    #2025136

  • RE: Numbering a group

    Thank you Ive just added them into the partition thank you again

    July 31, 2017 at 9:00 am

    #1953402

  • RE: Numbering a group

    Luis Cazares - Monday, July 31, 2017 8:48 AM

    This option might help avoid a triangular join.

    WITH CTE AS(
      Select *,
      ...

    July 31, 2017 at 8:58 am

    #1953400

  • RE: SQL Server book

    Grant Fritchey - Wednesday, July 19, 2017 6:29 AM

    michelle.mabbs - Wednesday, July 19, 2017 4:03 AM

    July 19, 2017 at 6:49 am

    #1951602

  • RE: Striplines

    Ok so I mean I want one band of color between the upper (blue line) and lower limits (yellow line)

    hope this makes sense

    thanks

    July 11, 2017 at 2:26 am

    #1950301

  • RE: SQL Streaks

    Mark Cowne - Tuesday, July 4, 2017 8:24 AM

    Not totally clear what you want but see if this helps

    WITH OrderedSrc...

    July 6, 2017 at 2:25 am

    #1949632

  • RE: SQL Streaks

    Thom A - Tuesday, July 4, 2017 8:16 AM

    michelle.mabbs - Tuesday, July 4, 2017 8:11 AM

    July 4, 2017 at 8:18 am

    #1949328

  • RE: SQL Streaks

    HI, the ID is simply a row number partitioned by the Site and Ordered by the C_Date column

    Kr
    M

    I have revised the desired table and...

    July 4, 2017 at 8:11 am

    #1949325

  • RE: SQL Streaks

    Phil Parkin - Tuesday, July 4, 2017 7:51 AM

    michelle.mabbs - Tuesday, July 4, 2017 7:44 AM

    July 4, 2017 at 8:00 am

    #1949323

  • RE: SQL Streaks

    J Livingston SQL - Tuesday, July 4, 2017 7:40 AM

    please confirm what version of SQL you are using.....in some of your other...

    July 4, 2017 at 7:44 am

    #1949318

  • RE: SQL Streaks

    Hi thank you for your reply,

    they are just textual flags 

    I am calculating times where there are 7 or more 1s in the long run column, this...

    July 4, 2017 at 7:27 am

    #1949316

  • RE: Running total for previous 7 rows

    Neil Burton - Monday, July 3, 2017 7:57 AM

    michelle.mabbs - Monday, July 3, 2017 6:32 AM

    July 3, 2017 at 8:44 am

    #1949171

  • RE: Running total for previous 7 values where there is a 1

    sgmunson - Monday, July 3, 2017 7:26 AM

    michelle.mabbs - Monday, July 3, 2017 7:21 AM

    July 3, 2017 at 7:35 am

    #1949135

Viewing 15 posts - 1 through 15 (of 19 total)