I think I have cracked it, might be overcomplicating things but the below seems to work, pending further testing. The below covers me for the 24 hour period required.

I just...

Im struggling to explain this so I will try again

the following sql is my procedure, an application passes through the @time variable which is in minutes.

The below procedure works. for...

Still no luck with this, I will try to simplify in another example.

I want to get the current datetime (where DATEDIFF(minute,time, getdate()) ), then minus 240 minutes (I...

I havent managed to resolve this yet. This is what I currently have, can anyone help – or have I got this comeplete wrong.

SET ANSI_NULLS OFF

GO

SET QUOTED_IDENTIFIER OFF

GO

ALTER PROCEDURE [dbo].[sp_myprocedure]

@time...

After more investigation I’m beginning to think this isn’t a problem, and will monitor the situation.

However I have another question;

Is there a query to view the data in the distribution...

Fantastic, that worked a treat Kingston.D . I must say I’m extremely impressed with the prompt reply thank you very much – I will defiantly be using this forum more...