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...

An SSIS package can orchestrate the process for you.

Option 1

• Execute process task to call your C# executable with suitable arguments, to create the CSV
• Dataflow to import the CSV

Option...

The standard SQL Server client tool is called SSMS (SQL Server Management Studio). Download it from here. You'll need admin rights to install it, but after that you should...

I can't execute that 🙂

I mean like this

DROP TABLE IF EXISTS #Personnel

CREATE TABLE #Personnel (<column definitions>)

INSERT #Personnel
VALUES (),(),() --your sample data

--Same for #PersonnelTeam and #Team

Doing it like...

Are you able to provide your sample data in a format which we can cut & paste into SSMS, please?

That looks good to me.

This should help you dig into the hierarchy.

SELECT returns.id
      ,calc_chan_detail.channel
      ,calc_chan_detail.name
FROM
    OPENJSON(@json)
  ...