CREATE PROCEDURE [dbo].[sp_test] AS

INSERT INTO aim_t_holding

                      (CAN, Transaction_Date, Machine_Code, Transaction_Type, Ref_No, Ref_No2, Tran_Amt_Base, Pay_Amt_Base, Tran_Amt_NonBase,

                      Pay_Amt_NonBase, Fund_Code, Pay_Code, Pay_Reference, Group_Number, Posting_Date, Batch_Number, Import_Code, VAT_Amt_Base,

                      VAT_Amt_NonBase, VAT_Code, Balance, User_Code,...

Remi

Many thanks for your post - have got the linked server set up and have wrote sp to move the data, only issue I now have is when I try...

Is there any way to automate this from SQL server?

This is an out of the box product with a few inconsistancies. 

We have to make do with the structure as the front end cannot be...

This is the request table, from which the count queries are generated.

CREATE TABLE [request] (

 [sys_request_id] [int] IDENTITY (1, 1) NOT NULL ,

 [sys_requestdate] [smalldatetime] NULL ,

 [sys_ownedby] [nvarchar] (50) COLLATE Latin1_General_CI_AS NULL...

What did you mean by "both tables' DDL"?

How would you go about creating somehting like this?

What did you mean by "both tables' DDL"?

How would you go about creating somehting like this?

Hope this makes sense....

Count of Calls resolved query:

SELECT     db_owner.CallsResolved.sys_analgroup, db_owner.CallsResolved.ParamValueStart, db_owner.CallsResolved.ParamValueEnd,

                      COUNT(db_owner.CallsResolved.sys_request_id) AS CallsResolvedCount, dbo.priority.sys_priority_id

FROM         dbo.priority LEFT OUTER JOIN

                      db_owner.CallsResolved ON dbo.priority.sys_priority_id = db_owner.CallsResolved.sys_requestpriority

GROUP BY db_owner.CallsResolved.sys_analgroup, db_owner.CallsResolved.ParamValueStart, db_owner.CallsResolved.ParamValueEnd,

                     ...

Thats exactly what I need to get....: