Thanks for your help Luis. I've ended up doing this a bit differently and will pass the incremented pull# manually for now. You've given me food for thought for next...

Luis Cazares (12/6/2012)

---

That doesn't make sense either.

Your not using columns from your table to filter, you're getting the last row returned by SQL Server (which might not always be the...

netstat -abn (with elevated command prompt) will show all ports in use by all applications on the system.

or

Launch SQL Server Configuration Manager. Go to SQL Server Network Configuration and...

Jeff Moden (12/5/2012)

---

Evil Kraig F (12/5/2012)

---

If possible, can you offer a lot more detail into the data status on the two databases and future intent?

If you're looking at a complete...

Luis Cazares (12/6/2012)

---

I'm not sure that this is great for performance, but you could do something like this.

I might be wrong, so you should test with your data.

USE [TEST_DATABASE]

GO

SET ANSI_NULLS...

SQLCrazyCertified (12/6/2012)

---

jerry-621596 (12/6/2012)

---

Don't use that option. Restore with recovery so that SQL 2008 can run the various stored procedures that upgrade the database structure to the new format.

Then change...

I forgot to mention, that the master stored procedure will be called from a scheduled job calling the following t-sql:

exec sp_Run_Inserts null,null,null,null

This way it runs without any inputs needed each...

I am keeping the insert/update/delete routine in place for now until they give me data with a PK. I agree uniqueness is needed to properly work with the data. Thanks...

Tava (11/6/2012)

---

SQL-Squid,

You're correct in what you said the issue is that your source has duplicates, so based on the below you will always return multiple results, hence the MERGE...

Here is the data to test with:

CREATE TABLE [dbo].[AssetClassUDF](

[ASSET_UDF_VALUE] [nvarchar](255) NULL,

[ASSET_UDF_DESC] [nvarchar](255) NULL,

[ASSETDETAIL_Id] [numeric](20, 0) NULL,

[Pulldate] [date] NULL

) ON [PRIMARY]

GO

INSERT INTO ASSETCLASSUDF

(ASSET_UDF_VALUE,ASSET_UDF_DESC,ASSETDETAIL_Id,Pulldate)

SELECT '','Filter 1 - Size/Description','16','2012-10-31' Union All

SELECT '','Filter...

Here is an attempt to use a CTE and I am lost again, not sure if this is going to work as I expected. Code below throws the same merge...

Thanks all. I will have a go with group by in my merge and see if I can get the results I am after.

The source data is a feed that...

Thanks for all the help, this issue has been put on the back burner. Project deadlines... 😉

On the local machine or the server? (i will be back in...

Thanks everyone that has been helping! I am still trying to narrow down the cause 🙂