Post reply

Need help on queries to select, compare and insert to a new table

  • March 8, 2005 at 10:26 pm

    #88277

    I am new in using SQL.  My problem is as follow:

    Table-A has two date columns.  They are date1 and date2. 

    Table-B has just one date column. 

    I have to take date1 from Table-A and find a equal date from Table-B. If found, Return the date from the next record (from Table-B). 

    The value returned from Table-B will then be compared with Date2 (From Table-A).  If these dates are not equal, then insert the value of Date1 and Date2 to Table-C.

    Can this be possible done with Stored Procedure?  Example please. 

    Thank you in advance.

     

     

  • March 11, 2005 at 1:46 pm

    #546729

    hi,

    could you give what you are really trying todo/

    bassguy

  • March 11, 2005 at 7:28 pm

    #546756

    Thank you for the response, I finally got it to work.  Thanks!

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

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