Three year old thread.

Lowell (6/18/2012)

---

left inner join? no such animal exists in SQL, so that's probably not what you meant. it's either a left outer outer or an inner join

whatever your...

Sean Lange (6/18/2012)

---

Lynn Pettis (6/18/2012)

---

komal145 (6/18/2012)

---

select '10704' as entry_id , '2012-05-18 14:17:20.710' as Start_time ,'2012-05-18 14:18:13.957' as End_time ,'test3' as USername

Union all

select '10704' as entry_id , '2012-05-18 14:24:45.057' as Start_time...

marginalster (6/18/2012)

---

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...

komal145 (6/18/2012)

---

select '10704' as entry_id , '2012-05-18 14:17:20.710' as Start_time ,'2012-05-18 14:18:13.957' as End_time ,'test3' as USername

Union all

select '10704' as entry_id , '2012-05-18 14:24:45.057' as Start_time ,'2012-05-18 14:25:14.780' as End_time...

What is the result of the following query.

select name, log_reuse_wait_desc from sys.databases;

How about this?

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], [Temperatuur])

VALUES('20120118','Rotterdam','9');

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

VALUES('20120213','Rotterdam','5');

insert @temp...

I think you may have answered your question, unless of course, more people can access the server via an application than you have user...

Duncan Pryde (6/18/2012)

---

kharol (6/18/2012)

---

Duncan:

I thought about parameter sniffing, but all resource I found about it was related to stored procedures. Nevertheless, I tried wrapping it in stored procedure that would...

Umm, did not say it would change anything, just said the first thing I'd do is replace the multi-statement table valued function...

What name did you give that public profile? Is that the name you are using in the msdb.dbo.sp_send_dbmail command?

First suggestion, replace your multi-statement table valued function with the this one:

drop function dbo.generateDates;

go

create function dbo.generateDates(@startdate date, @enddate date)

returns table

as

return(

with e1(n) as (select 1 union all

...

Grant Fritchey (6/18/2012)

---

Lynn Pettis (6/18/2012)

---

Grant Fritchey (6/18/2012)

---

Lynn Pettis (6/18/2012)

---

Grant Fritchey (6/18/2012)

---

That's...

Does this mean you are having the same problem?

You know, you surround the URL with the [ url ] [ /url ] IFCode short cuts (no spaces inside of the brackets), people don't have to...