It's not what I asked. Do you want the data for which there are 10 consecutive minutes and ignore everything else where there's less than 10?

Nice trick... I assume that this is well documented because it's not the first place I'd be searching if a bug was found in the application

I'd go with the best practice that says you shouldn't start an external process in a trigger (mail/dts ...).

You're idea is not bad, but do the users need to run...

You'll have to fix the data, or the query will fail.

The distinct clause might help you here but it's gonna kill what little performance there can be in there.

Do you want to see only the data for which there's a group of 10 consecutive minutes?

I'm gonna assume that the 2nd

"5 4 .5...

I think you could create a very small app that call the said package(s). Then you can give access to the sysadmin group to the application. If the...

Can you post the table definition, some sample data and the desired results from that data?

Thanx for remembering govinn, but this one is way more complicated (not random sampling, and the first minute of the ten minutes span is dynamic). I'll give this one...

Whoops indeed. Aren't you glad you didn't wipe out the post table .

Nice article.

HTH.

If you want to make sure that the data remains numeric, you want ask you developper to validate the data before the insert.

And then add a check constraint SSN like...

As always, can you provide the desired out from this input data?

I don't see any easy way out on this one... Maybe dynamic sql is the best solution here (never thaught I would say that).

As it's already been said, your code...

The update in the trigger would look something like this :

CREATE TRIGGER t_period

ON Contracts

FOR INSERT, update

AS

SET NOCOUNT ON

IF UPDATE (StartDate)

begin

UPDATE C SET C.NextPeriod = dtNextPeriod.NextPeriod FROM Contracts C inner...

You need to put this image on a webserver ::

C:\Documents and Settings\imran\Desktop\screen1.gif