stored procedure not showing a result
Stop using things like varchar without specifying the length. Watch what happens here:

CREATE PROCEDURE [dbo].[Reconciliation_broken]
    @Param1 varchar
AS
BEGIN
    SET NOCOUNT ON;
    PRINT @Param1;
END
GO
EXEC dbo.Reconciliation_broken @Param1 = 'what happened?';


Results:

w


When you don't specify the length, you get silent truncation - in some cases it is 30 characters; in this case, it is 1 character. There is no error message or warning - in fact if you were inserting data here you would be inserting 1 character and who knows how long you would be doing that before you realized. That data would be lost with no hope of recovery.

So, change those parameters to match the data type and length of the underlying columns. For more information, see: 


Bad habits to kick : declaring VARCHAR without (length)