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...
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...
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...
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...
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 ?
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....<:-)
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...
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!!!
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...
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 ?!
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...
June 29, 2005 at 12:19 pm
Remi - "pourcent" ?!?! tsk! tsk! so full of typos today...<;-)
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...
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...
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!
June 29, 2005 at 10:41 am
Viewing 15 posts - 2,026 through 2,040 (of 2,469 total)