andycao (6/18/2012)

---

2 jobs ago ... one of the most "frustrating" SQL DBAs that my deparment hired had all of Microsoft's DBA certifications. But his SQL coding was very suspect....

I've worked with people who had certs in given areas and I was surprised that they could even turn on a computer. Experience first and "paper" second is the way...

Number 3 on the list scares me the most because it is a subject I'm weak in. I understand the concepts of RAID and such and have configured this stuff...

Alright, alright. We all have thick skin, are always right when we are wrong, public forums and on and on. How about we ALL get back to our regularly scheduled...

I've only had the need for WITH RECOMPILE once. I had a stored procedure that would gather data for a report and it was always returning something other than what...

Feel better?

No body has a right to free speech here. This is a server laying around in some cold dark room, not the government telling anyone to shut up. All of...

Some people tend to place a higher value on their opinions than others do and those tend to be the people I block out while some can be the loudest...

Ah! Now I see it. I didn't catch that when importing the shape file. I left geom as the default.

I do not have those two. I see the add column statement for BoundaryGeog but nothing that either renames, drops and adds, etc BoundaryGeoM

Per your explanation of column names changing the statement as seen below resolves the issue.

UPDATE tl_2008_us_state

SET BoundaryGeog = GEOGRAPHY::STGeomFromWKB(Geom.MakeValid().STAsBinary(), 4326)

WHERE NAME NOT IN('Massachusetts',...

I changed BoundaryGeom to BoundaryGeog as seen below and now it throws the following:

UPDATE tl_2008_us_state

SET BoundaryGeog = GEOGRAPHY::STGeomFromWKB(BoundaryGeog.MakeValid().STAsBinary(), 4326)

WHERE NAME NOT IN('Massachusetts', 'New...

I noticed while looking at the table structure for tl_2008_us_state that there is a column called geom and one called boundaryGeog. Just mentioning this because it is odd those two...

I didn't actually. Not message, etc at all. A search of sys.objects in every database returns no results as well. On with the search..

Step 3 seems to have issues

UPDATE tl_2008_us_state

SET BoundaryGeog = GEOGRAPHY::STGeomFromWKB(BoundaryGeom.MakeValid().STAsBinary(), 4326)

WHERE NAME NOT IN('Massachusetts', 'New Mexico', 'Wyoming', 'Montana', 'Texas', 'North Carolina', 'Arizona', 'Tennessee',...