Viewing 15 posts - 1 through 15 (of 40 total)
Ok.. i used the follownig code to get what i wanted
select a.agtrefno, a.memindex from membership a
where a.memindex in (select top 5 c.memindex from membership c where c.agtrefno = a.agtrefno...
July 27, 2006 at 5:00 am
Thanks Ken, that seems to work a treat!
Did not know you could use sub queries with an in statement to refer to the main query as it were.. you learn...
July 26, 2006 at 10:15 am
sincere apologies have foudn the answer..
September 21, 2005 at 11:18 am
hi cheers for the reply,
that's what i thought of doing but i wasnt sure whether there was a neater way of doing it than self joining on a date field
appears...
September 20, 2005 at 11:32 am
thanks for the feedback guys, i think David's suggestion lokos most promising given the tool i have to use..
ta,
Alex
August 2, 2005 at 7:14 am
that's perfect Phil, many thanks
i got as far as doing using round,2 which gave me 3434.350000000000 but then couldn't get any further.
July 22, 2005 at 6:03 am
hi guys,
thanks for the responses..
im happyto use anything really, not nec a float. i needto convert a long number such as 12.8634456776 to something that resembles currency (covnerting to...
July 22, 2005 at 1:10 am
thanks for the reply!
i think im just gonna make a mapping table as it only has to be for a few numbers.
cheers,
alex
July 17, 2005 at 5:59 am
cheers guys, the second one worked a treat.
and remi- almost 3000 posts...! good work!
June 29, 2005 at 10:30 am
hi guys thanks so muchfor your replies!!
Coach James im afriad your suggestion returns 2 values for most of the records and W_Squared yours doesnt appear to work as you havent selected...
June 10, 2005 at 3:57 am
Sure ok... table financialperiods:
FY Period StartDate EndDate
1 1 01/04/2005 31/04/2005
1 2 01/05/2005 29/05/2005
1 3 30/05/2005 29/06/2006
etc etc
Table Events
Eventnumber Arrangmentnumber StartDate EndDate
1 1 01/04/2005 01/04/2005
2 1 02/04/2005 03/04/2005
3 1 01/04/2005 02/04/2005
4 2 ...
June 10, 2005 at 1:27 am
well you lost me pretty early on there!
i guess that's why i always have the problems, and you always have the answers haha!
June 9, 2005 at 12:37 pm
cheers remi.. this doesnt appear to work all too well though but i think that's down to my poor explanation.
its part of a report writing tool.. basically this particular query...
June 9, 2005 at 12:31 pm
i can always rely on you remi ;-)))
June 6, 2005 at 11:28 am
Viewing 15 posts - 1 through 15 (of 40 total)