It did work. Thank you

There will never be more than 1 AccountID for any of the products. For example you have with Product1 35 it could only have Product 2 of 450 or...

This got me where I wanted to go.

http://www.mssqltips.com/sqlservertip/2914/rolling-up-multiple-rows-into-a-single-row-and-column-for-sql-server-data/

Reason behind all of this is separation of duties.

Stupid. I just need to put the criteria for the computed column in the trigger instead of using the computed column name.

I tried this but same constraint issue.

Delete From T1

From database.dbo.Table1 T1

Where DateAdd(day, -180, GetDate()) > T1.Table1Date

And Not Exists(Select * From database.dbo.Table2 T2

Where...

SSIS lookup is working well.

Debating on using replication or SSIS Lookup.

Is it possible to do something like this for linked servers?

This worked.

isnull(foldername ,'') LIKE '%' + isnull(@foldername ,isnull(foldername ,'')) + '%'

Also set the parameter properties to allow blank value.

Found it.

select

substring(SUBSTRING(ExtensionSettings,DATALENGTH('<ParameterValues><ParameterValue><Name>TO</Name><Value>')+1,DATALENGTH(ExtensionSettings)),1,CHARINDEX('</value>',SUBSTRING(ExtensionSettings,DATALENGTH('<ParameterValues><ParameterValue><Name>TO</Name><Value>')+1,DATALENGTH(ExtensionSettings)))-1)

from Subscriptions

I am thinking of implementing a "Local Data Cache" using Microsoft Synchronization Services for ADO.NET.

The Export Column component in the Data Flow worked perfectly for this. No variables needed.

It has not hung since.

I have not found anything on Server 2008. I applied the trace flag and now am wait and see. The server would hang randomly. We haven't found...

Thank you. I sent this to our network engineer so he can confirm the server model. However, we are running Server 2008 the article mentions 2003. I'm...