Create table #tab(ID int , COLA char(5), COLB char(5) ,COLC char(5))

INSERT INTO #tab(ID ,COLA, COLB, COLC)

VALUES(1001,'1AAA' ,null, null), (1001 ,null,'2BBB', null),(1001,null,null, '3CCC')

SELECT

ID,

...

Thanks, i tried this way only thing which is different over here is where condition i place that condition in ON instead of where and that resulted in wrong...

thanks Mark, your solution worked for me ..thanks much.

Thanks Lowell For your reply.

No none of the developers are connected....as the database it is showing we are not using it as well as i killed all the processes but...

If i'm not wrong we are creating the Unique Index not Unique Key ...and what will happen if i make the composite column unique Key

Thanks

Vineet Bhargava

Can you help me out as i have no idea how to use indexed view for this situation

Thanks

Vineet Bhargava

Cause filtered index is a part of SQL Sever 2008 and i'm using 2005 🙁

Thanks

Vineet Bhargava

Thanks Sunitha

i know , But there must be some way to deal with it.

Regards

Vineet Bhargava

CReate table #tmp(id INT ,client_rank CHAR(1),Cycle INT,shipdate datetime)

INSERT INTO #tmp(id,client_rank,shipdate)

values

(43,'A','December 17, 2010')

,(44,'A','July 28, 2010')

,(44,'B','August 10, 2010')

,(44,'A','January 11, 2011')

,(44,'B','January 28, 2011')

,(45,'A','July 30, 2010')

,(45,'B','August 9, 2010')

,(45,'B','September 24, 2010')

,(45,'A','April 5, 2011')

,(45,'B','April 26,...

Can you please give some output example.It will be easier to answer your question.

Thanks

Vineet Bhargava