{"id":5861,"date":"2014-07-31T06:05:17","date_gmt":"2014-07-30T21:05:17","guid":{"rendered":"http:\/\/fujiitoshiki.com\/improvesociety\/?p=5861"},"modified":"2017-04-27T16:49:03","modified_gmt":"2017-04-27T07:49:03","slug":"how-to-create-scalar-function-of-sql-server-in-order-to-define-npna","status":"publish","type":"post","link":"https:\/\/www.fujiitoshiki.com\/improvesociety\/?p=5861","title":{"rendered":"How to create scalar function of SQL Server in order to define nPNA?"},"content":{"rendered":"

The Japanese Society for Dialysis Therapy (JSDT) recommends PCR as an indicator of protein intake. Otherwise K\/DOQQI recommends nPNA. If you calculate Kt\/V with Daugirdas’ method, you can also define nPNA. <\/p>\n

\\displaystyle \\mathrm{nPNA} = \\frac{C_0}{36.3 + 5.48\\times\\mathrm{Kt\/V} + 53.5\/\\mathrm{Kt\/V}} + 0.168 \\\\ = \\frac{\\mathrm{preBUN}}{36.3 + 5.48\\times\\mathrm{Kt\/V} + 53.5 \/ \\mathrm{Kt\/V}} + 0.168 \\cdots(4)<\/p>\n

Execute the following procedure. <\/p>\n

\r\nCREATE FUNCTION Function_nPNA \r\n(\t\t@preBUN\t\tDEC(4, 1)\r\n\t,\t@postBUN\tDEC(4, 1)\r\n\t,\t@preWeight\tDEC(4, 1)\r\n\t,\t@postWeight\tDEC(4, 1)\r\n\t,\t@DialysisDuration\tint\r\n)\r\nRETURNS DEC(3, 2)\r\nAS\r\nBEGIN\r\n\tDECLARE @nPNA\tDEC(3, 2)\r\n\tSELECT\t@nPNA = @preBUN\r\n\t\/\t(36.3 + 5.48 * (dbo.Function_KtV(@preBUN, @postBUN, @preWeight, @postWeight, @DialysisDuration))\r\n\t+\t\t\t53.5 \/ (dbo.Function_KtV(@preBUN, @postBUN, @preWeight, @postWeight, @DialysisDuration)))\r\n\t+\t0.168\r\n\tRETURN\t@nPNA\r\nEND\r\n<\/pre>\n
Reference: Simplified nutritional screening tools for patients on maintenance hemodialysis<\/a>
\n