about the only thing you might be able to do is use LOOKUP to get data from the other dataset. Other than that, you'd have to combine them in a...

sounds like you have to change the dataset. If you drag a field from the list onto the tablix, it will bind the tablix to the dataset that the...

Why do you care about birthdays in your data warehouse? (might be a good reason, I don't know!)

What are you hoping to be able to query/get information about in your...

I doubt it. The problem is that the only way (I can think of) to write back to a table is through a stored procedure, and once the stored...

I just created a report with 3 tablixes on one page. (Mind you, none had many rows...) One thing you might check is whether there are Page Breaks set...

Something like this should work:

SELECT PhoneNum

, CHARINDEX('-',PhoneNum,1) AS ci

, LEFT(PhoneNum,CHARINDEX('-',PhoneNum,1)-1) AS code

, RIGHT(PhoneNum,LEN(PhoneNum)-CHARINDEX('-',PhoneNum,1))

FROM

(SELECT '123-12323' As PhoneNum

UNION ALL

SELECT '1234-1222') a;

I asked a DW guy about that not terribly long ago. He said that you have basically two fact tables which share the same dimension tables. The dimension tables...

SSIS is maybe the easiest. If you save the package, you can re-run it or add a conditional split so it only imports new records.

If you saved the Excel file...

My data is fake, because I didnt have yours.

SELECT 1111 AS MRN, 'hdhdhd' AS FirstName, 'hdhdhd' AS LastName, '5/21/2015' AS Date_Filled, 'Tylenol' AS...

Here's a screenshot of what I did. Hopefully it's clearer now.

One day, I promise to learn to read!

If you have to do this in SSIS, I'm at a loss...

Check out Jeff Moden's articles on Crosstabs & Pivots Part I[/url]...

you can't open it directly. You have to import it into an SSRS report project first.

(If you're using Excel 2013, you can do all this in Excel. Just create...

Just click the Edit Attachments below the message, then you can upload the file. ...

Put the Copay column into the same group as MRN and then use FIRST(Fields!Copay.Value)

Sounds like you need to use EXISTS and a subquery instead of INNER JOIN.

Your subquery would return all CustomerIDs who had 'Policy X', and then you'd use exists...

SELECT c.CustomerID, c.PolicyNumber

FROM...