Ok but you just for got the time he needs to learn that there is a view wizzard -- (unknown until you hit the forum but I am going to...

He already have the anwser

SSC TSQL forums are faster

select S.Data SourceData, d.data DestinationData

from

    B join A as S on S.ID = B.SourceID

    join A as D  on D.SID = B.DestID

I could improve my typing skills ... which could give me an edge ?

If you have sufficient disk space, copying the data to build a new table may run much faster than updating the existing table.

That is a very BIG may

1....

Most of the time I do

Like I said there is always more than one way to skin a cat

Damn are we having a bad day or what??????

It's hard to beat your typing...  no time to loose

SELECT Product, 1.0*SUM(SaleQty)/datediff(m,Min(SaleDate)-Max(SaleDate))AvgSalesPerMonth

FROM

 orderdetail

GROUP BY  Product

Will be simpler

Just wondering how to use Time DataType

it is just a matter of exploiting less convertions

select directly to a client, add time to a value with a simple "+" sign,.....

Suppose you need to save times only. it is very handy and you can count how many posts do you get here on how to get rid of the time...

Never said that they cannot be updated but When you get used to SET BASED manipulations and you come across all thoses digusting method that prevent trigger firing concatenation is...

(sorry getting sick of seeing this field split).

You may be relieved to know then that 2005 have DATE and TIME types

here is another way... ugly but you shouldn't need this anyways

USE tempdb

SELECT COL_NAME(OBJECT_ID('#temptable'), 1)

USE LocalDBName