Forum Replies Created
Viewing 15 posts - 2,146 through 2,160 (of 3,957 total)
-
RE: My BiPolar Users aka Sort a AlphaNumeric Field as if its Numeric
David Burrows (1/16/2013)
or...ORDER BY RIGHT(SPACE(20)+BipolarNumbers,20) ASC+1
-
RE: Manipulate Horizontal Hierarchy with UNPIVOT
You might want to look into using the CROSS APPLY VALUES approach to UNPIVOT (see the first article in my signature links). I find it much more readable that...
-
RE: Are the posted questions getting worse?
Lynn Pettis (1/15/2013)
dwain.c (1/15/2013)
Thought I'd resurrect this thread which has now gone dormant for nearly 24 hours to say:Woooohoooo!!! My 2000th post! Time to celebrate!
Good grief! Seems...
-
RE: My BiPolar Users aka Sort a AlphaNumeric Field as if its Numeric
Lynn Pettis (1/15/2013)
Is it wrong to be picky when it's wrong?? :unsure:Still, I should have caught the simpler method. Good work!
Of course not. That's the good thing about...
-
RE: Are the posted questions getting worse?
Thought I'd resurrect this thread which has now gone dormant for nearly 24 hours to say:
Woooohoooo!!! My 2000th post! Time to celebrate!
Good grief! Seems like only yesterday...
-
RE: My BiPolar Users aka Sort a AlphaNumeric Field as if its Numeric
Lynn Pettis (1/15/2013)
Lynn Pettis (1/15/2013)
Can't believe I missed such an easy solution. I guess that's what I get for making things harder than the need to be at first.Except,...
-
RE: My BiPolar Users aka Sort a AlphaNumeric Field as if its Numeric
Lynn Pettis (1/15/2013)
Can't believe I missed such an easy solution. I guess that's what I get for making things harder than the need to be at first.Shoot man! ...
-
RE: getting Email addresses from Text
I just went through a similar exercise in this thread:
http://www.sqlservercentral.com/Forums/Topic1402134-391-1.aspx
It's farily long but I think you'll find some useful examples in it. Towards the end of it is an...
-
RE: My BiPolar Users aka Sort a AlphaNumeric Field as if its Numeric
Lynn Pettis (1/15/2013)
Please compare the following two pieces of code:WITH SampleData (BipolarNumbers) AS (
SELECT '1'
UNION ALL SELECT '100231-A'
UNION...
-
RE: UDF Table
Lynn Pettis (1/15/2013)
dwain.c (1/15/2013)
Lynn Pettis (1/15/2013)
dwain.c (1/15/2013)
Lynn Pettis (1/15/2013)
dwain.c (1/15/2013)
Yes indeed.It appears the force is not with me this morning, oh master. 😛
Does this mean you have looked at the...
-
RE: UDF Table
Lynn Pettis (1/15/2013)
dwain.c (1/15/2013)
Lynn Pettis (1/15/2013)
dwain.c (1/15/2013)
Yes indeed.It appears the force is not with me this morning, oh master. 😛
Does this mean you have looked at the thread you and...
-
RE: UDF Table
Lynn Pettis (1/15/2013)
dwain.c (1/15/2013)
Yes indeed.It appears the force is not with me this morning, oh master. 😛
Does this mean you have looked at the thread you and I posted on?
Master...
-
RE: UDF Table
Yes indeed.
It appears the force is not with me this morning, oh master. 😛
-
RE: UDF Table
Lynn Pettis (1/15/2013)
dwain.c (1/15/2013)
2. When you check for a date range, BETWEEN is not recommended. You should use >= @StartDate and <= @EndDate.I'd like to expand on this one...
-
RE: My BiPolar Users aka Sort a AlphaNumeric Field as if its Numeric
BTW. You should be familiar with the issues of using ISNUMERIC() if you're going to use it.
Viewing 15 posts - 2,146 through 2,160 (of 3,957 total)