thx - kinda looking for some t-sql code/script to do this. Any ideas? 🙂

Hi, thx for your reply.

What I want was that @Type would be only 1 parameter, and all the selected values/choices would be part of @Type.

@Type=A or B or C

A= AND...

Thx. Yeah, I wanted to do that, but guess what, the db is suddenly in the middle of restore (prod to dev nightly), so I'll have to wait until...

Thanks!! I have an issue with this part you added:

inner join dbo.people p with(nolock)

on r.people_id = p.people_id

You'd think there'd...

Here you go sir! THANKS! Cool, never used that feature....

OK, so how would I post the Execution Plan here? (Let me think)

The plan indicates the Sort operation is 89% cost of the query, 8% Index Seek, etc.

Any general...

I posted, and then edited to cut and paste - you're too quick! See my solution in the previous thread.

Thanks, Sean! That is a valid solution I thought of. I wanted a single query pass. I essentially figured it out using OVER(). I was...

No takers?

Thanks, all! Yeah, the rule is where execution count > 1

Thanks. Which part sounds right? The first where last_elapsed > avg_elapsed, or where last_elapsed > ~previous avg_elapsed? THx

Thank you, Jeff! I see quite a lot of activity around my post (which doesn't really have anything to do w/my original question 🙂 But, I am quite...

Thx for the quick reply. That was kinda silly - I thought I tried that, but works 🙂

I did want to ask a follow-up, is it possible to...

Sorry for the misconfusion, Wayne! In the heat of having to finish these, and not having the source system available I had to take a leap of faith and...

I don't have the source system right now, but based on our test environment, I think this might be the answer:

SELECT Year, Month, Week, PeriodBegin,PERIODEND, COUNT(task_id) AS No_of_Issues

FROM

(

SELECT DATEPART(YEAR,create_time) Year,...