{"id":5848,"date":"2014-07-24T06:05:57","date_gmt":"2014-07-23T21:05:57","guid":{"rendered":"http:\/\/fujiitoshiki.com\/improvesociety\/?p=5848"},"modified":"2017-04-27T16:51:12","modified_gmt":"2017-04-27T07:51:12","slug":"how-to-define-ktv-an-indicator-of-the-efficiency-of-dialysis-as-scalar-function-of-sql-server","status":"publish","type":"post","link":"https:\/\/www.fujiitoshiki.com\/improvesociety\/?p=5848","title":{"rendered":"How to define Kt\/V, an indicator of the efficiency of dialysis, as scalar function of SQL Server?"},"content":{"rendered":"<div class=\"theContentWrap-ccc\"><p>In Japan, Shinzato&#8217;s fomula for calculating Kt\/V, an indicator of efficiency of dialysis, is recommended by JSDT. Since integral equation is used to solve Shinzato&#8217;s method, you couldn&#8217;t solve algebraically. In K\/DOQQI, it is usual to solve Kt\/V with Daugirdas&#8217; method. Shinzato has described that Daugirdas&#8217; Kt\/V is similar to Shinzato&#8217;s Kt\/V. <\/p>\n<p><img src='https:\/\/s0.wp.com\/latex.php?latex=%5Cdisplaystyle+%5Cmathrm%7BKt%2FV%7D+%3D+-+LN%28+R+-+0.08+%5Ctimes+t+%29+%2B+%5Cleft%5B+4+-+%5Cleft%28+3.5+%5Ctimes+R+%5Cright%29+%5Cright%5D+%5Ctimes%5Cfrac%7B%5Cmathrm%7BUF%7D%7D%7B%5Cmathrm%7BW%7D%7D%5C%5C++%3D+-+LN+%5Cleft%28+%5Cfrac%7B%5Cmathrm%7BpostBUN%7D%7D%7B%5Cmathrm%7BpreBUN%7D%7D+-+0.008+%5Ctimes+t+%5Cright%29+%2B+%5Cleft%5B+4+-+%5Cleft%28+3.5+%5Ctimes+%5Cfrac%7B%5Cmathrm%7BpostBUN%7D%7D%7B%5Cmathrm%7BpreBUN%7D%7D+%5Cright%29+%5Cright%5D+%5Ctimes+%5Cfrac%7B%5Cmathrm%7BpreWeight%7D+-+%5Cmathrm%7BpostWeight%7D%7D%7B%5Cmathrm%7BpostWeight%7D%7D+%5Ccdots%281%29&#038;bg=T&#038;fg=000000&#038;s=0' alt='\\displaystyle \\mathrm{Kt\/V} = - LN( R - 0.08 \\times t ) + \\left[ 4 - \\left( 3.5 \\times R \\right) \\right] \\times\\frac{\\mathrm{UF}}{\\mathrm{W}}\\\\  = - LN \\left( \\frac{\\mathrm{postBUN}}{\\mathrm{preBUN}} - 0.008 \\times t \\right) + \\left[ 4 - \\left( 3.5 \\times \\frac{\\mathrm{postBUN}}{\\mathrm{preBUN}} \\right) \\right] \\times \\frac{\\mathrm{preWeight} - \\mathrm{postWeight}}{\\mathrm{postWeight}} \\cdots(1)' title='\\displaystyle \\mathrm{Kt\/V} = - LN( R - 0.08 \\times t ) + \\left[ 4 - \\left( 3.5 \\times R \\right) \\right] \\times\\frac{\\mathrm{UF}}{\\mathrm{W}}\\\\  = - LN \\left( \\frac{\\mathrm{postBUN}}{\\mathrm{preBUN}} - 0.008 \\times t \\right) + \\left[ 4 - \\left( 3.5 \\times \\frac{\\mathrm{postBUN}}{\\mathrm{preBUN}} \\right) \\right] \\times \\frac{\\mathrm{preWeight} - \\mathrm{postWeight}}{\\mathrm{postWeight}} \\cdots(1)' class='latex' \/><br \/>\n<img src='https:\/\/s0.wp.com\/latex.php?latex=%5Cdisplaystyle+%5Cmathrm%7BGw%7D+%3D+%5Cmathrm%7BG%7D%5Ccdot%5Cmathrm%7BTw%7D+%3D+%5Cmathrm%7BKd%7D%5Cint_%7B0%7D%5E%7BTd%7DC_1dt+%2B+%5Cmathrm%7BKd%7D%5Cint_%7B0%7D%5E%7BTd%7DC_2dt+%2B+%5Cmathrm%7BKd%7D%5Cint_%7B0%7D%5E%7BTd%7DC_3dt+%5Ccdots%282%29+&#038;bg=T&#038;fg=000000&#038;s=0' alt='\\displaystyle \\mathrm{Gw} = \\mathrm{G}\\cdot\\mathrm{Tw} = \\mathrm{Kd}\\int_{0}^{Td}C_1dt + \\mathrm{Kd}\\int_{0}^{Td}C_2dt + \\mathrm{Kd}\\int_{0}^{Td}C_3dt \\cdots(2) ' title='\\displaystyle \\mathrm{Gw} = \\mathrm{G}\\cdot\\mathrm{Tw} = \\mathrm{Kd}\\int_{0}^{Td}C_1dt + \\mathrm{Kd}\\int_{0}^{Td}C_2dt + \\mathrm{Kd}\\int_{0}^{Td}C_3dt \\cdots(2) ' class='latex' \/><br \/>\n<img src='https:\/\/s0.wp.com\/latex.php?latex=%5Cdisplaystyle+%5Cmathrm%7BCe%7D+%3D+%5Cmathrm%7BCs%7D+Exp%5Cleft%28+-+%5Cfrac%7B%5Cmathrm%7BKt%7D%7D%7B%5Cmathrm%7BV%7D%7D+%5Cright%29+%2B+%5Cfrac%7B%5Cmathrm%7BG%7D%7D%7B%5Cmathrm%7BK%7D%7D%5Cleft%5B+1+-+Exp%5Cleft%28+-+%5Cfrac%7B%5Cmathrm%7BKt%7D%7D%7B%5Cmathrm%7BV%7D%7D+%5Cright%29+%5Cright%5D+%5Ccdots%283%29&#038;bg=T&#038;fg=000000&#038;s=0' alt='\\displaystyle \\mathrm{Ce} = \\mathrm{Cs} Exp\\left( - \\frac{\\mathrm{Kt}}{\\mathrm{V}} \\right) + \\frac{\\mathrm{G}}{\\mathrm{K}}\\left[ 1 - Exp\\left( - \\frac{\\mathrm{Kt}}{\\mathrm{V}} \\right) \\right] \\cdots(3)' title='\\displaystyle \\mathrm{Ce} = \\mathrm{Cs} Exp\\left( - \\frac{\\mathrm{Kt}}{\\mathrm{V}} \\right) + \\frac{\\mathrm{G}}{\\mathrm{K}}\\left[ 1 - Exp\\left( - \\frac{\\mathrm{Kt}}{\\mathrm{V}} \\right) \\right] \\cdots(3)' class='latex' \/><\/p>\n<p>Execute the procedure as following; <\/p>\n<pre class=\"lang:tsql decode:true \" >\r\nCREATE FUNCTION Function_KtV \r\n(\t\t@preBUN DEC(4, 1)\r\n\t,\t@postBUN DEC(4, 1)\r\n\t,\t@preWeight\tDEC(4, 1)\r\n\t,\t@postWeight DEC(4, 1)\r\n\t,\t@DialysisDuration\tint\r\n)\r\nRETURNS DEC(3,2)\r\nAS\r\nBEGIN\r\n\tDECLARE\t@KtV DEC(3, 2)\r\n\tSELECT\t@KtV = - LOG(@postBUN \/ @preBUN - 0.008 * @DialysisDuration \/ 60) \r\n\t\t\t\t\t+ (4 - (3.5 * @postBUN \/ @preBUN))\r\n\t\t\t\t\t* ((@preWeight - @postWeight) \/ @postWeight)\r\n\tRETURN\t@KtV\r\nEND\r\nGO\r\n<\/pre>\n<p>References: JSDT 29 (12): 1511-1516, 1996<\/p>\n<p><a href=\"\/\/jasn.asnjournals.org\/content\/4\/5\/1205.full.pdf\" title=\"Second Generation Logarithmic Estimates of Single-Pool Variable Volume\" target=\"_blank\">Second Generation Logarithmic Estimates of Single-Pool Variable Volume<\/a><\/p>\n<p><iframe style=\"width:120px;height:240px;\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\" frameborder=\"0\" src=\"\/\/ws-na.amazon-adsystem.com\/widgets\/q?ServiceVersion=20070822&#038;OneJS=1&#038;Operation=GetAdHtml&#038;MarketPlace=US&#038;source=ss&#038;ref=ss_til&#038;ad_type=product_link&#038;tracking_id=improsocie-20&#038;marketplace=amazon&#038;region=US&#038;placement=0123820227&#038;asins=0123820227&#038;linkId=LXJBROSN54NZGFQG&#038;show_border=true&#038;link_opens_in_new_window=true\"><br \/>\n<\/iframe><iframe style=\"width:120px;height:240px;\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\" frameborder=\"0\" src=\"\/\/ws-na.amazon-adsystem.com\/widgets\/q?ServiceVersion=20070822&#038;OneJS=1&#038;Operation=GetAdHtml&#038;MarketPlace=US&#038;source=ss&#038;ref=ss_til&#038;ad_type=product_link&#038;tracking_id=improsocie-20&#038;marketplace=amazon&#038;region=US&#038;placement=B00JI50L0M&#038;asins=B00JI50L0M&#038;linkId=TBXDLJXWCL2FZME3&#038;show_border=true&#038;link_opens_in_new_window=true\"><br \/>\n<\/iframe><\/p>\n<\/div>","protected":false},"excerpt":{"rendered":"<p>In Japan, Shinzato&#8217;s fomula for calculating Kt\/V, an indicator of efficiency of dialysis, is recommended &hellip; <a href=\"https:\/\/www.fujiitoshiki.com\/improvesociety\/?p=5848\" class=\"more-link\"><span class=\"screen-reader-text\">&#8220;How to define Kt\/V, an indicator of the efficiency of dialysis, as scalar function of SQL Server?&#8221; \u306e<\/span>\u7d9a\u304d\u3092\u8aad\u3080<\/a><\/p>\n","protected":false},"author":1,"featured_media":6024,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_crdt_document":"","_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[1,11,4],"tags":[134,141,135,137,142,136,128],"class_list":["post-5848","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-database","category-healthcare","category-nutrition","tag-daugirdas","tag-efficiency-of-dialysis","tag-ktv","tag-scalar-function","tag-shinzato","tag-sql-server","tag-the-japanese-society-for-dialysis-therapy"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/www.fujiitoshiki.com\/improvesociety\/index.php?rest_route=\/wp\/v2\/posts\/5848","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.fujiitoshiki.com\/improvesociety\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.fujiitoshiki.com\/improvesociety\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.fujiitoshiki.com\/improvesociety\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.fujiitoshiki.com\/improvesociety\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=5848"}],"version-history":[{"count":7,"href":"https:\/\/www.fujiitoshiki.com\/improvesociety\/index.php?rest_route=\/wp\/v2\/posts\/5848\/revisions"}],"predecessor-version":[{"id":7776,"href":"https:\/\/www.fujiitoshiki.com\/improvesociety\/index.php?rest_route=\/wp\/v2\/posts\/5848\/revisions\/7776"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.fujiitoshiki.com\/improvesociety\/index.php?rest_route=\/wp\/v2\/media\/6024"}],"wp:attachment":[{"href":"https:\/\/www.fujiitoshiki.com\/improvesociety\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=5848"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.fujiitoshiki.com\/improvesociety\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=5848"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.fujiitoshiki.com\/improvesociety\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=5848"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}