In that file data is

Scheme Code;Scheme Name;Net Asset Value;Repurchase Price;Sale Price;Date

101912;BARODA PIONEER BALANCE FUND -Growth Plan;23.65;23.41;23.65;07-Aug-2009

Where is this data coming from:-a website(amfiindia.com)

What format is it in:-this is in text format

What do you want to do with this data once you have it:- some analysis day,month,year...

with t as

(

select 'hello' as h

union all

select 'bye' as h

)

select * from t

This work fine but

when i write

with t...

But this is not a proper solution

my main problem is that

I have multiple category

In each category->Multiple Scheme Name

in each shceme name have multiple price based on day wise.

problem is that i want a result on...