CREATE TABLE ##PIPE_REPORT (
			  [Client ID]	varchar(50)
			, [BG Count]	varchar(50)
			, [Carb Count]	varchar(50)
			, [Med Count]	varchar(50)
)


INSERT INTO ##PIPE_REPORT (
			  [Client ID]
			, [BG Count]
			, [Carb Count]
			, [Med Count]
)
SELECT 		  [Client ID]
			, [BG Count]
			, [Carb Count]
			, [Med Count]
  FROM (
	SELECT	  'Client ID'		AS [Client ID]
			, 'BG Count'		AS [BG Count]
			, 'Carb Count'		AS [Carb Count]
			, 'Med Count'		AS [Med Count]
			, 0					AS Row_Order
 UNION ALL
	SELECT	  CONVERT(varchar(50),dbo.FN_Decrypt(@master, Login.LoginSkey,PatientDisplayID))	
								AS [Client ID]
			, CONVERT(varchar(50),COALESCE(SugarEntryCount,0))									
								AS [BG Count]
			, CONVERT(varchar(50),COALESCE((CarbsEntryCount,0))									
								AS [Carb Count]
			, CONVERT(varchar(50),COALESCE((MedsEntryCount,0))									
								AS [Med Count]
			, 1					AS Row_Order
	  FROM   #temp_patients 
INNER JOIN	 [Login] 
		ON   [Login].[LoginID] = #temp_patients.PatientID
) AS XXX
ORDER BY Row_Order