Error : Collation Conflict

 SELECT    Points AS Point_Issue_Points, Points AS Receipt_Points,'' AS Issue_Points, '' AS Point_Issue_InvoiceNo, ''  AS Point_Issue_Amount, Points.Point_Date AS Point_Issue_Date,'' AS Branch_ID,'' AS Merchant_ID, (SELECT        Merchant_Name
	                                FROM            Merchant_Details
	                                WHERE        (Merchant_ID = @Merchant_ID)) AS Merchant_Name,'Associate' AS Card_Holder_Name,'Receipt' AS Type
	   INTO              [#Temp1]
	   FROM            Points 
	   WHERE        (Points.Merchant_ID = @Merchant_ID) AND (@SearchType <> 'Issued')
	 --  SELECT * FROM #Temp1
	 SELECT    Point_Issue_Points, (CASE WHEN Point_Issue_Points<0 THEN (Point_Issue_Points * -1) ELSE '' END)AS Receipt_Points,(CASE WHEN Point_Issue_Points>0 THEN Point_Issue_Points ELSE '' END)  AS Issue_Points,Point_Issue.Point_Issue_InvoiceNo, Point_Issue.Point_Issue_Amount, Point_Issue.Point_Issue_Date, Point_Issue.Branch_ID, 
	                          Point_Issue.Merchant_ID,
	                              (SELECT        Merchant_Name
	                                FROM            Merchant_Details
	                                WHERE        (Merchant_ID = @Merchant_ID)) AS Merchant_Name, Card_Holder_Details.Card_Holder_Name,(CASE WHEN Point_Issue_Points<0 THEN 'Receipt' ELSE 'Issue' END) AS Type
	 INTO              [#Temp2]
	 FROM            Point_Issue LEFT OUTER JOIN
	                          Card_Holder_Details ON Point_Issue.Point_Issue_CardNo = Card_Holder_Details.Card_Unique_No
	 WHERE        (Point_Issue.Merchant_ID = @Merchant_ID) AND (@SearchType <> 'Receipt')
SELECT * FROM #Temp1 UNION ALL  SELECT * FROM #Temp2