Viewing 15 posts - 121 through 135 (of 422 total)
Here's the article that I saw lately. I've only skimmed through it but it looks to do the sort of ordering we've been talking about. Looks interesting.
June 26, 2013 at 1:33 pm
Sean Lange (6/26/2013)
Steven Willis (6/25/2013)
So in that vein of thought, you CAN do this but not with an identity column which is of course always and only numeric.
Just because...
June 26, 2013 at 10:38 am
kiran.vaichalkar (6/25/2013)
Thanks again to every1 looking into this for me.
I was in need to generate Alphanumeric ID ( An Identity which is based on PRIMARY KEY [assigned to every...
June 25, 2013 at 10:42 pm
Hmmm...I had no idea this was possible. The concept completely slipped by me! I learned something new today. Thanks!
As for usefulness...I saw the potential as soon as I read this...
June 25, 2013 at 9:53 am
Rauf Miah (6/24/2013)
THANK YOU FOR NICE RESPONSE. THE CODE DOES THE TRICK. BUT SOON I LIKE TO LEARN THE TALLY.
Especially if one spent most of their formative years programming with...
June 24, 2013 at 9:48 am
This should do what you need. BUT please, read this article and work on getting rid of the WHILE loop.
June 23, 2013 at 8:20 pm
curious_sqldba (6/22/2013)
June 23, 2013 at 8:20 am
Brian
It looks like you have a winner! I ran a test of DelimitedSplit8K using your method against 3 other methods including the Itzik Ben-Gan method. Your version consistently outperformed the...
June 22, 2013 at 1:09 pm
Nice script. I'll let others worry about any additions/modifications such as mentioned by Aleksey. But I took the liberty of turning your script into two stored procedures. The code also...
June 21, 2013 at 2:18 pm
Here's an example where the output from one sp is passed into a second procedure which is run multiple times using dynamic sql. Maybe something here can help you.
First create...
June 20, 2013 at 3:57 pm
Chrissy321 (6/19/2013)
Column1 is varchar(100). Column2 is varchar(50).
WHERE CASE Column1 WHEN 'ABC' THEN 1 ELSE CONVERT(decimal(20,6),Column2)END) IS NOT NULL
Try putting single quotes around the '1' or cast it as VARCHAR-- the...
June 20, 2013 at 9:31 am
manavairajan (6/15/2013)
June 17, 2013 at 12:33 am
Did you run any performance tests with this? It LOOKS simpler to the eye and at first I thought it looked really good--and it still may be a better alternative...
June 15, 2013 at 1:44 am
ben.brugman (6/12/2013)
I still think your solution needs to know the output format before you make the call.
Yes, I was making the assumption that the procedure's output was known. I'm not...
June 12, 2013 at 7:09 pm
ben.brugman (6/12/2013)
Steven Willis (6/12/2013)
Here's another option you might consider:
Thanks for your contribution Steven, but or I do not get your anwser, or you are missing the point.
The question was:
How to...
June 12, 2013 at 11:31 am
Viewing 15 posts - 121 through 135 (of 422 total)