Post reply

Need to write query for Date logic

  • May 25, 2015 at 5:13 am

    #317629

    I have a below query which have a date filter like "EST_PICK_DATE between '2015-02-01' and '2015-06-01'", where the logic is EST_PICK_DATE should be 3 months from the current month and 1st date of next month. Ex for current month MAY, EST_PICK_DATE shoulc be between '2015-02-01' and '2015-06-01'. I need to write below query dynamically. In below query i have hardcoded the value ("EST_PICK_DATE between '2015-02-01' and '2015-06-01'"), but it should take dynamically. How to achieve this?

    I am using this query in SSIS package, So Shall i do in SQL level or we should implement this logic in package? If yes, How?

    INSERT INTO STG_Open_Orders (Div_Code, net_price, gross_price) SELECT ord.DIV_CODE AS Div_Code, ord_l.NET_PRICE AS net_price, ord_l.gross_price AS gross_price, FROM ORD ord inner join ORD_L ord_l ONord.ORD_ID=ord_l.ORD_ID WHERE ord_l.EST_PICK_DATE BETWEEN '2015-02-01' AND'2015-06-01'

    Thanks in advance

  • May 25, 2015 at 5:29 am

    #1800362

    SELECT DATEADD(mm , DATEDIFF(mm , 0 , GETDATE()) , 0);

    SELECT DATEADD(mm , DATEDIFF(mm , 0 , GETDATE()) + 1 , 0);

    ________________________________________________________________
    you can lead a user to data....but you cannot make them think
    and remember....every day is a school day

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply