If you already have a process, what's wrong with what you have? It doesn't seem to be that time consuming; run a back up, restore it (on a different server)...

Let's put some formatting into that code first, so we can read it:

SELECT DISTINCT comm_val,country_cd
FROM comm x,Testbl
WHERE Testbl.rowid_object = x.PARTY_ID
  AND party_typ_cd = 'Contact'
  AND...

• This reply was modified 6 years, 4 months ago by Thom A.

So you're actually trying to implement a failover?

So, are you saying you want to update the the DataSource details? How are you wanting to do this? Is Powershell an acceptable solution? Why not log into the web...

The data doesn't need to be real data; as Phil said we need a sample....

Oh you're right, Sue! That's...

SSRS uses the same formatting codes as Excel does. If you need different styles for positive and negative values then you use a ; to separate the 2. So for...

Phil's answer is the way to go here. To expand on his comment about ISNUMERIC, for this specific scenario database names that end in something like .5 and -9 would...

Are you just exporting a dataset, or are is there more involved? If the former, you could create a template Excel file, and then use SSIS to create a copy...

This is great stuff! One thing I didn't see in the article (sorry if I just missed it!) that might be worth pointing out is I believe (correct me...

The note I got back on this is that the login is a timed item, but it's device independent, so you might not log in from a device (browser/machine/etc)...

Thom, if that's the case, you are right. But for the examples provided, I can't see how it's required (excepting, possibly, the change in cost price – though any...

I think the problem here is, Phil, that the Op doesn't have historical data stored (if they did this would be trivial). As you could easily just use LAG to...

Had a bit of a Google, which led me to this topic on MSDN. According to a Microsoft Employee:

A user with minimum right such as db_datareader will be able...

You'll need to add the value of the variable first as a column, using a Derived Column Transformation (Like I showed in your other topic). Then, instead...