say I have a table like this:

date delete
---- ----
12/3 0
12/4 1


I need a sql to give me this result basic on the "delete" column:
complete date delete date
------------- -----------
12/0
                12/4

how??

thanks!!

One way
the create table and insert is just for testing you would only modify the select statement below
create table testBla (date datetime, del bit)
insert into testBla
select '12/3/2005',0 union all
select '12/4/2005',1

select case when del =0 then date else null end CompleteDate,
case when del = 1 then date else null end DeleteDate from
testBla

“I sense many useless updates in you... Useless updates lead to fragmentation... Fragmentation leads to downtime...Downtime leads to suffering..Fragmentation is the path to the darkside.. DBCC INDEXDEFRAG and DBCC DBREINDEX are the force...May the force be with you" -- http://sqlservercode.blogspot.com/