Advertisement
Wacharakiat

Untitled

Aug 20th, 2015
362
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.50 KB | None | 0 0
  1.             SELECT dbo.[FN_Get_WordingText2](@policyID,
  2.                             'eff_begin_date='+@ls_wait_to
  3.                             +';previous_eff_begin_date='+ @ls_wait_to_previous
  4.                             +';With_in='+@ls_exclusion_to
  5.                             +';first_cover='+CAST(@lnm_dvs_first_cover AS VARCHAR(10))
  6.                             +';second_cover='+CAST(@lnm_dvs_second_cover AS VARCHAR(10))
  7.                             +';effective='+CONVERT(VARCHAR,CAST(@ls_effective AS datetime),103)+' '+CONVERT(VARCHAR,CAST(@ls_effective AS datetime),108)
  8.                             +';Chronic_to='+@ls_chronic_to
  9.                     ) AS policy_condition
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement