Thanks a lot guys

Query works fine now!:w00t:

Hey thanks Ken.

This query works fine but how do I modify this query to update the entire table?

Hi

Looks like the entire daa did not cme through

Here is it

DoctorName Test06 test08 difference

ddd ...

Thanks for your help.

Yes I totally agree

Cheers:)

Works well

Thanks:)

Hi

It gives me the syntax error like this

Msg 156, Level 15, State 1, Line 1

Incorrect syntax near the keyword 'CASE'.

What to do??

Thank you so much!!v :hehe:

That exactly what I wanted

God bless

Cheers

😀

Hi

Here is the sample data

Start date Days ...

Hi

Thanks for replying

This is the query which i use to calculate the cost :

Select Year(x.dates) As [Year], Month (x.dates) As [Month],x.clinicalservice

Sum(dailyvol) As cost

From c.dates,f.clinicalService,

(f.cost / (DateDiff(dd, f.[Start date], f.[End...

start date and end date are of 'datetime' format and cost is float

I get this error

'Conversion failed when converting the nvarchar value to data type int.'

I know what sum is and what count is....:)

I mentioned earlier as well I tried to put a count on instead of sum but I get an error especially in...

Hi

Thanks for your help

I ran the query but the figures are really really low!!

Hi

Ill explain the situation again

Its really simple for ex a patient 'A' was in rest home from '1/1/2004' to 12/2/2004'

and then the same patient 'A' was then moved...

Thanks for that. This helps

Cheers