As this is specialised software, perhaps you should get support from the vendor?

One possibility is the use of SYNONYMs to help you in this.

Assume that the synonyms 'point' to tables in DB1 on day 1.

On day 2, DB2 is updated. If...

It's somewhat difficult to understand exactly what is going on here, because you've posted a fairly large chunk of code, most of which is not relevant to the problem you...

First of all, are you aware of issues with numeric precision when using FLOAT? If not, I suggest you reconsider – DECIMAL() is often a better choice.

If you put the...

This is as good as it...

• This reply was modified 3 years, 10 months ago by Phil Parkin.

You should be fine. Just make sure that you set things up in your SSDT Project Properties to target the right platform.

OK, sure. Just wanted to make sure that you've considered that before setting the 'On error, go back to start and try again' option!

I understand the risk.  This is a stop gap until I can rework the SQL Job to avoid it.  The reason it would fail is due to server load...

Putting the truncate as step 1 in the SSIS package seems like the way to go – sounds like you've worked that out. This should be quick to implement.

Creating one...

Is it possible that you can post an example that contains some actual data, along with your desired results based on that example? It might also be helpful to see...

I can't see a way of doing that in SQL Agent.

What do the other steps do? Is this a sequence of T-SQL / stored procs, or do the steps include...

>3,000 points and all you provide is a screenshot? You should know better.

Jeff,

Thanks that works perfect, but I have another table(POST Above) that I'm trying to get ALL of the records GT timestamp from processed tables: ''>'' (Select last_updated from Speed_Last_Processed)

Then...

1. Whatever the optimiser chooses - the calculation of one is not dependent on the other
2. Unless you also show us the code containing the GROUP BY, this is difficult...

There is nothing built in to T-SQL which will do this for you. If you search for "T-SQL Proper Case Function" you will find loads of examples that others have...