Home Forums SQL Server 2014 Development - SQL Server 2014 Coffee sales for just 7am to 8am but for the entire year? RE: Coffee sales for just 7am to 8am but for the entire year?

  • December 19, 2017 at 11:59 am

    #1972763

    CREATE TABLE mytable(
     i_ticket_id   INT NOT NULL PRIMARY KEY
    ,s_item    VARCHAR(50) NOT NULL
    ,dt_when    DATETIME NOT NULL
    ,c_price    MONEY NOT NULL
    ,c_discount_amountMONEY NOT NULL
    );
    INSERT INTO mytable(i_ticket_id,s_item,dt_when,c_price,c_discount_amount) VALUES (164230,'Latte','2017-03-01 07:23:42.310',7.00,0.00);
    INSERT INTO mytable(i_ticket_id,s_item,dt_when,c_price,c_discount_amount) VALUES (164241,'Cappucino','2017-03-01 08:11:05.800',7.00,0.00);
    INSERT INTO mytable(i_ticket_id,s_item,dt_when,c_price,c_discount_amount) VALUES (164239,'Espresso','2017-03-01 08:23:45.903',6.00,0.00);
    INSERT INTO mytable(i_ticket_id,s_item,dt_when,c_price,c_discount_amount) VALUES (164242,'Espresso','2017-03-01 09:25:27.910',6.00,0.00);
    INSERT INTO mytable(i_ticket_id,s_item,dt_when,c_price,c_discount_amount) VALUES (164245,'Latte','2017-03-01 09:28:01.330',7.00,0.00);
    INSERT INTO mytable(i_ticket_id,s_item,dt_when,c_price,c_discount_amount) VALUES (164248,'Latte','2017-03-01 09:31:26.720',7.00,0.00);
    INSERT INTO mytable(i_ticket_id,s_item,dt_when,c_price,c_discount_amount) VALUES (164248,'Latte','2017-03-01 09:31:26.803',7.00,0.00);
    INSERT INTO mytable(i_ticket_id,s_item,dt_when,c_price,c_discount_amount) VALUES (164242,'Espresso','2017-03-01 09:40:26.087',6.00,0.00);
    INSERT INTO mytable(i_ticket_id,s_item,dt_when,c_price,c_discount_amount) VALUES (164242,'Espresso','2017-03-01 10:02:26.780',6.00,0.00);
    INSERT INTO mytable(i_ticket_id,s_item,dt_when,c_price,c_discount_amount) VALUES (164253,'Cappucino','2017-03-01 10:21:47.083',7.00,1.75);
    INSERT INTO mytable(i_ticket_id,s_item,dt_when,c_price,c_discount_amount) VALUES (164263,'Latte','2017-03-01 12:21:43.513',7.00,0.00);
    INSERT INTO mytable(i_ticket_id,s_item,dt_when,c_price,c_discount_amount) VALUES (164266,'Double Espresso','2017-03-01 13:51:13.003',8.00,0.00);
    INSERT INTO mytable(i_ticket_id,s_item,dt_when,c_price,c_discount_amount) VALUES (164275,'Latte','2017-03-01 14:04:02.710',7.00,1.75);
    INSERT INTO mytable(i_ticket_id,s_item,dt_when,c_price,c_discount_amount) VALUES (164378,'Sm Coffee Pot','2017-03-02 05:55:34.193',8.00,0.00);
    INSERT INTO mytable(i_ticket_id,s_item,dt_when,c_price,c_discount_amount) VALUES (164379,'Sm Coffee Pot','2017-03-02 06:04:46.210',8.00,0.00);
    INSERT INTO mytable(i_ticket_id,s_item,dt_when,c_price,c_discount_amount) VALUES (164381,'Lg Coffee Pot','2017-03-02 06:26:39.187',12.00,0.00);
    INSERT INTO mytable(i_ticket_id,s_item,dt_when,c_price,c_discount_amount) VALUES (164392,'Latte','2017-03-02 08:05:02.310',7.00,0.00);
    INSERT INTO mytable(i_ticket_id,s_item,dt_when,c_price,c_discount_amount) VALUES (164395,'Latte','2017-03-02 08:13:02.680',7.00,0.00);
    INSERT INTO mytable(i_ticket_id,s_item,dt_when,c_price,c_discount_amount) VALUES (164397,'Sm Coffee Pot','2017-03-02 08:20:33.860',8.00,0.00);
    INSERT INTO mytable(i_ticket_id,s_item,dt_when,c_price,c_discount_amount) VALUES (164401,'Cappucino','2017-03-02 08:36:30.353',7.00,0.00);
    INSERT INTO mytable(i_ticket_id,s_item,dt_when,c_price,c_discount_amount) VALUES (164402,'Latte','2017-03-02 08:38:36.657',7.00,0.00);
    INSERT INTO mytable(i_ticket_id,s_item,dt_when,c_price,c_discount_amount) VALUES (164402,'Latte','2017-03-02 08:38:36.660',7.00,0.00);
    INSERT INTO mytable(i_ticket_id,s_item,dt_when,c_price,c_discount_amount) VALUES (164404,'Cappucino','2017-03-02 08:41:42.840',7.00,0.00);
    INSERT INTO mytable(i_ticket_id,s_item,dt_when,c_price,c_discount_amount) VALUES (164395,'Latte','2017-03-02 09:02:01.063',7.00,0.00);
    INSERT INTO mytable(i_ticket_id,s_item,dt_when,c_price,c_discount_amount) VALUES (164413,'Latte','2017-03-02 10:19:28.853',7.00,0.00);
    INSERT INTO mytable(i_ticket_id,s_item,dt_when,c_price,c_discount_amount) VALUES (164416,'Espresso','2017-03-02 10:45:29.847',6.00,0.00);
    INSERT INTO mytable(i_ticket_id,s_item,dt_when,c_price,c_discount_amount) VALUES (164418,'Lg Coffee Pot','2017-03-02 11:33:20.280',12.00,0.00);
    INSERT INTO mytable(i_ticket_id,s_item,dt_when,c_price,c_discount_amount) VALUES (164420,'Espresso','2017-03-02 12:26:14.910',6.00,1.50);
    INSERT INTO mytable(i_ticket_id,s_item,dt_when,c_price,c_discount_amount) VALUES (164420,'Espresso','2017-03-02 12:26:14.947',6.00,1.50);
    INSERT INTO mytable(i_ticket_id,s_item,dt_when,c_price,c_discount_amount) VALUES (164424,'Cappucino','2017-03-02 13:35:07.143',7.00,0.00);
    INSERT INTO mytable(i_ticket_id,s_item,dt_when,c_price,c_discount_amount) VALUES (164424,'Cappucino','2017-03-02 13:35:07.160',7.00,0.00);
    INSERT INTO mytable(i_ticket_id,s_item,dt_when,c_price,c_discount_amount) VALUES (164472,'Iced Coffee','2017-03-02 16:34:57.690',5.00,0.00);
    INSERT INTO mytable(i_ticket_id,s_item,dt_when,c_price,c_discount_amount) VALUES (164485,'Iced Coffee','2017-03-02 20:29:01.117',5.00,0.00);
    INSERT INTO mytable(i_ticket_id,s_item,dt_when,c_price,c_discount_amount) VALUES (164547,'Sm Coffee Pot','2017-03-03 07:33:24.243',8.00,0.00);
    INSERT INTO mytable(i_ticket_id,s_item,dt_when,c_price,c_discount_amount) VALUES (164550,'Iced Coffee','2017-03-03 07:50:02.023',5.00,0.00);
    INSERT INTO mytable(i_ticket_id,s_item,dt_when,c_price,c_discount_amount) VALUES (164565,'Latte','2017-03-03 09:12:33.853',7.00,0.00);
    INSERT INTO mytable(i_ticket_id,s_item,dt_when,c_price,c_discount_amount) VALUES (164570,'Sm Coffee Pot','2017-03-03 09:38:59.373',8.00,0.00);
    INSERT INTO mytable(i_ticket_id,s_item,dt_when,c_price,c_discount_amount) VALUES (164573,'Lg Coffee Pot','2017-03-03 10:34:59.517',12.00,0.00);
    INSERT INTO mytable(i_ticket_id,s_item,dt_when,c_price,c_discount_amount) VALUES (164657,'Cappucino','2017-03-03 15:50:17.227',7.00,0.00);