Let's say you run this yesterday, which is Monday of week 12, which goes from March 13 to March 19.

Should you compare it to week 12 of 2015? Or week...

snomadj (3/15/2016)

---

Forgive me ... I know nothing about SSRS & would appreciate your time:

Background:

2008 R2.

Reports I need will not be overly complex / resource intensive.

I have 20 odd instances...

I'm using 2 variables, because I don't have sample data provided by you.

I'm using @StartDT which for you is either QueueDate or StartDate if QueueDate is null.

This is translated...

I would upload the file using bulk insert or something similar to avoid the pivot and the additional split. But I was waiting for a reply from the OP.

ZZartin (3/14/2016)

---

That format is pretty straight forward if you have the diff in seconds.

SELECT CAST( (DATEDIFF(second, '3/14/2016', getdate()) / 60) / 60 AS varchar) + ':' + CAST( (DATEDIFF(second,...

jimtimber (3/14/2016)

---

Hi Lowell, thanks for your help, this runs without error and returns the result in minutes. I modified it so it returns seconds for what I need. However, I...

Why use a CASE statement?

SELECT DATEDIFF(ss,ISNULL(QueueDate,StartDate),EndDate)

For duration, here's a formula using date/time calculations.

DECLARE @StartDT DATETIME2

,@EndDT DATETIME2

;

SELECT @StartDT =...

Just add it to your query?

SELECT @@SERVERNAME,

p.name AS [loginname] ,

p.type ,

...

LinksUp (3/14/2016)

---

I'm not sure why this has not been mentioned yet since it is a standard construct to get rows between dates.

I would use something like this:

declare @UserDate date...

Jack Corbett (3/14/2016)

---

Luis Cazares (3/14/2016)

---

Jack Corbett (3/14/2016)

---

macdca (3/14/2016)

---

"or you need to convert the column to a date without time (no index seeks possible)." - how do...

Eric M Russell (3/14/2016)

---

Jeff Moden (3/14/2016)

---

andrew gothard (3/14/2016)

---

Also, bear in mind, if you fail to choose Correct, you can forget about the other two...

Jack Corbett (3/14/2016)

---

CONVERT(DATE, ScheduledActivity.ScheduledDateTime)

As the number...

Set the parameter as a date type, then change the condition to this:

WHERE ScheduledActivity.ScheduledStartTime >= @Date

AND ScheduledActivity.ScheduledStartTime < DATEADD(DD,1,@Date)

Don't use strings if they're not needed.

Don't convert the column's data types, especially from date/time data types to strings.

Convert the parameters to the column's data type.

It should look like this:

ScheduledActivity.ScheduledDateTime = CONVERT(datetime, '13/04/2016', 103)

If you don't...

I actually like to keep the COUNT. It will eliminate NULL values and the intention is clear.

Count(CASE WHEN [visit_date] Between '20160201' And '20160229' THEN [registration_cd] END)...