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

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?