Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 Transact-SQL (2008)
 selective insert trigger

Author  Topic 

ssdeveloper
Starting Member

37 Posts

Posted - 2012-02-13 : 15:05:05
Hi
I have a requirement to execute a procedure on addition of records into a table. But the thing is I want only the records added by certain employees. (meaning select statement with a where clause)

Is this possible? Any help will be appreciated in this regard!

Thanks!

X002548
Not Just a Number

15586 Posts

Posted - 2012-02-14 : 11:03:09
So you want to call a stored procedure...that does what Excatly?

But you only want rows added by certain employees.

It all depends on how your table is defined

Read the hint link in my sig



Brett

8-)

Hint: Want your questions answered fast? Follow the direction in this link
http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx


Want to help yourself?

http://msdn.microsoft.com/en-us/library/ms130214.aspx

http://weblogs.sqlteam.com/brettk/

http://brettkaiser.blogspot.com/


Go to Top of Page
   

- Advertisement -