CODEWITHSUNDEEP
sql-servert-sql
nandgate
nandgate

Reputation: 101

Update sql table columns with data from another table

UPDATE [APL4_WATERPLANT].[dbo].[PRINT_PWD] 
SET [APL4_WATERPLANT].[dbo].[PRINT_PWD].[CLT_2101] = ([APL4_WATERPLANT].[dbo].[PWD].[CLT_2101] 
FROM [APL4_WATERPLANT].[dbo].[PWD] 
WHERE [APL4_WATERPLANT].[dbo].[PWD].[DATEANDTIME] = '2013-8-13 12:00:00.000')

Whenever i try to execute this code, i get a error message. what could be the problem ?

Upvotes: 1

Views: 63

Answers (2)

Boss
Boss

Reputation: 473

Try this 

 UPDATE [APL4_WATERPLANT].[dbo].[PRINT_PWD] 
 SET [APL4_WATERPLANT].[dbo].[PRINT_PWD].[CLT_2101] = (select CLT_2101 
 FROM [APL4_WATERPLANT].[dbo].[PWD] 
 WHERE DATEANDTIME = '2013-8-13 12:00:00.000')

Upvotes: 1

abhinsit
abhinsit

Reputation: 3272

I think select is missing from the subquery:-

UPDATE    [APL4_WATERPLANT].[dbo].[PRINT_PWD] 
SET       [APL4_WATERPLANT].[dbo].[PRINT_PWD].[CLT_2101] = 
          (
              select  [APL4_WATERPLANT].[dbo].[PWD].[CLT_2101] 
              FROM    [APL4_WATERPLANT].[dbo].[PWD] 
              WHERE   [APL4_WATERPLANT].[dbo].[PWD].[DATEANDTIME] = '2013-8-13 12:00:00.000'
          )

Upvotes: 1

Related Questions