January 24, 2012 at 3:10 pm
kevmck (1/24/2012)
What you gave me ran quickly, and seems to work fantastically with my test data thanks - I'm going to build this into my bigger real world solution and see how it goesThanks so much
No problem man (i assume u r a "HE") 😛
BTW, how large is ur data in the database? the sample data u provided has a 10x10 grid. How big is the real-world grid?
January 24, 2012 at 3:21 pm
yep!
and it'll be no more than 50x50 - so not a huge amount of data - this is just one small part of things, but a big headache!
January 24, 2012 at 6:53 pm
If it is 50x50, then we may need to little tweaks in determining the vertical and horizontal boundaries. If you need assistance, please PM me with sample data 🙂
January 25, 2012 at 12:09 am
if you use cross-join then you will get desired result. Let me know if understand wrongly.
Viewing 4 posts - 16 through 18 (of 18 total)
You must be logged in to reply to this topic. Login to reply