david.ostrander (3/31/2014)

---

Hello -

My SQL Server Agent shows successful completion of SSIS job but messages in Log File view shows that there was an error. How can I get the...

If you have no sequence or date/time to go by, then unfortunately you have to grab all the source records for comparison. With these sizes, which sound manageable, my suggestion...

qifai3zoi3ziq (3/31/2014)

---

Eirikur Eiriksson (3/31/2014)

---

If I am getting this right: A unique key should be a natural key, not a surrogate key, which means comparing all columns making up the key....

I agree, start with the earliest version...

You can use tools like WireShark[/url], nmap[/url] or other similar to do some diagnostics, I often use BackTrack[/url] to analyze this kind of problems.

Back in the days of SQL 7/2000...

Sounds like a good option, have used this in similar situations before with good results.

qifai3zoi3ziq (3/31/2014)

---

Hi, I need to do incremental loading from a source (a linked server in my db) to a destination which is local db.

I am planning on doing ssis package...

Hope you don't mind but here is my suggestion; check all the possible bottlenecks and possible points of failure, this may not even be a db issue. It only takes...

Jeff Moden (3/31/2014)

---

While some of the methods posted are ok, there's still the fundamental problem...

... of not knowing what...

Luis Cazares (3/31/2014)

---

Here are 2 other options.

WITH Contacts AS(

SELECT INS.INSPNO, CNT.FIRSTNAME, CNT.LASTNAME, CNT.CAPACITY,

ROW_NUMBER() OVER( PARTITION BY INS.INSPNO ORDER BY CASE WHEN Capacity = 'Contractor' THEN -1 ELSE INS.INSPNO END DESC)...

One way of simplifying this is to use the NCHAR() function;

EXEC ( ' Select CHARINDEX(NCHAR(41), @Ref) ')

This can be done using sub-query

Using TOP

DECLARE @BATCH_SIZE INT = 10;

DELETE X

FROM (

SELECT TOP (@BATCH_SIZE) [COLUMN]

FROM [TABLE_NAME] M

ORDER BY [COLUMN] DESC

) AS X

Using OFFSET-FETCH (2012)

DECLARE @BATCH_SIZE INT = 10;

DELETE X

FROM...

This is a case of premature exclusion, nothing to worry about 😀

USE tempdb;

GO

DECLARE @inspection TABLE

(

INSPNO INT NULL

,StartDateDATE...

Could you supply a DDL with a sample records and the expected results?

Quick note, be careful not to use reserved keywords in this manner, that is the...