Thanx for your help.

Thanx for your input.

The second one, yes.

Thanx.

Thanx. I'm on my way...............................

Another question. Is this how I use the function? Both parameters separated by comma?

inner join dbo.ufnCHFPatients(@StartDate,@EndDate)

Thanx. One more question........can I join TVFs the same way as a table or view?

Pardon my ignorance but, I thought I was creating a TVF. I knew that I would be returning more than one value.

The whole point of me creating this is...

Perfect! Thanx.

Could you give me a short, simple explanation of the difference between the two?

CREATE TABLE AbstractData

(SourceID varchar(3),

AbstractID int,

UnitNumber varchar(6),

PatientName varchar(50),

PtStatus varchar(5),

LocationID varchar(10),

DischargeDateTime datetime

)

INSERT INTO xxAbstractData (SourceID,AbstractID,UnitNumber,PatientName,PtStatus,LocationID,DischargeDateTime ) VALUES ('BRO', '1234','167890','xxx,yyyy', 'IN','A2','2012-01-01')

INSERT INTO xxAbstractData (SourceID,AbstractID,UnitNumber,PatientName,PtStatus,LocationID,DischargeDateTime ) VALUES ('BRO', '1235','527890','zzz,yyyy', 'IN','A2','2012-01-02')

INSERT INTO xxAbstractData (SourceID,AbstractID,UnitNumber,PatientName,PtStatus,LocationID,DischargeDateTime...

Thanx.

The code that I just posted is done on the production server. I made the point about both because one worked and the other didn't, even though I followed the...

It worked on my test server but, not on the one I need.

exec sp_help xxDR1 --top query

Column_nameTypeComputedLengthPrecScaleNullableTrimTrailingBlanksFixedLenNullInSourceCollation

UnitNumbervarcharno30 yesnoyesSQL_Latin1_General_CP1_CS_AS

PatientNamevarcharno50 ...

Perfect! I admire you guys that know this stuff and are willing to share.

I didn't get a working solution but, I've moved on.

Thanx anyways.

My bad. Sorry.

Please use my last thread with the code and sample data. I got things messed up a bit earlier.