Good point.. but I'll still wait for the poster's answer on this one .

You lose the use of the date functions associated with the datetime datatype (or you have to reconvert back to be able to use them). Also you might lose...

poster is trolling???

Statement. Unless you preffer to change the datatype to char(10), which I just wouldn't recommend.

Are you missing those words already???

I a g r e e .

Hey petey20, can you settle this on for us?

Can you rerun the query without the converts but with the missing link and tell us the time?

You can create a text file as linked server. Then I assume you can just do insert into linkedFileName[.?.?] (col1, col2) exec myproc.

I know you can insert into... but...

From the books online under Delete / operator

USE pubs

DELETE titleauthor

FROM titleauthor INNER JOIN titles

ON titleauthor.title_id = titles.title_id

WHERE titles.title LIKE '%computers%'

Yes and no...

How can the converts be accountable for 97% of the work in the query (from 30 secs to 1)? I'm wondering if the missing link might not...

Did you check for the execution plan? Did it use a scan? has the compound index done anything to speed this up?

Thanx for reading the 9 pages, it takes a lot of courage to read through all this waste of time. Anyways ,as I said, I thinks he wants only...

Is this what you need?

Select P.Id, P.Product, min(D.ItemNo) as ItemNo from dbo.Products P left outer join dbo.Details D on P.id = D.id

group by P.Id, P.Product

order by P.Id, P.Product

Or actually put the 2 textbox one above the other .

me.txtbox.text = myrs.fields("Field1").value & vbcrlf & myrs.fields("Field2").value

Happy to help.