change in sp
Alter proc Sp_test1
@date1 datetime,
@date2 datetime
as
select distinct m.mcidno, CONVERT(VARCHAR(10),h.hdate,103)as hdate
from Tbl_Machine m inner join Tbl_History h
on m.mcidno=h.mcidno
where h.hdate between @date1 and @date2
Execution
exec Sp_test1 '2013/05/06', '2013/06/20'
Happy Coding!
:)