Forum Replies Created

Viewing 4 posts - 1 through 5 (of 5 total)

  • RE: Need a SQL2008 view that conditionally counts rows with reset

    Thank you so much!

    May 22, 2015 at 12:12 pm

    #1800117

  • RE: Need a SQL2008 view that conditionally counts rows with reset

    CREATE TABLE mytable(

    Vendor INT

    , Item INT

    , StatusDate DATE

    , PassDate DATE

    , Faildate DATE

    );

    INSERT INTO mytable(Vendor,Item,StatusDate,PassDate,Faildate) VALUES (100,5632,'5/9/2010','5/9/2010',NULL);

    INSERT INTO mytable(Vendor,Item,StatusDate,PassDate,Faildate) VALUES (100,5632,'12/15/2012','12/15/2012',NULL);

    INSERT INTO mytable(Vendor,Item,StatusDate,PassDate,Faildate) VALUES (100,5632,'5/25/2013','5/25/2013',NULL);

    INSERT INTO...

    May 22, 2015 at 11:56 am

    #1800112

  • RE: Need a SQL2008 view that conditionally counts rows with reset

    Here's the insert. Thx for any assistance.

    CREATE TABLE mytable(

    Vendor INT

    , Item INT

    , StatusDate DATE

    , PassDate DATE

    , Faildate DATE

    );

    INSERT INTO mytable(Vendor,Item,StatusDate,PassDate,Faildate) VALUES (100,5632,'5/9/2010','5/9/2010',NULL);

    INSERT INTO mytable(Vendor,Item,StatusDate,PassDate,Faildate) VALUES...

    May 22, 2015 at 11:53 am

    #1800111

  • RE: Need a SQL2008 view that conditionally counts rows with reset

    Here's the Insert. Thx for any assistance.

    CREATE TABLE mytable(

    Vendor INTEGER(3)

    , Item INTEGER(4)

    , StatusDate DATE

    , PassDate DATE

    , Faildate DATE

    );

    INSERT INTO mytable(Vendor,Item,StatusDate,PassDate,Faildate) VALUES (100,5632,'5/9/2010','5/9/2010',NULL);

    INSERT INTO mytable(Vendor,Item,StatusDate,PassDate,Faildate)...

    May 22, 2015 at 11:51 am

    #1800110

Viewing 4 posts - 1 through 5 (of 5 total)