you would point to the calculated date if you wanted to do date calculations, comparisons etc. The 20040201 looks like a date (to you, not to SQL Server), so...

What are you trying to do with your SQL statement?

Definitely a case where some sample data would go a long way.

That said, I think you could use a UNION query to get what you want.

The great thing about it is that he walks you through all the gotchas and fixes them. I've been fighting with this stupid problem forever and finally found an...

This works, but I'm sure someone will correct it so it works better...

You would use your table name where I have "x" (just aliasing the select statement that contains the...

Finally got it sorted out... read this[/url] and followed the instructions (imagine that!). Figured Robert Pearl probably knows how to configure SSRS properly... not sure how I managed to...

In a query? Sure... it's a really old syntax, if that's what you're wondering. (I remember it from Oracle in 1999...)

thanks for the easily consumable data... (the only thing missing was the "extra" data so that you're sure it gets excluded).

Found this article discussing IN vs EXISTS, which was interesting......

I would probably just write normal INSERT statements for this (wrap it in a stored procedure so you can pass data in and do whatever you want inside).

What are you...

I think you're right... you don't need an EXISTS subquery... you can do all this with a join. =)

Something along these lines:

SELECT SalesOrderID

FROM Sales.SalesOrderHeader

WHERE DATEPART(hh,OrderDate) BETWEEN 9 AND 12;

returns all the leads where lead_id = 159, because at least one in the set contains an 'M' activity type code. If you run it, it returns 5 records.

Correlated subqueries are your friend...

select top 1000 lead_id, activity_type_code, activity_date,

row_number() over(partition by lead_id order by activity_date desc) rownum

from [PartitionExample] pe

WHERE EXISTS (SELECT 1 FROM PartitionExample WHERE activity_type_code = 'M'...

If SSRS is seeing the value as a string and not a date, you could create a calculated field in your dataset and set the value to something like this:

=DATESERIAL(CInt(LEFT(Fields!SomeDate.Value,4)),CInt(MID(Fields!SomeDate.Value,5,2)),CINT(RIGHT(Fields!SomeDate.Value,2)))

If...

A picture may be worth a thousand words, but some sample data is priceless. Can't test what we can't model, so please post some. Otherwise, I doubt you...