Thanks a ton...

I got my requirement fixed beautifully.

Thanks a lot for all the people who took efforts to get my think done.

Without u guys..it would have been really tough for...

oops... i'm sorry

i wanted to say 09 March and instead i typed 19 March there...

sorry the output should have it as 09 Mar 2004

hey ...

looks like the query does not fit this criteria

01 Jan 2004

02 Jan 2004

07 Jan 2004

01 Feb 2004

04 Feb 2004

06 Feb 2004

04 Mar 2004

09 Mar 2004

18 Mar 2004

20 Mar 2004

28...

Let me put out my requirements clearly

This is the data that i have in the table

2004-01-01 00:00:00.000

2004-01-02 00:00:00.000

2004-01-03 00:00:00.000

2004-02-07 00:00:00.000

2004-02-14 00:00:00.000

2004-03-06 00:00:00.000

2004-03-19 00:00:00.000

2004-03-24 00:00:00.000

2004-03-28 00:00:00.000

2004-03-29 00:00:00.000

2004-03-31 00:00:00.000

My output should...

Just a question on your stored proc

This is the data that i have in the table

2004-01-01 00:00:00.000

2004-01-02 00:00:00.000

2004-01-03 00:00:00.000

2004-02-07 00:00:00.000

2004-02-14 00:00:00.000

2004-03-06 00:00:00.000

2004-03-19 00:00:00.000

2004-03-24 00:00:00.000

2004-03-28 00:00:00.000

2004-03-29 00:00:00.000

2004-03-31 00:00:00.000

My output should be...

here it is ...

Does this query make sense

SELECT   *

FROM     dbo.tst

WHERE    dte           = (SELECT MIN(dte) FROM dbo.tst)

UNION

SELECT   *

FROM     dbo.tst

WHERE    dte           = (SELECT MAX(dte) FROM dbo.tst)

UNION

SELECT   TOP 4 *

FROM     dbo.tst

WHERE    dte          IN...

Hey. I am not attending any university.

this is one of my project requirements

Thanks

Shankar

Perfect.

this is what i want.

But, can u tell me one thing.

Is there a way i can get this done using only Select Statements.

thats my requirement actually.

I can have even 6...

Thanks for your Stored Proc here.

I have an additional thing that is needed here.

Suppose if the number of months exceeds 6, then i need to pick the max of the...

my requirement is i need to use SQL's only.

I should not use Stored Proc for this.

i can have multiple SQL's and then i do a Union of these.. thats allowed.

Can...