Thank Jason this increased the speed 10 fold

SELECT s.ID

FROM v_sign s

WHERE EXISTS (SELECT 1 FROM dbo.water w WHERE (geography::STGeomFromText(s.geometry.STAsText(), 4326).STBuffer(100).STIntersects(w.geography) = 1)

Hi Everyone

The STDistance will not work well because it will cause too many calculation. I am going to look into the Nearest Neighbor method.

Here is what I have tried. Setting GEOMETRY to GEOGRAPHY, then a inner join, I have also tried with a union with the same error results.

DECLARE @sign GEOGRAPHY ...

Luis Cazares (12/18/2013)

---

I'm not really sure about this approach, but it's an option 😉

SELECT SUBSTRING( PARSENAME( REPLACE( string, '-', '.'), 4), PATINDEX( '%[^0]%', PARSENAME( REPLACE( string, '-', '.'), 4)), 100),

SUBSTRING(...

I found it myself

SELECT

SUBSTRING([Column Name], PATINDEX('%[0-9]%', [Column Name]), 30)

will take the 30 characters after the first number found.

Thank you 'SSChampion', that worked.

I found where I was making my mistake. I was including the count(*) in my select statement as well as my having statment which was...

just adding the 5 columns to the order by returns an error

Column 'GD_OLD' is invalid in the select list because it is not contained in either an aggregate function...

Did not work. still showing all 6 rows.

select right(replicate('0', 5) + cast(Col1 as varchar(6))+ replicate('0', 2)+ cast(Col1 as varchar(9)), 9)

gives me the correct values.

it turns out it is not working correctly. It is adding all the zeros to the front and not to the 2 parts.

Column 1 - 12345 should be 6 characters...

Thanks, works great.

Thanks, I was able to get it to work with your help.

Ok, adding the deleted in front of that column makes it work. I am getting the records into the tables as needed. It is also entering 10 rows of 'NULL'...

That returns 'Invalid column name' for all but the GETDATE() column

Hi tried a few different ways to do it. Declaring a table, that output into a @table I declared. Once that was done I did an

insert into Table1 (Column1,...