CREATE Function [dbo].[Maintenance] ( @ReqNo INT)
RETURNS @SM TABLE
(
Reqno numeric(9) NOT NULL,
rpt1 char(1) NULL,
recip1  varchar(50) NULL,
email1 varchar(50) NULL,
rpt2 char(1) NULL,
recip2  varchar(50) NULL,
email2 varchar(50) NULL
)
AS 
BEGIN


-- The temp should be like this--
DECLARE @tmp TABLE
(
ReqNum INT identity(1,1),
rpt char(1) NULL,
ReqNO numeric(9) NULL,
recip  varchar(50) NULL,
email varchar(50) NULL
)
---------------------------------

INSERT INTO @tmp (ReqNo, Rpt, recip, Email)
SELECT RequestID, Rpt, recip, Email
FROM Customer_Information
WHERE ReqNO = @ReqNO

INSERT INTO @SM(ReqNO
,rpt1
,recip1
,email1
,rpt2
,recip2
,email2)
SELECT
 ReqNO = (SELECT ISNULL(ReqNO,NULL) FROM @tmp WHERE ReqNum = 1)
 ,Rpt1 = (SELEcT ISNULL(Rpt,'') FROM @tmp WHERE ReqNum = 1)
 ,Recip1 = (SELEcT ISNULL(recip,'') FROM @tmp WHERE ReqNum = 1)
 ,Email1 = (SELEcT ISNULL(Email,'') FROM @tmp WHERE ReqNum = 1)
 ,Rpt2 = (SELEcT ISNULL(Rpt,'') FROM @tmp WHERE ReqNum = 2)
 ,Recip2 = (SELEcT ISNULL(recip,'') FROM @tmp WHERE ReqNum = 2)
 ,Email2 = (SELEcT ISNULL(Email,'') FROM @tmp WHERE ReqNum = 2)
 RETURN
END

Select RR.Reqno,RR.submitteddate,RR.paymentdt,SMD.rpt1,SMD.recip1,SMD.email,
SMD.rpt2,SMD.recip2,SMD.email2 
From REportInfo RR
Inner join Maintenace SMD
ON RR.reqno = SMD.reqno
where reqno = 140

Select RR.Reqno,RR.submitteddate,RR.paymentdt,SMD.rpt1,SMD.recip1,SMD.email,
SMD.rpt2,SMD.recip2,SMD.email2 
From REportInfo RR
cross apply dbo.Maintenace(RR.reqno) SMD
where reqno = 140