Looks like if you had a ParentID (the ID of the parent/family of the child) in each of the queries you listed, you could just inner join them on ParentID,...

If you're trying to create a database on your local machine, then when you log into SQL Server, the instance should be something like YOUR_MACHINE_NAME\INSTANCE_NAME. Can you log in...

You owe it to yourself to make friends with Books On Line ( the help file for SQL Server ). Hidden very carefully under the F1 key. ...

What happened when you tried it using rectangles?

it would help a lot of you posted some dummy data for your tables. (CREATE TABLE and INSERT scripts).

Also, do the UNIONS and the NOT EXISTS separately. Maybe...

If you have dates in your table, you could use something like:

SELECT *

FROM Sales.Orders

WHERE Sales.Orders.OrderDate BETWEEN DATEADD(year,-1,GETDATE()) AND GETDATE();

You probably want to add 1 to the "one year ago" stuff...

BETWEEN...

Sorry, I should have clarified. You don't need the totals query at all. You can do the counting/totals whatever in SSRS. If you use a simple stored procedure...

Magy,

Thanks for the sample data... would be easier to consume if you did it like this or with create table/insert scripts. Just makes it easier to reproduce your problem...

If the date field is available, you could do something like this:

FORMAT(Fields!enrollDate.Value,"MMMM")

and it will format the date as a Monthname....

1="January" etc.

Drop a Matrix (not a tablix) onto the design surface of your report.

Drag [Staff] to the row,

[ServiceType] to the column

and drop the [Duration] to the value (intersection of Row &...

What happens if you create a stored procedure that has a different name, but is essentially the same stored procedure? Sounds like something is happening on the server we...

Why not just delete and recreate the dataset?

Scratch all that.

You have a basic normalization problem. If you had a single column/field in your table for e-mail address, then it would probably be a trivial question. ...

create this query:

SELECT EmailAddress, EMail1 AS Mail1

FROM #Test_table_2

UNION ALL

SELECT EmailAddress, EMail2

FROM #Test_table_2

then join that to whatever other table you need.

Normalization is a beautiful thing.

if you could create a column in the UserPolicy table that contains the 6 characters or whatever you're matching on in a single column (or at the column values start...