Thanks twin,

but again interrupting.

linked server is already defined and i am able to select records using the linked server. Facing issue with merge statement only.

please help.

thank you

Thanks twin ,

I am using the same logic and it working fine. but my source is linked sqlserver. The above query is working fine if source and target is...

Hi Phil,

by comparing source and target hoe to update the target isdelete flag if record is deleted from source?

Thanks

abhas

Yes,Thanks. the query is working fine but its taking time to execute a package. After lookup i am using conitionalsplit transformation and comparing sourceid with targetid and fetching records...

Thanks Phil,

I am using below query but getting an error

MERGE dbo.tblcustomerSource AS d -- this is source

USING dbo.tblcustomerTarget AS dd --this is target

ON (d.custid = dd.custid )

when not matched by...

Thanks Koen,

But in the target table there is one extra column ISdelete. If record is deleted from source then i need toset value of this column is D. If i...

Thanks Praveen for reply. I tried but I am getting below error.

Server 'servername' is not configured for RPC

Thanks

Abhas.

Thank you so much Lynn.

Your suggested solution is perfect. 🙂

Thanks

Abhas.

Thanks HB,

But i need to display data for prev 5 months, current month and next 6 months. along with year.for example for example, current month is Oct, then I need...

Hi Michael,

I tried but value will display same for both AM and PM,

example 07:30 AM and 07:30 PM will display same value as below.

07:30:00.0000000

Thanks,

Thanks Ronald,

select CAST(22 as decimal (6,2))/CAST(30 as decimal (6,2)) is also giving me output. 🙂

Hi Lynn,

Forgot to explain how to add data.

i want to add data for particular day selected by user. Example if user want to add data for Only Monday or friday...

Thanks Lynn,

i want to insert data in below table.

CREATE TABLE [dbo].[tblstudentPlaner](

[PlanerID] [numeric](18, 0) IDENTITY(1,1) NOT NULL,

[StudID] [int] NOT NULL,

[EffectiveDate] [datetime] NULL,

[StartTime] [varchar](20) NULL,

[EndTime] [varchar](20) NULL,

[Flag] [bit] NULL,

CONSTRAINT...

Yes Lynn,

I am able to select lunch time for students using CTE as below. But not able to set flag 1 in the main student table.

DECLARE @t TABLE

...

can u pls send sample code?