Thanks for the reply. Seems like a viable solution. I will have to look into that.

Steve. You are clearly miserable and you have not been helpful..at all. You didn’t answer any question with any substance. You are an “elitist” and I strongly emphasize the...

Thanks Thom A..CTE was the solution for this, for me. Anyhow, here it is. Thanks again.

declare @Job varchar(20)
set @Job = 'P000111045'

with ItemDistinct
as...

Steve,
In the many years  I have come to SQL Server Central for some help, this is the only time I've ever had a bad experience.
Based on your pattern...

Thanks for your response, I was thinking CTE too but, not 100%. Will try now.

The 1=1 is maybe the coolest time saver ever!!!!
It enables you  to quickly...

Thanks..To add a bit more context, I will add the SQL;
select distinct
  JI.item
from JobInfo as JI
where (1 = 1)
  and (JI.job = 'P000111032')
This...

Thanks so much John..
I made a minor change but wnat to be 100% confident. Can you take a look?

Original
AND dbo.manifests.manifest_date >= DATEADD(DAY,CASE WHEN DAY(manifest_date)=1...

Yes, this is great. Thanks

Thanks, going to try this.

I ended up using this. Thanks

WHERE 1=1 AND I.InvoiceDate >= DATEADD(yy,-3,DATEADD(yy,DATEDIFF(yy,0,GETDATE()),0))

Thanks for the reply. I created what I was looking to do.

AS a follow-up.

The view seems to be the issue. When taking the SQL from the view, it imports in less than 10 seconds using the SQL import wizard. When doing...

Thanks for the quick responses.

Here is what I ended up with.

The issue I was having is with the default end date. For every date other that the 1st, it...

Hi Guys,

thanks for the great solution. I guess if it were a perfect world, I'd be able to change the SSRS date/Time params to customize a time period.

Your solutions both...