start here:

http://www.sqlservercentral.com/articles/comma+separated+list/71700/

I fixed up your create table/insert scripts. No Semi-colons?

use tempdb;

go

Create table EMP

(ID INT,

NAME NVARCHAR(10)

);

GO

insert into EMP values (1, 'JOHN')

create table EMP_INFO

(ID INT,

STARTDATE DATE,

ENDDATE DATE);

GO

insert into EMP_INFO values

(1,...

Maybe start here:

http://www.sqlservercentral.com/articles/Best+Practices/61537/

The data you posted explains your table structures, but it's not usable.

Steps to get this to work... (seems I always say that!)

1. Create your stored procedure...

ALTER PROC [dbo].[ReferralsData]

AS

SELECT ReferralID,

RefDate,

CASE RefType WHEN 1 THEN 'Internal' ELSE 'External' END ReferralType

FROM Referral;

Note that there...

Sorry for the vague response, but I think I remember seeing this in Teo Lachev's SSRS book on SSRS 2008. You can basically build an expression for the datasource...

one way to do it is to remove the Active=@Active parameter from your stored procedure and put it in your report as a filter. You can create a parameter,...

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