Posted by Erland Sommarskog on 05/22/05 13:38

akej via SQLMonster.com (forum@SQLMonster.com) writes:
> Thanks, so how it can be issued is triggers ?
>
> for now i have job that run every "n" minuts and call to the store
> procedure that take parameters as EventID ......
>
> can u help me, please. THANKS.

So precisely what is your problem with triggers. I pointed out that there
is a potential issue with triggers if you use the CASE expression, but
since I know nothing about your application, I have no idea if there is a
real issue.

However, the more this thread keeps going, I get a stronger feeling that
you should redesign the table, and turn the column into rows. This makes
it all much simpler.


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp

[Back to original message]