Extract X and Y coordinates out of a string and check if within range

Question

Post reply

Extract X and Y coordinates out of a string and check if within range

Viewing 5 posts - 16 through 19 (of 19 total)

You must be logged in to reply to this topic. Login to reply

Charlottecb Hall of Fame Points: 3932 More actions · Answer 1

Charlottecb

Hall of Fame

Points: 3932

February 1, 2010 at 3:59 am

#1111500

OK, thanks Wayne 🙂

Charlotte.

TheSQLGuru SSC Guru Points: 134017 More actions · Answer 2

didn't we have a HUGE string-splitting thread on sqlservercentral some time back?? Lots of code examples, benchmarking, etc.

Personally I think this may be a case where CLR could help out, but there are many solutions to your problem.

Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service

Jeff Moden SSC Guru Points: 1004363 More actions · Answer 3

Charlotte,

It's been a couple of days and I'm just being curious... how did all of this work out for you?

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

Charlottecb Hall of Fame Points: 3932 More actions · Answer 4

Hi Jeff,

Thanks for yout interest. It has worked out really well.

I put in a formula to calculate the difference in distance between my search centre point and the X\Y coords your Tally table based Select statement generated and used this to filter the number of matches returned then passed those through to my front end for highlighting on the map (powered by MapInfo MapXtreme). It all works well, nice and fast.

Many thanks again for the help with the extraction of the polygon coords.

Regards.

Jeff Moden SSC Guru Points: 1004363 More actions · Answer 5

Awesome. Thanks for the feedback, Charlotte.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)