What I mean is it will show like

First line --> A B C D E

Second Line...

Hello Morris !

I think it is quite clear what I want to say, for your reference mail I am repeating my problem and requesting you to please go...

Still it is giving the same error .

Is there any problem in the group by clause ?

Subhro

Thanks Luts !

It worked.

Subhro

Thanks

John for your suggestion . I will do the same as you told.

Subhro

Hi ! Enthu

Thanks for your quick reply, I am sorry I haven't contact you B'cos it was already 6 pm and I want to...

Hey !!!!!

I am going to send some thing that will help to you to get the result, please go through...

OK Paul I will see it.

Thanks

Subhro

Thanks ColdCoffee for your reply ; but I have thought it in another way, I now have passed two value 'Highest' and 'Lowest' in a variable and putting it...

Thanks all of you for the suggestion .

I have myself made a small change LIKE :

use IRISDW_AF;

select Container_Id,End_Journey_Date

from dbo.Container

where datediff(day,'1/29/2009 12:00:00 AM',End_Journey_Date) BETWEEN 0 AND 5;

And it works

Thanks...

Thanks you Paul, You are a real "Genius"; Actually what ever I have asked that is a very smal part of a large Query.

Thanks once more

Subhro

Oh ! Sorry u have created an alias name of two tables, lets check and run it.

Subhro

I don't think that the query willgive the required data as there is no manager table, Only two tables are there and there is a primary key name contactID between...

Thanks for your assistance

Cheers

Subhro

Thank U so so much Cold Coffee,And very sorry that I am responding today as I had left my office at that moment.

May I know your name please, as...