thanks sscrazy.........!!!!

it's a quick response.

There is nothing about consistency......... its just a question that someone asked me to do so..... he says its possible....!!!!

Trigger,OUTPUT, cascading are possible solution but i...

Jason-299789 (1/30/2013)

---

Mr. Kapsicum (1/30/2013)

---

Thanks uravindarreddy,,, Ur query is Great.

But Can U explain its working to me.,? I m a bit naive to SQL , cant understand its in depth working.!!

Thanks...

Thanks uravindarreddy,,, Ur query is Great.

But Can U explain its working to me.,? I m a bit naive to SQL , cant understand its in depth working.!!

Thanks again for ur...

Hii Jason, Thanks for ur reply.

Your first query works great..

But your 2nd and 3rd one does not serve the purpose. They skip the Null Rows.

Thanks Again.

Thanks a lot dgowrij,,, your query Works.....

But i dont want to use Derived Table. just simple where clause with one equi.

like: where color=@color,,,,,, using isnull and coalesce both in the...

No Arun,,,,,,

i do not supply @color=''

i supply @color=null

your query will give

ID COLOR

1 RED

2 BLUE

4 GREEN

5...

NO,

If @color=null,,, then

ID COLOR

1 red

2 blue

3 null

4 black

5 green

6 ...

Thanks SSC journeyman,,,,,,,,,,,,,,,,,,,,,

Where condition was good,,,,

But need some extra help also......

how to do it using coalesce and is null function. Please Sir.

Please share your answers..... need help.....!!!!!!!