Results 1 to 4 of 4

Thread: Hi Team

  1. #1
    Join Date
    Sep 2011
    Posts
    2

    Smile Unanswered: Hi Team

    i need to fetch the data with all columns from a table based on the condition where update_date<9/15/2011 4:59:27 pm

  2. #2
    Join Date
    Nov 2003
    Posts
    2,935
    Provided Answers: 12
    i need to fetch the data with all columns from a table based on the condition
    Well, then just do that.
    What's your question?

  3. #3
    Join Date
    Sep 2011
    Posts
    2

    Smile Hi Team

    my question is i need to fetch the data from source table and staging table based on the update_date( it is in the format like
    10/26/2002 5:52:58 AM) attribute and do the minus query to test the count?pls let me know for further clarification on the question raised by me.

  4. #4
    Join Date
    Nov 2003
    Posts
    2,935
    Provided Answers: 12
    Please post the structure of your tables (ideally as CREATE TABLE statements)
    Post some sample data
    Post the desired output based on the sample data
    And post anything you have tried so far.

    Btw: DATE columns don't have a format...

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •