Thanks for your reply

I am running sql server 2000.

while I try to run the script I got an error message

Server: Msg 195, Level 15, State 10, Line 7

'row_number' is not...

Great !!! Its working

Thanks for your help.

i mean i could restrict it by @param.

Could you think of SQL construct. How should be query be ?

Thnaks for your help

yes I could restrict it by entering any or all parameters

This Report is for only Internal use only. Specially for Technical team.

Secondly, the data itself stored in sql table is for present day only , after 24 hours time data...

Hi

Yes you are right , i see you have tied down with months , so if the year is correct and month is wrong , i see all records for...

drop table test

GO

CREATE TABLE test (

[order] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

[year] [varchar] (50)...

Hi

Thanks for your help.

Is your last query different from your second last one .

Because while I select incorrect year but correct month , I get no records.

Thanks

Great! Its working.

1) When I selected year 2009 and month December , it only showed me one result (which is what I wanted)

2) When I selected year 2009 and...

Hi

Thanks for your help.

select case Month

WHEN 'December' THEN 'December'

ELSE Month

END AS Month, [order], [year] from test

where year = '2009'

I see you have used case , but when I run your...