thanks bteraberry,

Your Query was perfect for all the condition,im just expanding your query to accommodate all conditionn

Thank you very much Jason,

although it doesn't complete my current , its the first step and i feel confident of performing other parts task,

given the amount of time i...

if that is homework here is the answer 🙂

SQL> with test as

2 (

3 select 1 id ,to_date ('Jan-10', 'Mon-rr') mon,10.00 data from dual union...

Let me explain it in detail

Create table script (portion of the original table) which I have created in SQL Server

CREATE TABLE [Sample](

[ID] [int] NOT NULL,

[Month] [nchar](10) NOT NULL,

[data]...