you can find the code for splitter in SSC article with the same...

You are adding a new column with IDENTITY property and it works..

The thing is that we cant add...

So what output you want?

aiki4ever-796329 (8/27/2013)

---

Geez, I should have known that!

It's the difference between

select * into test2 from test -- inserts into a new table

insert into test2 select * from test --...

But what abt the scenario for which I posted the question...

How can I implement this:

Scenario is: Currently if made any changes in DeviationRequestDetails...

ALZDBA (8/28/2013)

---

What will happen to your trigger if someone inserts data of multiple ProjectID / ProposalID / SolutionId / UnitID in a single batch ?

Keep in mind exceptions do occur...

OK,

ihave changed the code now...

Removed the MERGE statement.

Is this OK?

ALTER Trigger [dbo].[Trg_DeviationRequestDetails_Ins]

ON [dbo].[DeviationRequestDetails]

After INSERT AS

BEGIN

Declare @count INT

SELECT @count = COUNT(*) FROM INSERTED

If @count = 1

BEGIN

...

ALTER...

On basis of what criteria you are assigning flavours to the output. please provide more details on it..

HanShi (8/27/2013)

---

I can't reproduce your error on my system. I'm able to created the function with your code (changing the ALTER to CREATE). I'm also able to alter this function...

Oops, my previous existing function was not a multi-statement table-valued function.

I find that ALTER cannot be used to change the function type.

So, I DROP and CREATE the function...

I think you have posted your question to a worng forum..

lindavol (8/26/2013)

---

THANK YOU - this works when I am in design and go to run

But does not work when I double click on the report and apply the parameters. ...

🙂 :-P:-D:-P

I have changed my code into this and used magic table INSERTED and its working now:)

Is it ok?

Alter Trigger Trg_DeviationRequestDetails_Ins

ON DeviationRequestDetails

After INSERT, UPDATE AS

BEGIN

MERGE INTO CLCProcessUnitDetailsCompany T

USING INSERTED as S...