No I dont want the average. I know how to calculate that.

I want to find out the median value.

Thanks

Oh Thanks Guys.

SO this means there is nothing wrong with my report then

Cheers

Thanks Guys

It works fine

Hi Tim

Basically I want to insert all rows from table B to table A

Hi

Thanks for your reply and apologies for not sending you the schema as I have stored my data in the temp table.

Here are the answers to your questions:

1) Ideally...

Hi friend

I tried this query already.

May be i could not explain the requirements very well. My apologies...

Its basically the expenditure divided by 12 at each month . its basically...

It should be the cost(expenditure) divided by the no. of Doctors at each month.

HOpe this helps

Thanks guys!

So u mean I should not use the temp tables in BIDS??

The problem is I dont have the 'create table' permission on the database I use as its used...

Thanks for that

Cheers

Thanks for your help guys!

Will definately follow your advise

Hi

I had to import a txt file into sql server . I have attached the sample file for your reference.

It would be really good to know how to import...

Thanks a lot

It works well

Cheers:D

Thanks

This query works but how do I save these changes I mean when I run this query, it just displays the result into the window but how do I actually...

It doesnt work with this query!

The column remains unchanged (enclosed with the double quotes)

Works Well

Thnks