I'm not following you, Drew....

If you have a large number of strings to test against, or a dynamic situation, I would populate a table (#rolechoices) and join to it as opposed to trying...

Final thought: This isn't necessarily a SQL question. You're really dealing with a quirk of Visual Studio and SSDT. You might try another...

I am insulted that you would dare accuse me of such a travesty!! :w00t:

Just kidding.

We aren't updating the same table after an insert. We are inserting...

Ignore previous post. I forgot you had tried qualifying the name to dbo.String_Split.

"SQL71502: Procedure: [Execution].[MyStoredProc] contains an unresolved reference to an object. Either the object does not exist or the reference is ambiguous because it could refer to any of the following...

Found a compromise that looks to be bulletproof. The target table for the inserts is going to get huge, so we didn't want to store GUIDs in...

I've got no other ideas at this time. I'm still waiting for a 2016 dev environment so I can't contribute anything more. Sorry.

You always cut to the heart of the pork chop... errrrr matter..... Jeff 😀

Despite what your arrows say, 2014 rounded .785 down and 2008 rounded up consistently.

I'm not familiar with the Oracle NUMBER datatype, but the documentation I glanced at suggests that in...

Already did that. I created a table with an identity column and put your text strings into it, then just kept ramping it up with the following...

Yes. I'm not sure why it wasn't letting me post that.

More importantly: Does it work for you?

Are you running SQL 2016 or Azure?

Per MSDN:

The STRING_SPLIT function is available only under compatibility level 130. If your database compatibility level is lower than 130, SQL Server will not...

Hey JLS, I think I have a solution, but for some strange reason the website won't let me post or upload the code if I spell out TRY_CONVERT more than...

Robin, you can absolutely do it your way. As JLS said, there are many ways to solve a problem. There are always tradeoffs though. ...