Viewing 15 posts - 2,026 through 2,040 (of 2,469 total)
Something similar was discussed just yesterday so this's still fresh in my mind:
Select A.* from tblPhoneFaxEmail A
inner join
(select PhoneFaxEmail, min(PhoneFaxEmailID) PhoneFaxEmailID from tblPhoneFaxEmail
Group By PhoneFaxEmail) B
on
A.PhoneFaxEmailID = B.PhoneFaxEmailID
Order...
**ASCII stupid question, get a stupid ANSI !!!**
June 30, 2005 at 6:08 am
Look on the bright side Michael - at least they're asking the right questions now!
The IT world is full of examples of deadweight legacy applications created when no one...
**ASCII stupid question, get a stupid ANSI !!!**
June 29, 2005 at 10:06 pm
Even bigger whoops for Simon Galbraith whoever he is - "married with mistress" ?!?! Now what's that all about ?! AND his Amex# as well ?!
sswords - why do you...
**ASCII stupid question, get a stupid ANSI !!!**
June 29, 2005 at 4:38 pm
I am going to disagree with you Remi (yes I DARE....)
The users are terrified of you - even if you say "hth" to put them at ease they'll still be...
**ASCII stupid question, get a stupid ANSI !!!**
June 29, 2005 at 3:25 pm
Did you try under "formula" - did EM not allow you to create this ? what error msg did you get ?
**ASCII stupid question, get a stupid ANSI !!!**
June 29, 2005 at 3:08 pm
okay - looks like he's compiling one himself - maybe we'll just do a cross join and credit him with even more posts....<:-)
**ASCII stupid question, get a stupid ANSI !!!**
June 29, 2005 at 3:04 pm
Yes - splly. since Remi posts at least one "hth" for every solution he provides...
Whenever I have some spare time I gather statistics on him and once I have them...
**ASCII stupid question, get a stupid ANSI !!!**
June 29, 2005 at 3:02 pm
Awww Remi! I was only kidding - you know that scc.com would shut down if you went away!!!
**ASCII stupid question, get a stupid ANSI !!!**
June 29, 2005 at 2:12 pm
Ah - the cross join - one that almost every single book just skims over because they can never find a use for it (except in "high level mathematical functions...
**ASCII stupid question, get a stupid ANSI !!!**
June 29, 2005 at 2:00 pm
Remi - his (her ?!) original request was only "how to create" - not how to optimise once created...
what is the third language ?!
**ASCII stupid question, get a stupid ANSI !!!**
June 29, 2005 at 12:28 pm
what's the third language ?!
I'll be happy to point out any more spelling errors if you want (I notice them all the time ...I only keep quiet 'cos that's the...
**ASCII stupid question, get a stupid ANSI !!!**
June 29, 2005 at 12:19 pm
Remi - "pourcent" ?!?! tsk! tsk! so full of typos today...<;-)
**ASCII stupid question, get a stupid ANSI !!!**
June 29, 2005 at 12:10 pm
Do you mean - you want your "sort" field to be automtically populated with last 2 digits of phone# ?!
Then (in EM) - under "formula" for sort field in table...
**ASCII stupid question, get a stupid ANSI !!!**
June 29, 2005 at 12:09 pm
What is the datatype for your phone# ?! If you only want to sort on the last 2 digits then you can do that without having an additional sort field....(what...
**ASCII stupid question, get a stupid ANSI !!!**
June 29, 2005 at 11:30 am
Remi - read through the second half of my response (you're NOT paying attention!!)...
I've said that Jay's requirements and table def could actually work with Francis' solution!
**ASCII stupid question, get a stupid ANSI !!!**
June 29, 2005 at 10:41 am
Viewing 15 posts - 2,026 through 2,040 (of 2,469 total)