Thanks for the reply. I thought that when a trigger is fired, a transaction occurs, so there is something to commit , no?

I also noticed that you can't capture the...

After further research it seems that a solution could be to COMMIT the trigger in its very beginning , i.e

ALTER TRIGGER [dbo].[tr_ComponentOnLines] ON [dbo].[tblCFGLine] AFTER INSERT, UPDATE, DELETE

AS

BEGIN

COMMIT

BEGIN TRY

DECLARE...

After further research it seems that a solution could be to COMMIT the trigger in its very beginning , i.e

ALTER TRIGGER [dbo].[tr_ComponentOnLines] ON [dbo].[tblCFGLine] AFTER INSERT, UPDATE, DELETE

AS

BEGIN

COMMIT

BEGIN TRY

DECLARE...

Thanks Gail,

That's a good spot. Will correct accordingly.

V

Hello Erlang,

Many thanks for your reply. Couple of days ago, I found a solution, check the following please :

with cte_test (DatetimeStamp,Packcount,WorkOrderID,RowID)

AS

(

SELECT *,ROW_NUMBER() OVER (Order by...

Is the rt.productid referring to column that is part of the main query? I guess what I am asking is if your sub query is a correlated one. How...

Either you are missing the point or I fail to explain

I will shortly post the script to avoid confusions.

Thanks for the reply,

So according to my example :

Counts Time

10 05:54

309 06:02

...

..

25 13:58

91 14:02

The point is that you don't want just records before 06:02 am, you want to include it...

It worked. Thanks guys!

many thanks for the reply,

I have been trying for hours to understand the problem. I will try and let you know.

Thanks