She is baiting you to win a bet.  How was i to know pie was her favorite.

Mike

Great pictures Dale thanks.

 I would love to take that ride.

Mike

  "Anybody who has even remotely dreamed of authoring something is well aware of the distinctions between originality, poetic license & quoting...

Check and see how many rows are dublicates.

if object_id('tempdb..Test') >0

 DROP TABLE Test

CREATE TABLE Test

(

"Date" datetime,

"Unit" varchar(10), 

Company_Name varchar(20)

)

insert into Test values('4/2/05','bu002','ABC Company')--this is a dup

insert into Test values('4/2/05','bu002','ABC Company')--with this

insert...

I was there earlier. Very distinct programming style. If I get involved in that one I will never get anything done.

Besides it...

if object_id('tempdb..Test') >0

 DROP TABLE Test

CREATE TABLE Test

(

"Date" datetime,

"Unit" varchar(10), 

Company_Name varchar(20)

)

insert into Test values('4/2/05','bu002','ABC Company')

insert into Test values('11/30/04','bu002','ABC Company')

insert into Test values('4/2/05','bu002','ABC Company')

insert into Test values('5/12/05','bu002','ABC Company')

insert into Test values('11/3/05','bu002','ABC Company')

SELECT...

Ivelisse you are in good hands sushila will help you solve your problems.

Sushila I would love to stay and play but I'm expecting...

MOI? Forget something you said. I will sing you a song of six pence

Mike

But I think you won the bet although there is still a week to go

Great but no Haggis

if object_id('tempdb..Test') >0

 DROP TABLE Test

CREATE TABLE Test

(

aTime datetime,

avalue varchar(10), 

company varchar(20)

)

insert into Test values('4/2/05','bu002','ABC Company')

insert into Test values('11/30/04','bu002','ABC Company')

insert into Test values('4/2/05','bu002','ABC Company')

insert into Test values('5/12/05','bu002','ABC Company')

insert into Test values('11/3/05','bu002','ABC Company')

SELECT...

Hi sushila nice to see you. I joined a group hug the other day in the hopes you would show up which you never did so...

Hi do you want to eliminate the duplicates from the table (recommended) or just search for some values and show only one entry rather than duplicate entrys?

Mike

"Six years ago. I did see a lawyer. His position was "Do you really want to fight to keep the job? You certainly wouldn't want to work there now after...

Remi nice to see the R&R did not dull your brain. Welcome back hope the vacation was a good one.

Mike

I'm for the group hug thingy. Now if my favorite SLQ’er will just show her pretty head.

Lets extent the olive branch to all who will accept it.

Mike