Adding variable data to column in SQL Server 2008

Question

I have a column called Description which has an account number plus text ie 123456 July 2016 Statement. There is also a column that has the account number ie 123456.

In another table I have a reference number ie 100001234. I want to be able to update the Description column to show 100001234 - 123456 July 2016 Statement. The reference number will be different for each account number but there is ONLY 1 reference number per account.

Have tried doing REPLACE but needs 3 arguments or get

Incorrect syntax near 'description'

Code:

 SELECT 
     t.[Referencenumber],
     SET [description] = (REPLACE ([Description], referencenumber + ' - ' + [Description])),
     c.[ClientID], [AccountID]
FROM 
    [Document].[dbo].[DOC.Client] AS c
INNER JOIN
    [Reporting].[dbo].[Tran] AS t ON t.Id = c.accountid

Any suggestions?

Gordon Linoff · Accepted Answer · 2016-09-20 02:12:35Z

1

You don't need replace(), but you do need an update. I don't know which table has description:

update ??
    set [description] = referencenumber + ' - ' + [Description]
from [Document].[dbo].[DOC.Client] c inner join
     [Reporting].[dbo].[Tran] t
     on t.Id = c.accountid;

answered Sep 20, 2016 at 2:12

Gordon Linoff

1.3m62 gold badges706 silver badges857 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Adding variable data to column in SQL Server 2008

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related