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...

Anything new and exciting in the new version (like screen captures/video that you can actually read)? Shame, because the rest of the book looks pretty good.

I have that book... the only thing I am not thrilled about is the quality of the videos. Going to see if it will work okay with SSIS 2012....

Maybe this will help... or not...

http://www.sqlservercentral.com/Forums/Topic1411242-149-1.aspx

From your description and table definition, I have no clue how to get what you want. What's the logic to accomplish that? To me at least, there's no...

I searched for "JSON" + "insert" here and found a ton of articles. Did you read any?

Did you add a parent row group on Itemname?

(I must be learning! I was close!)

some create table and insert scripts would go a long way to getting you a tested solution, but I would use ROW_NUMBER() to do this and not a totals query.

Something...

If a converted lead is just a property_id where there exists a move-in for that leadID, then you should be able to use EXISTS(), right?

Something like this:

SELECT lead_id

, property_id

, MIN(date_value)...