Sue

Could not find the dropdown but found this solution that works.

Go to Report on Report Manager, Click properties of report, under the report definition you will...

Sue

Many thanks. We are backing up both the ReportServer and ReportServerTempDB so based on your information I am happy that we are backing up the reports.

Many...

I have looked at all the responses and still having trouble trying to get it to work. I hope I can explain it a bit better.

The table is created and...

Thanks John, I will give it a try.:-)

I have found a solution

update c

set [Description] =

Replace([Description], [Description] ,(t.accountid + ' - ' + [Description]) )

...

Koen and Kingston

Many, many, many thanks. It works a treat.

Also to Sergiy, thanks as I have included the WHERE code you suggested to make sure it does not keep...

The script that works is

SELECT

d.description, d.account, c.city, c.state, c.zipcode,

--set [Description] =

Replace(d.Description, d.Description ,(c.zipcode + ' - ' + d.Description) )

FROM [DocumentManagement].[dbo].[LesDescription] as d

inner join [DocumentManagement].[dbo].[LesCities] as...

Many thanks Sergiy

If I run the SET command I get an "incorrect Syntax near '=' " message.

I ran

Select (City + ' - ' + [Zip-Code] + ' -...

Koen

Sorry forgot to say the Description column also has additional data after the City so cannot just bring in the City and Zip-code from another table. Need to use the...

Thanks anyway.

Les

TinDog, Many thanks but I was actually looking for a way to send several reports to the same email and not having 1 report with several campaigns.

Many thanks:cool:

SSCommitted, Many thanks I have tried the "s2 = SUBSTRING(someString,CHARINDEX('PP', someString)+2,8000)" option and it works well for the entries in question However for some entries that have no PP in...

Alvin, No I'm from Australia and it is for a donation campaign for a church.:-)

Thank you for the suggestion.

I have actually come up with a different solution

[font="Comic Sans MS"]Use Reporting

SELECT

--Campaign organistion Data

GC.[CampaignID] as Campaign_CampaignID

,GC.[OrganisationName] as Campaign_OrganisationName

,GC.[CampaignName]as Campaign_CampaignName

--Donor Data

,D.[UniqueID] as Donor_UniqueDonorId

,D.[PPNo] as Donor_PPNo

,D.[CampaignID] as...