Well yes, but that takes a little work.. As I said a sp cannot be used in a straight select (you can't do Select * from exec dbo.MyProc). You can...

Well you can return a table in the sp just by doing a select. but the problem is that you can use a stored proc in an inner join....

That doesn't exist in sqlserver. You must use the profiler and filter for specific table names (never did that so I can't really help more than that).

whoa, nice catch there Nicholas.

quoting myself :

Exec () cannot resolve the statement in the parenthesis, you must set it into a variable and use it like so ...

I don't know why it's like...

Hehe something that seemed so simple turned out to be a real monster. It's a nice touch to see that I didn't account for empty non null names. ...

You can call any amount of stored procs while you're in a stored proc. The only thing you have to watch for is the nesting level.

call sp1 :...

Not confused at all. The trigger gives you access the to inserted and deleted tables. Those tables contain the information on all the lines that have been modified.

Inserted...

What article is this reffering to?

run both and see for yourself, just make sure you have all the indexes you need to run each query.

HTH.

Good luck.

hmm... I don't see a final calculation here :

'abcd' + Substring(name, 5, 999)

If there's a difference it must be so minute that I can't detect it with my test...

That's gonna sound harsh : but if you don't wanna code, don't be a coder. There's no shortcut in this situation so stop looking for one. You'd...

check this out :

if (object_id('test')) > 0

drop proc test

go

create proc test

as

select null

go

select Name, id, crdate, schema_ver from dbo.SysObjects where name = 'test' and xType = 'P'

go

alter proc...

I can't prove it any faster or slower. Looks pretty much the same.