Your best bet is to maintain this information in separate content table (like
your file system does). When you occupy a block, you go and update your content
table. This way you can allways select MAX() and have the largest block. You
can certainly write some complicated sql statement to do so as well, however if
there are lots of shelves your query will take forever.
Regards,
Nicky Madjarov
phone: 973-202-4278
Find out how to bust your AR System performance @
http://www.SpeedUpARS.com
- Original Message -
From: Bhupesh Gupta
Newsgroups: public.remedy.arsystem.general
To: arslist@ARSLIST.ORG
Sent: Monday, April 06, 2009 12:48 PM
Subject: Finding LArgest free block in a table grid
**
Dear friends,
I am representing racks of book shelf as a table grid in Remedy. Each
grid/record is a single unit.some units are ocuupied and some are free. I need
to find out the largest available/free block in that Grid.
Any help will be highly appreciated!
--
Regards,
Bhupesh Gupta
__Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are" html___
___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are"