ALTER Procedure lr as my update statement..... Declare @pc int Select @pc = MAX(pc)From test.dbo.localtest Declare @pn nvarchar(50) Select @pn= pn from test2.dbo.remotetest a where pn NOT IN (Select pn from test.dbo.localtest) begin Insert into test.dbo.localtest(pc, pn) VALUES (@pc+ 1,@pn) END
Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.
”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.