Hi Brien, no indeed.  In fact it is a bug with at least the latest 2 versions of DMS, spinning up another instance on a release previous to that, and...

sending a single update works ok

USE Metadata
GO

CREATE TABLE...

got this error

SQL2.sql: Error (1,1): ALTER TABLE DROP COLUMN failed because column 'ALTER PROCEDURE [dbo].[AreaToEdge] @WKT VARCHAR(MAX), @SEARCH_DISTANCE INT, @MARGIN INT = 10/*********************************' does not exist in table...

Thank you Luis, I was indeed looking at the issue from the wrong direction.  Your code is excellent and very fast, I will learn what it is doing and take...

EDIT:
I thought it was quicker, but it's still really slow on 92M rows.. I would welcome any ideas please?

thank you

it's ok, I've sorted...

thanks to everyone for their suggestions, on writing some test data I noticed that it was working ok, it must be my data.. I will close the call!

IF OBJECT_ID('tempdb.dbo.#DATA') IS...

Igor Micev (5/8/2015)

---

Try this:

UPDATE [temp]

SET Abstract_area = tmp.DataSet

FROM #TEMP1 [temp]

INNER JOIN ( SELECT T.*...

"Use table variables instead of temp tables"

Why would this be a normal thing to do? Table variables only report 1 row for statistics, temp tables would be better for...

Grant Fritchey (2/11/2013)

---

If you are trying to learn T-SQL, you can't go very far wrong picking up Itzik Ben-Gan's book. He has a fundamentals book and the Inside book.

I don't...

No error from this:

-- header from image to varbinary(max)

DECLARE @header TABLE (

header varbinary(max)

)

INSERT INTO @header

SELECT AD.SW_GEOMETRY

FROM Abstract_DPB AD

WHERE AD.SW_MEMBER=40967

UPDATE @header

SET header = CAST(STUFF(header,19,0,103000000010000000) AS varbinary(max))

--...

UPDATE Abstract_DPB

SET SW_GEOMETRY = STUFF(SW_GEOMETRY,20,0,0x103000000010000000)

WHERE SW_MEMBER=40967

"SQL.sql: Error (38,1): Argument data type image is invalid for argument 1 of stuff function."

ah...

Phil Parkin (5/6/2014)

---

Text is a deprecated datatype - are you able to consider a datatype change? Varchar(max) or, even better, Varchar(nnn) if your column width won't exceed 8000.

If yes, this...

Am trying this...

-- Use a table variable to cast the trace

-- header from image to varbinary(max)

DECLARE @header TABLE (

header varbinary(max)

)

-- insert the trace header into...