Hi

You have to add hour to both tables

SELECT cast(floor(cast(SaleTime as float)) as datetime)Saledate,DATEPART(hour,SaleTime) saleshour

,sum([SaleQty]) sumsales

into #salessum

...

Hi

Can use cross-join with hour table

This is easier solution by more costly on the execution plan

Learn allot very good article:-)

Right U are but U can see all the blocked paid's by order of waittime and can see what spid A is Doing by DBCC inputbuffur(spid a)

and decide if to...

U can find the deadlock on line by running the script:

select * from master..sysprocesses where blocked>0 and spid<>blocked

order by waittime desc

and find the spid

then use :

dbcc inputbuffer (spid no)...