Very well written article!

Is there a trigger on the table?

Hi Elliot,

I think this may help:

http://www.sql-server-performance.com/tips/linked_server_p1.aspx

There are a lot of caveats when running a distributed query you have a very wise developer on your team to ask this...

I like to write it this way:

SELECT

person_identity,

COUNT(*) AS Num

FROM

(

SELECT

person_identity,

person_id

FROM

#persons

GROUP BY

person_identity,

person_id

) AS PersonDistinct

GROUP BY

person_identity

HAVING

COUNT(*) > 1;

But it does not seem to perform any better, query plans are almost the...

Here is a great article to get started:

http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Too many joins...

cartesian product...

No test data...

Unformatted code...

Help us help you, divide the code into smaller logical units and try to formulate a more specific question.

Just to make sure we're on the same page...

Stuart Davies (3/16/2011)

---

I am trying to export, amongst other data, a decimal (10,2) to a pre-existing excel workbook.

Opening the workbook, the column is a number formatted as text (has the...

Fun!

--==== Script test data

DECLARE @tblRecord TABLE

(

RecordID INT,

LoggedDate DATETIME NOT NULL

)

INSERT

@tblRecord

SELECT 987, '20110205' UNION ALL

SELECT 933, '20110206' UNION ALL

SELECT 784, '20110206' UNION ALL

SELECT 128, '20110207' UNION ALL

SELECT 748, '20110208' UNION...

romanoplescia (1/19/2011)

---

Happy days 😀 Problem's been solved.... Tracked it down to a developer in Australia who had added a new column to a select query in the sp. However this...

romanoplescia (1/18/2011)

---

Thanks for the links above. As I previously mentioned it only seems to fill up the tempdb if the the sp in question is executed from the SSIS package,...

romanoplescia (1/18/2011)

---

The datasource is a OLE DB and basically the sp gathers some data from a couple of table, does some calc and then inserts it into another table in...

Intriguing

What type of object are you using as your SQL task's datasource? (native?)

What does the SP do?

Grant Fritchey (1/11/2011)

---

That may be an issue as well, but if you try to hop a database and reference a CTE,...

Are you referencing cteGetNewVSOldGroup later in your script?