Hi,

This should do it.

DECLARE @table TABLE (number DECIMAL(19,15))

INSERT INTO @table VALUES (-4.0283739395038591)

INSERT INTO @table VALUES (9.803921568627450)

INSERT INTO @table VALUES (-6.358128786459309)

SELECT CONVERT(VARCHAR(4),CONVERT(INT,ROUND(CAST(number AS DECIMAL(4,2)), 0))) + '%'

FROM @table

Thanks,

Simon

You could try this, but i haven't tested it:

delete d.*, dp.*, dv.*, dbv.*

from document as d

left join jocumentProp as dp on dp.docID = d.docID

left join docVersion as dv on...

Hi,

Can't you backup the reports server DB from the one server, restore it on the other server, and then using the reports services configuration manager change the the database/server details?

Thanks,

Simon

Hi,

Check out this link. You can specify a failover partner in the db connection string of the application.

http://technet.microsoft.com/en-us/library/cc917713.aspx

Thanks,

Simon

You could try putting a ROWLOCK hint on your delete statement that might help.

Can you login on the remote box with that user?

Hi,

In the end i did manage to get this to run through the command line by using the following:

sqlcompare /server1:xx.xx.xx.xx/database1:master /username1:%username% /password1:%password% /makesnapshot:"%folderpath%\master.snp"

I've got this running in a batch file,...

Nice one thanks Grant.

I've just started playing with it now. I can get it to generate the snapshots i want but i'm trying to find out if i can write...

Hi,

They're physical servers so that's not possible unfortunately.

Thanks,

Simon

Nice one thanks. I'm getting some 404 errors too. Hopefully i'll be able to hack enough info out to get started though.

Cheers,

Simon

Someone else might know of a way but that's all i could come up with 🙂

If you check Gail's explanation here[/url] then this should help you. She explains lookups very well.

The other 2 articles in the series are also very useful and worth a read...

Hi,

The move option will definitely move the report and as far as i know there is no option to copy. I had a similar problem to this and what i...

When using convert you need to specify the style. So in your case the convert would look like this:

SELECT CONVERT(DATETIME,'21/12/2010 00:00:00',103)

That will convert your varchar to a date for you....

What format are your Varchar(50) dates in?