So if i change the stored procedure as below. will it work even though if someone doesn't pass the parameter @b-2

Create procedure test

( @a nvarchar(100) =...

Thanks all for the help.

There are like 50 look up tables in our database...

then in all the look up tables he has like Active or Inactive values...

so based onthe acitve/inactive values he has to...

I am sorry Welsh...

I didn't mean not to answer the questions...I was very busy and didn't find time to respond..

Yes you are right if i respond to the questions...then only...

Yes Sir- Now i got it...

Thank you so much i have used the Group by clause...thanks sir

you are so great...thanks a lot again

Ok Sir am working on the development of the SQL code... Am trying on it...

Thanks everyone for the help and sorry for your time...

Thanks a lot again to everyone for...

Hello all,

I am very sorry for the late replies...

i been busy at work and have to attend the...

Yes sir, i need the earliest date of the particular status

Hi everyone

Am sorry if i confused everyone..

I am not getting the result with the code provided by some Sr developers.

There...

Reason i have posted again because i did not get help with the previous post...

so i just gave some additional information in this post and posted again...

sorry for the confusion

but...

Hello Jeff,

I am sorry for the late reply, thanks a lot for your reply

But actually if values in...

I am sorry again, for the wrong dates

Create Table Status

( ID int Identity(1,1),

ClientID int,

StatusStartDate Datetime,

Status Int)

Insert into Table Status(ClientID,StatusStartdate,Status)

Values(100,'2010-01-28',1)

Insert into Table Status(ClientID,StatusStartdate,Status)

Values(100,'2010-03-20',1)

Insert into Table Status(ClientID,StatusStartdate,Status)

Values(100,'2010-05-30',2)

Insert into...

I am sorry, I forgot about posting the scripts.

Create Table Status

( ID int Identity(1,1),

ClientID int,

StatusStartDate Datetime,

Status...

Thanks for your reply Welsh.

Yes i was trying to create a good database structure.

that is the reason i posted the question on forum..As there are so many good professionals/developers on...

Thanks everyone with your suggestions. really helps me...