I have a strange SQL question, I'm not sure even what term I would use to search the archive, but I did try looking, for what it's worth.
I have a RA database which tracks incoming returns and service performed on those units. That table (RA) contains a SerialNumber and a CreateDate/Time stamp. What I need is SQL that will check if there is more than one entry for a particular serial number in a 90-day time-span. IE: RAID SerialNumber CreateDate -------------------------------------------------------------- 1 ABC12345 05/20/2003 2 DFA23466 05/21/2003 3 GBA16623 06/01/2003 etc etc 156 ABC12345 07/26/2003 Since ABC12345 occured twice within a 90-day period, I need to get that serial number. Any suggestions? I know I could do it with multiple queries, but looking for a better solution. Thanks! --- Josh Remus Network Manager ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
