Sure, just use the STArea() method. Here's an example from Books online.

DECLARE @g geography;

SET @g = geography::STGeomFromText('POLYGON((-122.358 47.653, -122.348 47.649, -122.348 47.658, -122.358 47.658, -122.358 47.653))', 4326);

SELECT...

It depends.

Do you want to (1) get the min, max or average size within each name, along with your max SeqID , (2) group by size...

Whups, my apologies to the Guru and to Paul both. I promise to come back when I have time to read through all this more carefully.

I wasn't told there would be a TEST... :w00t: :w00t: :w00t:

But I do recall writing at some point in the article.... 'testing, testing, testing'.

I'm surprised (but pleased) to see that...

Frankly, it's always a pleasure to hear someone just admit that they are new to SQL and open to learning.

If you keep looking at articles in SSC,...

Sorry, I misunderstood the role of the VB application. Is the visual basic application creating the query string and passing it? Or is it executing a stored...

tstaker (3/16/2010)

So what you're saying is around 137 BC she'd be a goddess in...

l33t u r

To paraphrase Dilbert:

"A number of studies have shown that made-up statistics are just as good as factual statistics."

"How many studies have said that?"

"42"

-----------

Gail, in ancient Geece...

Hey Lutz 🙂 I beat you to the punch for once !! 😀

I echo Lutz' question.

Odd....

Here are the results I'm getting with your test data. Looks like one row per employee to me, with this data.

What are you expecting your...

This is just a snapshot answer, but if you only expect one row per employee, I would expect to see a group by...

Only 25,000 rows? (rows... not records) No way should that be taking 30 seconds. Try this.

INSERT INTO TargetTable (column list)

SELECT FROM SourceTable (column list)

WHERE...

You would have paid ME?! ...