Hi,

Just out of curiosity....

Why is data concatination, just for the sake of "being displayed in the front end", being achieved at the database level. Is this not tying up your...

Hi,

Try the following code:

with Incoming as(

select DepartmentId, ParentId, Incoming as Incoming from #Department

where ParentId in (select DepartmentId from #department)

Union All

select d.DepartmentId, i.ParentId, d.Incoming as Incoming

from #Department d Inner Join...

Hi,

If your SP does not do any DML operations, write a function instead and use it in the inline query.

Srinivas

Thank you for the reply.

But, can DBCC Inputbuffer(SPID) in an inline query?

I'm actually trying to monitor the various DML opertaions being performed on a table.

In the update trigger, i'm capturing...