OK here it comes all the work put together.;-)

declare @temp table

(

[id] [int] IDENTITY(1,1) NOT NULL,

[Dag] [datetime],

[Locatie] [NVARCHAR] (MAX),

[Temperatuur] [int]

)

insert @temp ([Dag], [Locatie], [Temperatuur])

VALUES('20111112','Rotterdam','12');

insert @temp ([Dag], [Locatie], [Temperatuur])

VALUES('20111231','Rotterdam','12');

insert @temp ([Dag], [Locatie],...

Hi,

The % calculation for months is good but in the message that is being mailed the calculation is being put as 150% for id 5 and 6 not months 3...

Hi guys,

Thx for the replay. The email part works flawlessly. But the month selection is still not functioning.

id - months - avgtemp - %

1 - 11- 12- NULL

2 -...

Hi,

I just found out that if the avgtemp difference is higher then 10% between more then two months I'm getting an error.The mail is sent empty

and the...

Here it is. Finally 😀

Thank you again for all the help.

declare @temp table

(

[id] [int] IDENTITY(1,1) NOT NULL,

[Dag] [datetime],

[Locatie] [NVARCHAR] (MAX),

[Temperatuur] [int]

)

insert @temp ([Dag], [Locatie], [Temperatuur])

VALUES('20111112','Rotterdam','12');

insert @temp ([Dag], [Locatie], [Temperatuur])

VALUES('20111231','Rotterdam','12');

insert @temp...

Thank you again. I'll let you know.

I turned on all three tables (AvgTemp, % increase, if > 10 ....) so i get a full report. Everything works perfectly. Thank you!!!!!

Only I'm still not sure how to...

So you have a table with some data and you want to send an email when this runs if any of the % change is > 10%?

Thats precise...

Well I'm confused about insert and update. The data (Temp.) is already inside and its not going to be updated.

So I guess the only thing i would need is,...

Hi,

What I would like is that each time when increase in AvTemp is higher then 10% an email notification is send.

In the table below for the months 3 and...

Thank you Jeff.

When I'm entering data from different locations the code is sorting and calculating CalcAvg by month and not by location.

example If I enter only one month...

It works like never before 😉

Thank you again!!!

Much better thank you. Only the code is still not recognizing the diffreant years.

The avg.temp % difference between 1 and 12 shouldnt be NULL and the 5th month of 2011...

the results that I'm getting when the % diffrence is being calculated is in this order:

01-2012 = NULL

02-2012 = %

12-2011 = NULL

what i would like to have is

12-2011 = NULL

01-2012...