Thanks Matt.

I'll try the UDF solution first.

I think there migght be another way to skin this cat...

If I could get the [item type] table results in a concatenated format in the CTE, that would pretty much...

Sorry about the delay in reporting back ...

I tried the idea proposed by Lowell, on the same day. I had to try a modified version as my table structure...

Like I pointed out in the example, the value in ID column doesn't necessarily have t match the integer value in the 'VARCHAR ID' column

Ramesh,

Thanks for the solution, it works great.

Now I'll try to build it using Dynamic SQL, as there could be 10 - 15 code tables involved and we don't always know...

I'd suggest you also read this article.....

http://www.sqlservercentral.com/articles/Administration/61680/

FULL backups do not effect the Log Shipping thats in place.

But if you do not want to affect anythig else try using 'COPY_ONLY' clause in your BACKUP DATABASE command.

hope it...

Backups are upto date as of the minute they finish i.e. all the transactions that happen during the backup process are also backed up (if they are commited before the...

Thanks again David.

Thats exactly what I tried and it worked.

Unconventional solutions for unconventional situations....

_Ub

Thanks for the reply David.

The problem, for me, is more with the table definitions than with the data. I know I said 'data too' in the post, but if...

Are you familar with backup and restore process?

Right Click on database >> Tasks >> Backup

similarly...

Right Click on database >> Tasks >> Restore

Is it a local server (same machine as you are on) or a different server?

Some Sql Server Editions do not allow 'remote connections' by default.

You want to open SAC [Surface...

Yes.. thats what I heard too. SP3 will be out sometime in December this year, definitely before the end of the year.

Great Suggestion Steve... Now I have another good resource to add to my library.

As always thanks a lot.

Steve Jones - Editor (9/8/2008)

---

I'd suggest you do some reading at the...

This is what we use:

ALTER FUNCTION dbo.Translate

( @SourceVARCHAR(8000)

, @ReplaceCharOrder VARCHAR(8000)

, @ReplaceWithCharOrderVARCHAR(8000)

)

RETURNS VARCHAR(8000) AS

/* * * * * * * *...