Viewing 9 posts - 1 through 9 (of 9 total)
Oddest opener - "Let's start at the beginning - where were you born?"
- how does that affect things?
- and presumably illegal on racial descrimination grounds
--------------------------------------------------------------
“Doubt is not a pleasant condition, but certainty is absurd.” Voltaire
February 28, 2011 at 3:08 am
gerg-520419 (1/31/2011)
code ...
will select just cycles. Needn't to calculate 'correct' max level beforehand.
eb3e->b->c->d->b
ab3a->b->c->d->b
This is another alternative that will show the required hierarchy and highlight where circular references begin -
WITH GroupMembers...
--------------------------------------------------------------
“Doubt is not a pleasant condition, but certainty is absurd.” Voltaire
January 31, 2011 at 9:12 am
DhruvShah (11/7/2010)
yes Different region will have different answers but when no regions mentioned we normally take US as a default region specially when we talk about dates.
No WE certainly don't...
--------------------------------------------------------------
“Doubt is not a pleasant condition, but certainty is absurd.” Voltaire
November 9, 2010 at 3:50 am
Chris Morris-439714 (11/5/2010)
I reckon this will set the whole EMAIL_No column to 1
I agree that with the data you have specified the EMAIL_NO column will always be 1 because there...
--------------------------------------------------------------
“Doubt is not a pleasant condition, but certainty is absurd.” Voltaire
November 5, 2010 at 5:40 am
To get you started - the row_number() function will return a sequence of numbers starting at 1 effectively allocating a number to each EMAIL_ID in EMAIL_ID order. The sequence restarts...
--------------------------------------------------------------
“Doubt is not a pleasant condition, but certainty is absurd.” Voltaire
November 5, 2010 at 4:02 am
I haven't seen anyone suggest 'walking the streets hoping for work because of the recession' - there was a good prgram on BBC recently on work in York 100 years...
--------------------------------------------------------------
“Doubt is not a pleasant condition, but certainty is absurd.” Voltaire
November 4, 2010 at 3:18 am
I used a subquery as a way round the problem (as follows) but is there a better solution?
Selecttables, count(*) 'count'
from(selectsubstring (so1.name, 1, 50)'tables'
fromsysobjectsso1
Whereso1.name like 'mf%'
Group By so1.name)tbl
group...
--------------------------------------------------------------
“Doubt is not a pleasant condition, but certainty is absurd.” Voltaire
October 22, 2010 at 8:42 am
i suspect that research on layout of code for productivity gains is hard to do because of the number of 'variables'.
e.g. (1) the likely reasons for reading...
--------------------------------------------------------------
“Doubt is not a pleasant condition, but certainty is absurd.” Voltaire
October 6, 2010 at 3:44 am
Slight quibble with Oleg's reply.
"When omitting the size of either char or varchar, the default size is 30 for both" implies that the default size for varchar or char in...
--------------------------------------------------------------
“Doubt is not a pleasant condition, but certainty is absurd.” Voltaire
October 4, 2010 at 3:17 am
Viewing 9 posts - 1 through 9 (of 9 total)