Forum Replies Created

Viewing 15 posts - 61 through 75 (of 183 total)

  • RE: Company Calender

    Hello

    I have attached sample data in a csv formats and the three table structures as a text file, i hope this works.

    this is the query i used:

    SELECT Returns.ReturnDate,...

  • RE: Something wrong with this join...

    Hello

    I want to use query 2 and 3 join together to return an accurate result set

  • RE: Blank Data

    What will i have to write to extract records that are not blank?

  • RE: Blank Data

    Thanks

    Your a star!!!

  • RE: Query....

    1-placed an order over a certain amount -(all orders)

    2-requested for an order over a certain amount to be delivered to a different address,-( all orders for new customers over 90...

  • RE: Query....

    Any customer who registered within the last 30 days

  • RE: Slow running queries

    Thanks Gail

    Was able to attache it as a zip file

  • RE: Slow running queries

    Not able to attached execution query plans, file type not permitted

  • RE: Slow running queries

    the execution plan is graphical, how will i be able to send that to you?

  • RE: Slow running queries

    When you say table structure, do you mean the create table query?

  • RE: Next Day

    And if i would like to find out orders placed by the a customer within a 7 day period will i use:

    DATEDIFF(dd,T_OrderHeader.OrderDate,GETDATE()) BETWEEN 1 AND 7)

  • RE: Last Order Placed

    I got the right result, my mind was going towards an inequlity or something syntax to be needed - Thanks

  • RE: Last Order Placed

    I want know the last time a customer placed an order in addtion to the information required

  • RE: Quey Tunning

    Yeah, got one question for you though, what are the best and easily comprehensible books out there to understand T-SQL development?

  • RE: Quey Tunning

    Fixed, incorrect placement of syntax, eventually used:

    WHEN 'REFUND' THEN - CAST (Amount AS MONEY)

Viewing 15 posts - 61 through 75 (of 183 total)