Viewing 15 posts - 451 through 465 (of 4,080 total)
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...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
July 7, 2016 at 9:57 am
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...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
July 7, 2016 at 9:50 am
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...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
July 7, 2016 at 9:47 am
Ignore previous post. I forgot you had tried qualifying the name to dbo.String_Split.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
July 7, 2016 at 9:40 am
"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...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
July 7, 2016 at 9:39 am
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...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
July 7, 2016 at 9:33 am
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.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
July 7, 2016 at 7:46 am
You always cut to the heart of the pork chop... errrrr matter..... Jeff 😀
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
July 7, 2016 at 7:42 am
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...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
July 6, 2016 at 5:11 pm
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...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
July 6, 2016 at 3:16 pm
Yes. I'm not sure why it wasn't letting me post that.
More importantly: Does it work for you?
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
July 6, 2016 at 2:10 pm
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...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
July 6, 2016 at 1:36 pm
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...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
July 6, 2016 at 1:00 pm
Robin, you can absolutely do it your way. As JLS said, there are many ways to solve a problem. There are always tradeoffs though. ...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
July 5, 2016 at 2:44 pm
Just realized what you meant by the white space issue. The unformatted lines might have more than one space between the number and the word "Admission(s)" or "Discharge(s)"....
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
July 5, 2016 at 9:15 am
Viewing 15 posts - 451 through 465 (of 4,080 total)