You could try reading over the network instead of writing over the network.

In other words, write your data to a permanent staging table on Server2 using code that runs on...

When I run my posted code on your sample data, everything works as expected - Nothing happens if I load the same data again.

Could you post new sample data where...

Would this work for you:

INSERT INTO TargetTable (Uarn, BACode, VO_Ref, From_Date, To_Date)

SELECT Uarn, BACode, VO_Ref, From_Date, To_Date

FROM

(

MERGE TargetTable...

This should work:

[Code]set @sql = 'select (CAST(MONTH(ContractDate) as varchar(2)) + ''/'' + CAST(YEAR(ContractDate) as varchar(4))) as Date_Marker, ROUND(sum(' + @field + '),2) ' + @fieldname + ' '...

I think you need to explain more what you want.

You talk about two different measurements:

A = Sum(NoOfBooks) for a child

B = Sum(NoOfBooks) for a child's each parents

Could you tell us...

This should work:

"INSERT INTO XMLImport (XMLFile, LoadDate)

SELECT CONVERT(XML, BulkColumn) as BulkColumn, GetDate()

FROM OPENROWSET(BULK '" + @[User::XMLFilePath] + "' , SINGLE_BLOB) as X"

Why is this such a bad solution?

I think your problems might be associated with statistics.

It seems that you have automated statistics updating enabled. This means that when 20% of the rows in a table are updated,...

The performance of Chris' solution is fantastic.

If we use his setup script, we can use the following code to perform the update:

IF OBJECT_ID('tempdb..#t2') IS NOT NULL drop table #t2

SELECT DISTINCT...

The original query can be formulated a little bit more elegantly as this:

;WITH t(i,n,c) AS

( SELECT i,

ROW_NUMBER() OVER (ORDER BY i),

...

Since you are on SQL2008, you can forget about TRY_CAST since this is a SQL2012 feature only.

On SQL2008 you could use a CASE expression to guard the expression evaluation to...

marc.eilander 13301 (7/31/2013)

---

Hi, Thank you for your response. However the goal is to only retrieve those lines starting with Int.nr.TXT:. I checked the data, all lines have a valid...

I suspect that the cause of the problem is that you have a row in the data where TextDescription begins with 'Int.nr.TXT:' but there is no valid integer after.

This is...

I also have a very similar issue.

Are you saying that you fixed your PLE-problem by rolling back to the RTM version ?

Are you using plain RTM, or have you applied...

TheSQLGuru (3/27/2013)

---

Given that profiler shows no queries with large numbers of reads took away my normal response.

Complete guesses here:

1) someone accidentally put windows/sqlserver 32 bit on the system...