:) yea man... thanks!
FOR FUCKING NOTHING!
jk, client is happy and im paid.
whateve's
On 11/19/07, G Money <[EMAIL PROTECTED]> wrote:
> Cool, glad I could be of absolutely no help :)
>
> On Nov 19, 2007 10:18 AM, Tony <[EMAIL PROTECTED]> wrote:
>
> > okee dokee... i figured my way a
Cool, glad I could be of absolutely no help :)
On Nov 19, 2007 10:18 AM, Tony <[EMAIL PROTECTED]> wrote:
> okee dokee... i figured my way around it...
> and did my thing, but its all good :)
>
> tw
>
> On 11/19/07, G Money <[EMAIL PROTECTED]> wrote:
> > Then you'll need to change your querybe
using sql server.
tony
On 11/19/07, Greg Morphis <[EMAIL PROTECTED]> wrote:
> If you're using Oracle you could use 'partition by', but I don't know
> what dbms you're using. Might want to see if it has an equivalent
> function.
>
> On Nov 19, 2007 7:28 AM, <[EMAIL PROTECTED]> wrote:
> > yes... bu
okee dokee... i figured my way around it...
and did my thing, but its all good :)
tw
On 11/19/07, G Money <[EMAIL PROTECTED]> wrote:
> Then you'll need to change your querybecause the way you've got it set
> up, even if 2 things came in on the same day, for the same client, your
> DISTINCT wi
If you're using Oracle you could use 'partition by', but I don't know
what dbms you're using. Might want to see if it has an equivalent
function.
On Nov 19, 2007 7:28 AM, <[EMAIL PROTECTED]> wrote:
> yes... but there could be multiple THiNGS
> that came in on tha date.
>
> tw
>
> On 11/19/07, G M
Then you'll need to change your querybecause the way you've got it set
up, even if 2 things came in on the same day, for the same client, your
DISTINCT will ensure that you only get ONE row back for that client and that
day.
On Nov 19, 2007 8:28 AM, <[EMAIL PROTECTED]> wrote:
> yes... but the
yes... but there could be multiple THiNGS
that came in on tha date.
tw
On 11/19/07, G Money <[EMAIL PROTECTED]> wrote:
> Unless I'm crazywon't you have just ONE most recent date for each
> client
>
> On Nov 17, 2007 11:35 AM, Tony <[EMAIL PROTECTED]> wrote:
>
> > good peeps of the roundta
Unless I'm crazywon't you have just ONE most recent date for each
client
On Nov 17, 2007 11:35 AM, Tony <[EMAIL PROTECTED]> wrote:
> good peeps of the roundtable...
>
> select
>distinct a.clientNumber, max(a.dateAssigned) as mostRecent
> from
>accts a
> inner join
>clients c o
good peeps of the roundtable...
select
distinct a.clientNumber, max(a.dateAssigned) as mostRecent
from
accts a
inner join
clients c on c.clientNumber = a.clientNumber
group by
a.clientNumber
order by
mostRecent desc
to prevent having to go get another query
i want to count the