Here's what I need to get just to get a list of support calls from our support system:

create table #SupportSystem_Calls

(

[CallRef] varchar(8),

[CustomerRef] varchar(16),

[NAME] varchar(120),

[Opened] datetime,

[Closed] datetime,

[Actioned] datetime,

[PRODUCTREF] varchar(16),

[ProductName] varchar(40),

[VERSIONREF]...

Hi,

I've got it working rather nicely with SPs that query the remote tables, then update local tables with the query results.

This is blisteringly fast from a client PC but I...

Hi,

What would be the advantage of pulling back filtered rowsets?

I need to build ID Enumerator, Finder and SpecificFinder methods; surely if I'm going to aggregate the customer tables from...

Hi,

I don't say "I work in IT" anymore because you can almost hear little cogs turning as the person to whom you were just introduced is filing your contact details...