Hi Jeff,

The solution you mentioned is working fine for the procedure sp_who, but when I use the same script for user defined procedure then it throwing following error

Msg 7357, Level...

We are having only five characters ( , ', ", & ) that need escape character in XML.

We can use replace function for handling them.

DECLARE @test-2 xml

DECLARE...

can you try the below code

DECLARE @siteid VARCHAR(500), @spaceid VARCHAR(600)

Set @siteid = 'select distinct spaceid from staging.dbo.owner where siteid =' + quotename(ISNULL(@siteid,''), '''')

set @spaceid = 'select country,state,city,fromdate,todate,url,cost from staging.dbo.myads' +...

Hi,

can you try with the below code?

CEILING(AVG(Atraso))