If the Inserted Data is very huge and If u are going to use the three columns for joining purpose then it will be good idea to go for composite...

Is any proccess blocked , find out from sysprocesses tabes and if blocked then kill it manually , it will slove your issue.

This query will return  the consequitve row ,Try this and let me know u r looking for this resutl

select a.employeeid , a.freight ,2 countno

from test a, test b

where a.freight...