thanks John it worked.

i've updated the script if others get stuck to a similar problem

SELECT a.Coding_Source, ad.Admit_Date, dd.Disch_Date, pn.Patient_No, w.Ward, ed.Episode_Date,

ROW_NUMBER() OVER(Partition by en.Episode_Number ORDER BY en.Episode_Number) AS...

many thanks for replying.

the input values will be recieved using reporting services field on report. The user will type the code. Future work will use reference table. please see...

i just used in the actions [@FinYear] or [@FinMonth]etc and this worked for multivalue

I think i've cracked it...but needs testing

SELECT F.Crn, F.admission, F.Procedures

FROM tbl_PS_IXP_MEDREC_PROCS_FLAT AS F INNER JOIN

...

Thanks for the reply i don't fully understand that code for ssc

This is what i got for if the value was single string and works

codes

w811

s222

f224

SELECT Procedures,...

Finally got it working. Many thanks for all of you to providing help.

i've posted the code if anyone else comes to the same problem.

USE [ColossusUser]

GO

/****** Object: UserDefinedFunction [dbo].[fFinYear] ...

hi lynn,

thats right for fiscal year 01/04/2010 to 31/03/2011 would be 2010/11

sorry i wasn't clear enough.

from the two views i want the two results to be combined into one view.

i.e

NoDaycase noElective Dis_Spec ...

yup we got it working finally.

His one of my staff....i asked him to search on the forums. Just pot luck that he came to the same forum. I'm more of apps developer and done sql...

thank you for both responses.

i have similar query which if i wanted to calculate the 14 days from the disdate from the admdate

e.g

crn admdate ...

This is perfect,

Can you quickly go over the SQL statement. Its learning curve and learning as i go along.

Nope its not homework i'm afraid, i'm out of practice...

thank you for responding....however i don't think i've clearly explained myself.

The CRN is patient identification No. What i'm trying to do is see how many of the same patients (CRN's)...

I've tried to simply it...but get an error saying Msg 156, Level 15, State 1, Line 2

Incorrect syntax near the keyword 'CASE'.

SELECT COUNT(NHSNo) AS [patientvol]

CASE...

Hi thankyou for replying how would i be able to apply this to the example if you given me?

USE [InformationServices]

GO

/****** Object: StoredProcedure [dbo].[p18WeekPTLAdmitted] Script Date: 10/19/2009...