Update concatenation records in sql server 2005 1

[macsql1]

Good Morning,

Using SQL server 2005. I have 200 records and want to update ALL field with URL along with GUID where GUID is unique for every record

Here '<a href=

https://testlog.com/main.aspx?id={926849y2-K6Y4-D11-L692-80927B2M03E2}>GroupOne</a>'is

constant and would like to insert GUID dynamically, also {GUID} varies for each records.

Table Groupone
---
Grouponeid (pk,uniqueidentifier,not null)
gfieldone (nvarchar(250),null)
datemodifiedon(datetime,null)

Kindly let me know where i am missing.

update Groupone
set gfieldone = '<a href=

https://testlog.com/main.aspx?id={'+Grouponeid+'}>GroupOne</a>'

from Groupone
where
datemodifiedon>'01-23-2009'

thank in advance

mac

 

[markros]

The statement as is seems correct to me, what is not working?

Try first SELECT instead of UPDATE, e.g.

select '<a href=

https://testlog.com/main.aspx?id={'+Grouponeid+'}>GroupOne</a>'

as NewValue from Groupone where datemodifiedon>'01-23-2009'

Your date comparision may not be working correctly.

 

[gmmastros]

Try this:

update Groupone
set gfieldone = '<a href=[URL unfurl="true"]https://testlog.com/main.aspx?id={'+Convert(VarChar(50),[/URL] Grouponeid) +'}>GroupOne</a>'
from Groupone
where
datemodifiedon>'01-23-2009'

In the future, I would encourage you to indicate what the error message is. It really does help a lot.

In this case, the error message should have been:

[red]The data types varchar and uniqueidentifier are incompatible in the add operator.[/red]

-George

"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom