Hey Grant,

Thanks for taking the time to write your detailed reply.

The single biggest thing I got from your post is to test, test, test.  I do know I'm getting MUCH...

Thanks for all the replies, very much appreciated.

@desnorton

If the source and destination tables are the same structure, you can swap out the partitions

Thanks, I'll Google how to do...

• This reply was modified 4 years, 8 months ago by  Scott In Sydney.

I did think of one other approach:

Integration Services Catalogs
   SSISDB
      #Environments (just so this would sort as the top folder)
...

Me too...I have idiot DBA's.

I agree

Thanks Thom.

I've edited my OP to attach the SP.

I've finished the SP so include it here for suggested improvements.

I've written it to SSISDB.dbo.spRunPackage.  Since there are no dbo.* SP's in...

@scdecade:

1) returns all project records if all inputs are nulls

Yes, as a convenience to the end user to review the data (the data volume is small ~ 250...

@SSC-Insane

I just think that t-sql isn't exactly a hugely flexible language

Agreed.  Hopefully it will improve over time and add some of the modern constructs from today's programming languages.  But I'll...

Hi @scdecade,

Ok, here are my SP's but first some background...

We currently have a flattened, denormalized operational table.  There is a lot of junk in that table.  I'm looking...

Does anyone know how to read the Powershell XML output into a table of columns?

Thanks for all the replies 🙂

@scottpletcher:  D'oh!  Sometimes you just don't see what's obvious.

@desnorton:

The reason is that SQL does not short-circuit the OR, and has to...

These approaches work for me...

First, xp_cmdshell will launch a cmd.exe process, so if we want to use Powershell, we have to launch Powershell as a sub-process within cmd.exe, and pass...

Thanks Steve.  Yes I have, although the changes do seem to take effect immediately.  IOW, ProxyServerA works, change to ProxyServerB, ok out of Tools..., fails, reverse this, works, all without...

Hi Steve,

Apologies for the late reply.  Thanks for that.

While I'm really enjoying working with SQL Server, unfortunately few of my colleagues are proficient in SQL Server.  Or, if they are,...

I've worked out the math for the first part.  The optional part...I wouldn't have a clue.

Here's the code:

ALTER   FUNCTION [dbo].[NGrams8k]
(
  @string varchar(MAX), -- Input...

• This reply was modified 5 years, 6 months ago by  Scott In Sydney.

Thanks @Eirikur, I appreciate you confirming my approach and adding the performance enhancement.

I do try to learn from answers posted, not merely running with the advice, so I...