rewrite your insert like this:
INSERT INTO @Temptable
SELECT t1.cusname,t1.address1,t1.address2,
CONVERT(VARCHAR,t2.arrdate,103)AS ArrivedDate,CONVERT(VARCHAR,t2.depdate,103) AS DEPTDATE,
t2.totaldays,t3.roomtype,t4.paid_amt,t4.payment_mode,
(SELECT taxvalue FROM taxdetails WHERE convert(VARCHAR,choosed_date,103)=
(SELECT max(convert(VARCHAR,choosed_date,103)) FROM taxdetails)) AS Tax_VALUE,
(SELECT sum(rate) from otherexpenses where bkid=@bookid) AS OT_Expenses,
(SELECT totamt FROM roombooked WHERE bookid=@bookid) AS RoomRent
FROM checkedout_details t4
left outer join roombooked t2 ON t4.book_id=t2.bookid left outer join roomdetails t3 ON
t3.rid=t2.rid left outer join
cusdetails t1 ON t1.cusid=t2.cusid WHERE t4.book_id=@bookid
UNION ALL
SELECT
hotel_name,address1,address2,city,state,pincode,phone_no,email_id,website
FROM hotel_details
SELECT * FROM @Temptable