Div Goud (9/7/2012)
Thanks Lowel,how to insert the currentdate into AA table with new policy number
just expand the number of columns being updated;
...
SET AA.Polcinumber = BB.Policynumber,
Column2 = GetDate(), --a function fromt eh server
Column3 = 'Approved', --a static value
Column4 = BB.SomeOtherColumn -- a value in the other table
Lowell
--
help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!