https://www.mssqltips.com/sqlservertip/3549/inventory-sql-server-services-version-and-edition/

If you want to learn PowerPivot, get Rob Collie's book. Takes a bit to get your head around, but he's really good at walking you through a lot of stuff....

You could do this in PowerPivot... makes it really easy... You can use PowerBI, which is a free download too... if you can get someone to install it for you....

Instead of using a tablix, use a matrix. then put the date field in the columns part of the matrix and you should be off to the races.

You have to join the two tables somehow

the INSERT INTO part is a bit of a red herring.

SELECT A.Field1, B.Field3

FROM A INNER JOIN B ON A.SomeKey = B.OtherKey

WHERE...

then you just...

post the CREATE TABLE and INSERT scripts so we have some data to work with. what version of SQL Server are you using?

Jason Selburg wrote an article with his code that does all this. without Enterprise edition. Probably worth a read.

HTH,

Pieter

Thanks for the create table/insert scripts. That helps a lot. One more thing, though. Could you post your expected output? Is the age of the dog significant...

where? Why not re-post the whole thing?

<DDL statements to create tables>

<DML to get at least part of the way there>?

If you're only using one dataset, you could have several tablixes on your report and do different summaries in each one. No need to nest at all. I did...

one option is to use subreport(s).

if (the validkey in error table is present in the lookup table)

then

update the record

else

exit

UPDATE Table1

SET Field = <something>

WHERE Table1.Field1 = Table2.JoinField

This worked for me:

=RIGHT(Fields!School.Value,LEN(Fields!School.Value)-InStr(Fields!School.Value," - ")-2)

the easiest way is to sort in descending order (and maybe filtering out unplayed games). Something like:

-- top 4 could be ANY number...

SELECT TOP 4 *

FROM (

SELECT 'W'...

You have to create a new dataset (option 1).