Viewing 15 posts - 1,321 through 1,335 (of 3,544 total)
Lynn Pettis (6/30/2009)
Roy Ernest (6/30/2009)
Bored here at work today. I have things to do, but just can't get motivated.
Welcome to my world :blink:
Roy Ernest (6/30/2009)
Far away is close at hand in the images of elsewhere.
Anon.
June 30, 2009 at 4:44 pm
Grant Fritchey (6/30/2009)
mjarsaniya (6/30/2009)
Very few people in here would claim to be experts. I sure don't.
:laugh: You are far too modest Grant 😉
Far away is close at hand in the images of elsewhere.
Anon.
June 30, 2009 at 8:26 am
GilaMonster (6/30/2009)
David Burrows (6/30/2009)
There is a member with the name 'Anonymous'
Yeah, but I don't think it's that. If you check the screen shot, there's no profile details, the name is...
Far away is close at hand in the images of elsewhere.
Anon.
June 30, 2009 at 8:24 am
GilaMonster (6/30/2009)
Far away is close at hand in the images of elsewhere.
Anon.
June 30, 2009 at 7:12 am
SanjayAttray (6/29/2009)
in SQL server 2005 result is 1.234568E+09while in SQL 2000 result is 1.2345679E+9
Does it make any difference ?
It is dependant on the client tool
QA shows...
Far away is close at hand in the images of elsewhere.
Anon.
June 30, 2009 at 6:51 am
GilaMonster (6/29/2009)
Grant Fritchey (6/29/2009)
I used to have the 'Lack of planning' saying on the front of my PC.
I use to have MYOB
Mind Your Own Business to remind me not...
Far away is close at hand in the images of elsewhere.
Anon.
June 29, 2009 at 8:47 am
Doc (6/23/2009)
RBarryYoung (6/23/2009)
Impressive Bio Mr. Young
Nice pic too! 😉
Far away is close at hand in the images of elsewhere.
Anon.
June 23, 2009 at 7:54 am
Also you can achieve the same using PIVOT
e.g.
SELECT ACCT_DEBTOR,
[1] AS [LandLineNumber1],
[2] AS [LandLineNumber2],
[3] AS [LandLineNumber3]
FROM (SELECT ACCT_DEBTOR,OCCURRENCE,LANDLINE_CONTACT_NO FROM Post_File082_Landline_No) a
PIVOT(MAX(LANDLINE_CONTACT_NO) FOR OCCURRENCE IN ([1],[2],[3])) p...
Far away is close at hand in the images of elsewhere.
Anon.
June 23, 2009 at 6:49 am
:ermm: The THREAD is practising medicine now :blink:
Get therapy and vent your spleen all at the same time :w00t:
Far away is close at hand in the images of elsewhere.
Anon.
June 23, 2009 at 5:36 am
... RBAR to the max behind the scenes ...
Well RBAR is better than FUBAR 😛
Far away is close at hand in the images of elsewhere.
Anon.
June 22, 2009 at 3:45 am
Shame they couldn't be directed to 'he who cannot be named'
He'd be able to provide suitable answers 😀
Far away is close at hand in the images of elsewhere.
Anon.
June 19, 2009 at 6:31 am
ta.bu.shi.da.yu (6/18/2009)
Ah... but how would you get around that? Is there any way of disabling the rounding?
Use FLOOR 🙂
Far away is close at hand in the images of elsewhere.
Anon.
June 18, 2009 at 7:20 am
This is getting way tooooo serious 🙂
The THREAD's gonna get ya 😛
Far away is close at hand in the images of elsewhere.
Anon.
June 18, 2009 at 1:58 am
VM (6/17/2009)
I apologise for such a sloppy question. The thing I wanted to mainly emphasise with this question was that "correct datatypes be chosen...
Far away is close at hand in the images of elsewhere.
Anon.
June 17, 2009 at 6:55 am
Paul White (6/17/2009)
Most of the recent QODs seem to have been posted by the author of this, and from memory,...
Far away is close at hand in the images of elsewhere.
Anon.
June 17, 2009 at 6:52 am
Viewing 15 posts - 1,321 through 1,335 (of 3,544 total)