Big thanks to you, I'll try the first one, if it didn't work I'll go Dynmaic SQL ...

although ur solution may be working in this case, but it will not be working when passing 7 parameters as i want to do, i thought about dynamic sql and...

kuka_99 (11/10/2008)

---

hi,

i had the same problem. sql server trigger does not affect all rows when i updated more than one row a time.

what i do now is to run...

Adi Cohn (11/10/2008)

---

Smartdog (11/10/2008)

---

Thanks a lot for ur help, i thnk you got me right this time,

i just have one question, what is difference between row trigger and tabl trigger,...

Thanks a lot for ur help, i thnk you got me right this time,

i just have one question, what is difference between row trigger and tabl trigger, and what kind...

sorry you got me wrong

um updating a record in a row in the table summary by adding the number of rows the been updated into the existing number

let for the...

Thx for the great way of 'case when else' but my problem was in the fact that this trigger fires only once when the update statement is called, so let...

the table code:

/****** Object: Table [dbo].[Memo_Tasks] Script Date: 11/09/2008 14:49:47 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[Memo_Tasks](

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

[memo_code] [nvarchar](10) COLLATE Arabic_CI_AS NULL,

[memo_title] [nvarchar](100)...