I had once created a data log system which creates table triggers dynamically.

I have noted down my notes at SQL Server Log Tool for Capturing Data Changes by building Change...

Hi Ruyven,

Here is an other example on How to SQL Select from Stored Procedure using SQL Server OPENQUERY or OPENROWSET

I liked this method, but I believe it will be better...

Yes sure, you are right.

Thanks

Hi Raul,

Here is an other solution

with cte as (

select

State,

amt,

per,

rn = ROW_NUMBER() over (partition by state order by amt desc)

from summax

)

select

state,

SUM(amt) total,

per = (select cte2.per from cte cte2...

Hello,

That is what Gail suggested I guess

DECLARE @parent_id int

SET @parent_id = (

SELECT TOP 1 parent_id FROM sys.triggers WHERE object_id=@@PROCID

)

SELECT OBJECT_NAME(@parent_id)

Hi,

I think this is not an HTML formatted email.

Perhaps if you can set email format to HTML, you can control it better.

You can check SQL Server Database Mail sp_send_dbmail Example

You...

Hi pcgm,

My code responds to changes in model

If you want to respond to changes in value column please change the WHERE clause as follows

t1.value <> t2.value --t1.model <> t2.model

I mean

with...

Here is my code suggestion :

with cte as (

select *, rn = ROW_NUMBER() OVER (Order By Id) from FindChanges

)

select t1.*, t2.*

from cte t1

full join cte t2 on t1.rn = t2.rn...

Hi all,

Are you sure that the previous solution works successfully?

I could not understand why we need to set the win32 in the WHERE clause of the CTE

I think Steve has...

Hi Suresh,

Can you please check the tutorial named How to SQL Select from Stored Procedure using SQL Server OPENQUERY or OPENROWSET

When I use a code like below

SELECT *

into #t

FROM...

That is the Process Id that indicates the processes SQL engine uses for completing tasks.

For example if you run a query it may be done by a single process than...

By the way, you can also test the below OPENXML code statement

DECLARE @h INT, @X XML

SELECT @X = c FROM OPENROWSET (BULK 'C:\Test.xml', SINGLE_BLOB) AS Temp(c)

EXEC sp_xml_preparedocument

Hi,

Please test the below t-sql code according to your settings

Select

C.value('.','varchar(100)') AS category

From @xml.nodes('/tv/programme/category') T(C)

Please note that I changed the category[1] to '.' and @X.nodes('/tv/programme') to @xml.nodes('/tv/programme/category')

I hope that helps,

You can sort data by ORDER BY clause.

So you can order Activity, OtherFields, then DateTimeField as

ORDER BY Activity, OtherFields, DateTimeField

But in SQL2005 there are new ranking functions like

ROW_NUMBER() OVER (PARTITION...

Hello,

You can try the following script

But this creates drop column command for each column, so...