Yes there is no primary key and now index on this table .. Actualy this is my staging table where I update the records and then from here insert a...

Perfect.. your are absolutely right

Here I am giving you my actual store procedure ... Thank you for looking into it.

=======================

Declare Agent_SkillGroup Cursor FAST_FORWARD READ_ONLY FOR

SELECT DateTime,SkillTargetID,PeripheralID,sum(HandledCallsTalkTimeToHalf),count(*)

FROM WCI_IP_ST_AGENT_SKILL_GROUP_HH ...

/****** Object: Table [dbo].[WCI_IP_ST_AGENT_SKILL_GROUP_HH] Script Date: 05/08/2009 14:28:37 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

SET ANSI_PADDING ON

GO

CREATE TABLE [dbo].[WCI_IP_ST_AGENT_SKILL_GROUP_HH](

[DateTime] [datetime] NULL,

[EmpNumber] [varchar](32) NOT NULL,

[Skill Group] [varchar](32) NOT NULL,

[SkillGroupSkillTargetID]...

thanks for quick reply. Could you please explain more about temp table and a query joining to it?

Is this process possible without Cursor or while loop?

Thanks

jwalin

Hi

Thank you for sending me the store procedure ... But the result is same .. no luck ...

Here is my store Procedure

CREATE PROCEDURE sp_TransferData_Compare

(

@StartDate varchar(10),

@EndDate varchar(10)

)

AS

--

--Declare @startdate datetime

--Declare @enddate datetime

--

----converted to varchar by Rob because the time was being passed

----to the procedure causing errors

--select @Startdate...

could you please send me the gneral syntax for connecting server

Just quick question, This setting is only for my machine or it is common for all ... as in my team we have 5 people.. so do i have to...

thank you vey much to sending me very quick reply ... I appriciate.

To Create two linked server to itself, I need to do it on each developer machine? Am...