Viewing 15 posts - 1,156 through 1,170 (of 2,894 total)
dwain.c (9/21/2012)
Still a tie then:
SELECT DAY($)
I thought the Cup is given to whoever comes first...
:hehe:
September 21, 2012 at 5:34 am
erics44 (9/21/2012)
Eugene Elutin (9/21/2012)
erics44 (9/21/2012)
Eugene Elutin (9/21/2012)
Thank you!
I really needed to check this thread on Friday!
Oh, this touching feelings to be back in Kindergarten...
:hehe:
I'm waiting for...
September 21, 2012 at 5:25 am
;with smpl
as
(
select 'A.B.C(1).D(10)' IK
union select 'A.B.C(100).D(1000).F(333)'
union select 'A.B.C(20).D(40).E(100)'
)
select SUBSTRING(IK,7,CHARINDEX(')',IK)-7) from smpl
Please follow the link in the bottom of my signature for explanation...
September 21, 2012 at 5:20 am
erics44 (9/21/2012)
Eugene Elutin (9/21/2012)
Thank you!
I really needed to check this thread on Friday!
Oh, this touching feelings to be back in Kindergarten...
:hehe:
I'm waiting for a Pub time...
September 21, 2012 at 5:13 am
I guess I found some shorter and obscure enough one!
SELECT EXP($)
It's only 13 characters long and no numbers :hehe:
September 21, 2012 at 5:02 am
...
I mainly meant obscure. SELECT LEN('a') is 13 characters. SELECT cos('') is 12 characters. Is it possible to trim any more characters off of this?
...
How did you...
September 21, 2012 at 4:56 am
SQL Kiwi (9/21/2012)
...
public static int SumDigits(int Input)
{
int...
September 21, 2012 at 4:45 am
What is the useful read!
Thank you!
I really needed to check this thread on Friday!
Oh, this touching feelings to be back in Kindergarten...
:hehe:
I'm waiting for a Pub time now!
You asked for...
September 21, 2012 at 4:27 am
ScottPletcher (9/20/2012)
...Celko's constant references to "punch cards" and "COBOL" are anachronistic -- most people now likely have little idea what he is "talking"/ranting about.
.
I'm not as old as J.Celko, but...
September 21, 2012 at 4:06 am
ScottPletcher (9/20/2012)
Set up a "hotline" so people could report any comments negative to Obama"Care". [Leftists ALWAYS lie with the official names for laws. Even in theory, although we...
September 21, 2012 at 3:55 am
...Yes CELKO is soetimes too strict, and his anwesrs are based on ideal world situation, but why Eugene is so care about it? [/color]
I wasn't arround for a while...
September 21, 2012 at 3:53 am
dwain.c (9/20/2012)
Eugene Elutin (9/20/2012)
aaron.reese (9/20/2012)
I do have to agree with the byte-bloat issue.
Can anyone beat this? its from the NHS clinical data set upload for patient details
<personGenderCodeCurrent>M</personGenderCodeCurrent>
There is nothing wrong...
September 20, 2012 at 10:34 am
Luis Cazares (9/20/2012)
Eugene Elutin (9/20/2012)
jcrawf02 (9/20/2012)
Eugene Elutin (9/19/2012)
Jeff Moden (9/18/2012)
Eugene Elutin (9/18/2012)
Please ignore this stupid remark!Easy, big guy. You're right but that's something that he would say. 😉
I've...
September 20, 2012 at 10:32 am
jcrawf02 (9/20/2012)
Eugene Elutin (9/19/2012)
Jeff Moden (9/18/2012)
Eugene Elutin (9/18/2012)
Please ignore this stupid remark!Easy, big guy. You're right but that's something that he would say. 😉
I've spent 5 minutes to...
September 20, 2012 at 7:38 am
try this: http://www.sqlservercentral.com/articles/Best+Practices/61537/
it should help you to get a prompt help.
September 20, 2012 at 7:30 am
Viewing 15 posts - 1,156 through 1,170 (of 2,894 total)