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
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...
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...
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...
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...
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...
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...
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...
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...
October 4, 2010 at 3:17 am
Viewing 9 posts - 1 through 9 (of 9 total)