Viewing 15 posts - 2,206 through 2,220 (of 3,957 total)
Alan - That's a very intriguing use of NTILE!
I would recommend, however that you change the way you construct your asciichar table:
;WITH asciichar(n, c) AS (
SELECT n=64+number, CHAR(64+number)
FROM [master].dbo.spt_values Tally
WHERE...
January 9, 2013 at 6:04 pm
Stefan Krzywicki (1/9/2013)
January 9, 2013 at 5:59 pm
Steven - Those FUNCTIONs look like nice work. I've saved them off for future analysis. 🙂
January 9, 2013 at 5:54 pm
drew.allen (1/9/2013)
dwain.c (1/7/2013)
Any solution posed with a CTE can always be done without the CTE by making the CTE into a derived table as Lynn has shown.
That's not entirely true....
January 9, 2013 at 5:45 pm
Evil Kraig F (1/9/2013)
Jeff Moden (1/9/2013)
dwain.c (1/8/2013)
http://www.sqlservercentral.com/Forums/Topic1403293-392-1.aspx
Come on! Surely some of you heavyweights can whip up a...
January 9, 2013 at 5:45 pm
anthony.green (1/9/2013)
ISDATE
Returns 1 if the expression is a valid date, time, or datetime value; otherwise, 0.
ISDATE returns 0 if the expression is a datetime2 value.
You are assuming sir that I...
January 9, 2013 at 3:00 am
Am I the only one that finds these kinds of SQL puzzles fun?
http://www.sqlservercentral.com/Forums/Topic1403293-392-1.aspx
Come on! Surely some of you heavyweights can whip up a cool solution to it.
January 8, 2013 at 8:49 pm
How about something simple like this?
DECLARE @layerXMLData VARCHAR(8000) =
'<polygon points=''-104.80,31.57 -104.80,31.59 -104.79,31.59 -104.79,31.57 '' id=''MT-209'' />
<polygon points=''-104.79,31.59 -104.79,31.60 -104.77,31.60 -104.77,31.59...
January 8, 2013 at 6:37 pm
opc.three (1/8/2013)
dwain.c (1/8/2013)
But isn't it true that you can TRUNCATE TABLE b first and then TRUNCATE TABLE a?
No. In my repro code both tables are empty. I am thinking it...
January 8, 2013 at 6:27 pm
I agree with Anthony that this should be done in the front end. But you may want to examine the following results and see if this gives you some...
January 8, 2013 at 6:16 pm
venkatesh.b 88975 (1/8/2013)
Thankq for your response. I need Mode column values as column name.
If you mean you have more than 3 modes and don't know how many you would need...
January 8, 2013 at 5:58 pm
Alan.B (1/8/2013)
It’s almost a shame (not really! J) that I no longer support Accounting applications...
January 8, 2013 at 5:26 pm
opc.three (1/8/2013)
dwain.c (1/8/2013)
a_ud (1/8/2013)
January 8, 2013 at 5:23 pm
Stefan Krzywicki (1/7/2013)
Steve Jones - SSC Editor (1/7/2013)
One thing to think...
January 8, 2013 at 2:30 am
a_ud (1/8/2013)
January 8, 2013 at 2:20 am
Viewing 15 posts - 2,206 through 2,220 (of 3,957 total)