User Profile

Collapse

Profile Sidebar

Collapse
farhanm
farhanm
Last Activity: Dec 3 '08, 09:19 PM
Joined: Dec 3 '08
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • farhanm
    replied to Compare dates
    in SQL Server
    sample data

    Taker Order_no Customer_Name Item_Id Order_date Margin% Previous Order date
    ADEL 1829854 R & T REPAIR SERVICE SUP B28 38:30.0 92% 44:42.8
    ADEL 1829854 R & T REPAIR SERVICE VICTO 1407-0013 38:30.0 84% 44:42.8
    ADEL 1838392 CO WELDING SUPPLY INC PACKAGING/HANDLING/DELIVERY, OUT 10:28.0 101% 44:42.8
    ADEL 1847612 SP INDUSTRIES INC ARMSTR 069-78-110 10:58.0 112% 44:42.8
    ADEL...
    See more | Go to post

      Leave a comment:

    • farhanm
      started a topic Compare dates
      in SQL Server

      Compare dates

      I created a temp table
      select ol.order_no,ol. date_created,ol .item_id,ol.inv _mast_uid,ol.oe _hdr_uid
      INTO #temp
      from p21_view_oe_lin e ol
      where datediff(dd,ol. date_created,ge tdate()) = 7 and
      ol.source_loc_i d=108843

      I have info for last 7 days..

      I am trying to generate a report that will be results which will give me the order no for a sale if the sales margin was lower then previously...
      See more | Go to post
      No activity results to display
      Show More
      Working...