To update a table you need an UPDATE statement, not SELECT.

I don't understand the purpose of a CASE expression with 1=1 as the condition?  That condition...

Chris is right.  I take it you've got all this happening on one server.  If you're thinking of a new server, then why not move not SQL Server Agent, but...

I guess if I'd been in that position, I'd have listed a few advantages, before adding that I couldn't really think of any disadvantages.  Then I'd have turned it round...

Here you go.  I don't know how well it'll perform when you release it into the wild.  The query would be a lot simpler and perform better if you could...

Use a splitter function to split at the commas, then use simple LEFT and RIGHT to separate the ensuing column into two columns: attribute and value.  You'll then need...

Something like this:( left(Reverse(Left(REVERSE( @[User::ECGVolumeFilePath] ),FINDSTRING( REVERSE( "\\" + @[User::ECGVolumeFilePath] ),"\\",1)-1)),10) )
I may have mangled your parentheses a little, but you get the idea.  What you need to...

It looks as if you're trying to extract a date from a file path - is that right?  I think what's happening is that whatever it is that you extract...

No, you (almost) certainly don't want an index on every column.  I'd advise you to read through this series of articles, and anything else you can find on...

You can also use the Quoted Text IF Code if you don't want to quote the whole post, although that doesn't insert the quotee's name and the time of the...

Three questions:

(1) Are payments to be applied in order of receipt number, so that the lowest-numbered receipt for any store gets paid first?
(2) In your required output,...

And the expected results based on that, please?

Edit: oops, ignore that!  Didn't see your update to your post before I posted.

Thanks
John