Now above that I have

And ((

Case

when @SoldYN = 'Y'

then (

(SELECT COUNT(Distinct(A2.ParentActivityID))

FROM Activities A2

...

and

((

case

when @ActivityStatusID = 1

then ACS.[Description] = 'Completed'

when @ActivityStatusID <> 1

then ACS.[Description] <> 'Completed'

)

or @ActivityStatusID is null)

END

I still get Msg 102, Level 15, State 1, Line 369

Incorrect syntax near '='.

Sorry but no joy, I get Incorrect syntax near '='. Samething for the else

@ActivityStatusID is a paramater I am passing in.

If it is a 1 then I want to:

Select all where ... AND ACS.Description = 'Completed' --gets all that are completed

OR...

The sample Lowell sent works just fine.

Thanks Lowell, and Derrick.

KS

Ideally I would want my results to be

agentcode agentname

1 Nolrick1

But any name...

FYI, ccleaner did not work.

I am using windows 7 64bit. And yes I ran windows add/remove.

I'll try ccleaner.

Thanks,

KS

SELECT orderid, orderdate, custid, empid

FROM Sales.Orders

WHERE orderdate = DATEADD(month, DATEDIFF(month, '19991231', orderdate), '19991231');

--Here our orderdate field is year, month, day

Your a god send. You rock thanks very much.

Forgive my ignorance, but how?

The only commonality between the two tables is the timestamp.

One more thing. My initial problem was I left out teh weather location in the where clause.

Once I added that then all my figures were correct.

But another issue had popped...

😀 Awesome guy's thanks.