Thanks Gazareth, I'll have a look now I'm back at work.

I'd just found that out as the notification appeared.

Looks like it'll have to be log-shipping to move things piecemeal. Should still cut down on network traffic (or least the...

Hi again

The powers that be have now decided they only need the first 300 characters from the XML-based code I'm currently using.

I've left the code as-is and I'm using

left([Additional Notes].Comments,300)

to...

Thanks Gail.

I've written the REPLACE to get rid of the x0D's and that bit's worked.

You were right about the UNFIN, it was picking up a previous field that I hadn't...

Thanks for that Gail

I've brought back one set of records using each method and this is what I'm getting for the Response field....

My CTE:-

4 Cant change status to final

Cant change...

Just thought I'd ressurect his thread with a couple of (hopefully) quick question.

1) As I'm currently using on-the-fly collation in a lot of my scripts (using "COLLATE SQL_Latin1_General_CP1_CS_AS"), will this...

I've put all the codes into temp tables with appropriate indexes already.

I was just wondering if multiple joins were the way to go or if I could do the updates...

The field AbstractID is that type and size in the base table I'm selecting the data from.

I need to update 50 codes from the temp tables and I'm trying to...

MS doesn't recommend a great deal from the googling I've done (including ruinning SELECT statements against the ReportServer database).

I'm not familiar with any of the .NET languages so this might...

I hadn't thought of that but aren't they restricted to the basics few in 2008?

Also, things aren't quite as straightforward as they first appear.

The reports are in folders which relate...

Unfortunately I didn't set it up, I'm just having to tidy it up :crying:

Looks like I'll have to do this the long way round then.

Thanks for the input.

Just reported my own post (bet that's a first for the mods!).

Have to wait and see what happens now.

Thanks for that, I'll post the questuion in the SSRS forum with a link pointing to here.

Any ideas how I get the MODS to move the posts?

I found the Reporting Services database on the relevant server but I'm not sure what I can alter (if anything) in there to get to what I need.

Anyone any ideas?

I've already got the permissions mapped out but they are on the wrong folder.

I basically need to move all the permissions up one level before I start restricting things on...