We've been talking at cross purposes, then.  When you said "This is exactly what I am trying to achieve", I took that as a reply to my question "What...

But why is that a problem?  You can have your front end display the measurements in any unit you like, so why does it matter what units they're stored in?...

I can't help you with your VB code, I'm afraid - I don't know enough about it.  If you use an Extended Events session or Profiler trace to capture the...

I still don't understand.  What are you trying to do - update the table to turn mm into inches?  I would advise you to store data in consistent units -...

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