All any of us know is what you post 😉 I did notice the declaration in block 2, and was in the process of revising my...

In Block 1, I notice you didn't specify a length for @sql. Run this and see what happens as a result.

-----------------------------------------------------------------------------------

declare @sql nvarchar

set

Sorry I blew over that this was out of Adventureworks.

Merry Christmas to all. May 2009 be a better year for everyone.

If it's not too late, you might also consider renaming that column. It's just fewer headaches in the long run to avoid keywords as column names.

If you REALLY want the grid in a separate table you could always do two queries with a UNION ALL, but why bother?

The problem is that SQL doesn't currently allow...

I don't think you need two tables. You can store all the polygons in a single table. If we're just talking 105 rows here, that's a trivial amount....

Couple of questions:

1. Have you created spatial indexes for the two tables yet?

2. What do you mean by "lay over"? SQL Server can tell...

I edited my previous post. My approach to the solution is detailed there. You can search this site using the keywords "parse" and "concatenate" for...

I mean, will F1 ever have '123.1, 126.5, 135.4' and you want it to be "the same" as '135.4, 126.5, 123.1' for grouping purposes.

I don't have time...

Will F1 ever have more than two numbers in it?

You're welcome. Merry Christmas, Jean-François.

Try this:

declare @input decimal(9,4)

set @input = -25.77

select case when @input >0 then '+' else '' end -- gives you a plus...

Neither my approach nor PIVOT is able to create the column names for you. You have to identify all of them in advance, which means you would have to...

I'm not sure how to approach this with PIVOT because you aren't grouping on EAID, you are actually using it to divide into two sets of columns. ...

You're too quick for me today, Seth. One important thing to remember is that although charindex and substring work normally with text columns, the LEN function doesn't....