Viewing 15 posts - 1 through 15 (of 56 total)
You can go one step further with Dwain's code and remove the table and take the two selects and combine them into a union all.
November 6, 2013 at 9:23 am
Alan.B (11/5/2013)
1) Changed @pString...
November 5, 2013 at 10:34 am
Good write-up. I used to love MERGE when it was first introduced. I was bit on a few bugs but worked through them. However, /* edit Aaron */ wrote a...
October 28, 2013 at 9:36 am
jcrawf02 (10/4/2012)
October 4, 2012 at 9:49 pm
Nadrek (6/20/2012)
Sean Lange (6/20/2012)
I too have struggled with this occasionally. I use this splitter in a lot of very unconventional ways. For example say I want to find all anchor...
June 20, 2012 at 2:14 pm
Sandor,
Have a look at Jeff Moden's splitter testing. You'll find that the inline tally table version is quite fast without needing a helper table and he's done all the testing...
June 15, 2012 at 8:22 am
ErikEckhardt (3/19/2012)
I think I will not be running this again on...
March 22, 2012 at 8:59 pm
Jeff Moden (2/25/2012)
February 25, 2012 at 7:35 pm
cfradenburg (1/18/2012)
I probably would have used "viewed" instead of "stored" but at least it's not a wording choice that makes it more likely for people to get it wrong.
Yep, I...
January 30, 2012 at 10:22 am
Very handy! Here's the code with the characters removed and the database name safely quoted.
/*************************************************************************************************
*** Server Permissions Audit ***
**************************************************************************************************
This script is used for auditing the permissions that exist on a...
November 30, 2011 at 1:54 pm
Stefan Krzywicki (10/11/2011)
Here's something fun for those of us unlucky enough to not be at PASS.
Nice.
October 11, 2011 at 2:21 pm
Probably didn't help that the job posting didn't upload either...
September 29, 2011 at 7:17 pm
Evil Kraig F (9/29/2011)
toddasd (9/29/2011)
But...it's Kansas 😛
Heheh, my reaction was: But it's FoxPro.
You might want to mention a bit more about the SQL Skills you'd like them to bring to...
September 29, 2011 at 7:15 pm
SQL Kiwi (9/22/2011)
Cliff Jones (9/22/2011)
Yes, I saw 1,2,3 and almost forgot to count the null value. Good straight forward question with all the likely wrong answers.
I did forget to...
September 22, 2011 at 8:36 pm
peter-757102 (8/12/2011)
You know how these things go
I sure do. I don't think Jeff has the varchar(max) article posted but I'm sure we'll see it featured when it is.
August 12, 2011 at 8:37 am
Viewing 15 posts - 1 through 15 (of 56 total)