In this case, it makes sense.

The transformation would be something like this:

@[User::CmtPrefix] + @[User::CmtPrefixLine] + replace(replace(replace(replace((DT_WSTR,2000)[Comments],"\\","\\\\"),"{","\\{"),"}","\\}"),"\r",@[User::CmtSuffixLine]+@[User::CmtPrefixLine])+@[User::CmtSuffixLine]+@[User::CmtSuffix]

I have two problems with this (correct me if I am...

Briefly explained:

I a have source table and a target table that are already filled with the same data, except for a comment field.

In the source table, the comment field is...

Stored procedures are no problem (on the target database in this case).

I wanted to avoid creating objects in the source and target databases (or use linked servers on the staging...

I meant a SQL Server 2008 Service Pack 3. I read about service pack issues on the web, so I installed the service pack 3 (on a developer edition) to...

Some additional info on this post:

This works ( a single SQL statement )

Update DeliveryConditions

set isdefault=1

where id=?

This does not work (...