Viewing 15 posts - 16,786 through 16,800 (of 18,926 total)
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?
June 14, 2005 at 12:33 pm
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
June 14, 2005 at 12:31 pm
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...
June 14, 2005 at 12:17 pm
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.
June 14, 2005 at 12:13 pm
Do you want to see only the data for which there's a group of 10 consecutive minutes?
June 14, 2005 at 12:12 pm
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...
June 14, 2005 at 11:59 am
Can you post the table definition, some sample data and the desired results from that data?
June 14, 2005 at 11:52 am
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...
June 14, 2005 at 11:49 am
Whoops indeed. Aren't you glad you didn't wipe out the post table
.
Nice article.
June 14, 2005 at 11:41 am
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...
June 14, 2005 at 11:04 am
As always, can you provide the desired out from this input data?
June 14, 2005 at 10:14 am
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...
June 14, 2005 at 10:10 am
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...
June 14, 2005 at 10:00 am
You need to put this image on a webserver ::
C:\Documents and Settings\imran\Desktop\screen1.gif
June 14, 2005 at 9:38 am
Viewing 15 posts - 16,786 through 16,800 (of 18,926 total)