View: dbo.GL_Account_Hash_View | |||
View definition | |||
create view dbo.GL_Account_Hash_View as select gla.gl_account_KEY, dbo.sf_SimpleNumericParse(gla.segment1) as segment1_hash, dbo.sf_SimpleNumericParse(gla.segment2) as segment2_hash, dbo.sf_SimpleNumericParse(gla.segment3) as segment3_hash, dbo.sf_SimpleNumericParse(gla.segment4) as segment4_hash, dbo.sf_SimpleNumericParse(gla.segment5) as segment5_hash, dbo.sf_SimpleNumericParse(gla.segment6) as segment6_hash, dbo.sf_SimpleNumericParse(gla.segment7) as segment7_hash, dbo.sf_SimpleNumericParse(gla.segment8) as segment8_hash, dbo.sf_SimpleNumericParse(gla.segment9) as segment9_hash, dbo.sf_SimpleNumericParse(gla.segment10) as segment10_hash, dbo.sf_SimpleNumericParse(gla.segment11) as segment11_hash, dbo.sf_SimpleNumericParse(gla.segment12) as segment12_hash, dbo.sf_SimpleNumericParse(gla.segment13) as segment13_hash, dbo.sf_SimpleNumericParse(gla.segment14) as segment14_hash, dbo.sf_SimpleNumericParse(gla.segment15) as segment15_hash, dbo.sf_SimpleNumericParse(gla.segment16) as segment16_hash, dbo.sf_SimpleNumericParse(gla.segment17) as segment17_hash, dbo.sf_SimpleNumericParse(gla.segment18) as segment18_hash, dbo.sf_SimpleNumericParse(gla.segment19) as segment19_hash, dbo.sf_SimpleNumericParse(gla.segment20) as segment20_hash, dbo.sf_SimpleNumericParse(gla.segment1) as up_to_segment1_hash, dbo.sf_SimpleNumericParse(gla.segment1 + gla.segment2) as up_to_segment2_hash, dbo.sf_SimpleNumericParse(gla.segment1 + gla.segment2 + gla.segment3) as up_to_segment3_hash, dbo.sf_SimpleNumericParse(gla.segment1 + gla.segment2 + gla.segment3 + gla.segment4) as up_to_segment4_hash, dbo.sf_SimpleNumericParse(gla.segment1 + gla.segment2 + gla.segment3 + gla.segment4 + gla.segment5) as up_to_segment5_hash, dbo.sf_SimpleNumericParse(gla.segment1 + gla.segment2 + gla.segment3 + gla.segment4 + gla.segment5 + gla.segment6) as up_to_segment6_hash, dbo.sf_SimpleNumericParse(gla.segment1 + gla.segment2 + gla.segment3 + gla.segment4 + gla.segment5 + gla.segment6 + gla.segment7) as up_to_segment7_hash, dbo.sf_SimpleNumericParse(gla.segment1 + gla.segment2 + gla.segment3 + gla.segment4 + gla.segment5 + gla.segment6 + gla.segment7 + gla.segment8) as up_to_segment8_hash, dbo.sf_SimpleNumericParse(gla.segment1 + gla.segment2 + gla.segment3 + gla.segment4 + gla.segment5 + gla.segment6 + gla.segment7 + gla.segment8 + gla.segment9) as up_to_segment9_hash, dbo.sf_SimpleNumericParse(gla.segment1 + gla.segment2 + gla.segment3 + gla.segment4 + gla.segment5 + gla.segment6 + gla.segment7 + gla.segment8 + gla.segment9 + gla.segment10) as up_to_segment10_hash, dbo.sf_SimpleNumericParse(gla.segment1 + gla.segment2 + gla.segment3 + gla.segment4 + gla.segment5 + gla.segment6 + gla.segment7 + gla.segment8 + gla.segment9 + gla.segment10 + gla.segment11) as up_to_segment11_hash, dbo.sf_SimpleNumericParse(gla.segment1 + gla.segment2 + gla.segment3 + gla.segment4 + gla.segment5 + gla.segment6 + gla.segment7 + gla.segment8 + gla.segment9 + gla.segment10 + gla.segment11 + gla.segment12) as up_to_segment12_hash, dbo.sf_SimpleNumericParse(gla.segment1 + gla.segment2 + gla.segment3 + gla.segment4 + gla.segment5 + gla.segment6 + gla.segment7 + gla.segment8 + gla.segment9 + gla.segment10 + gla.segment11 + gla.segment12 + gla.segment13) as up_to_segment13_hash, dbo.sf_SimpleNumericParse(gla.segment1 + gla.segment2 + gla.segment3 + gla.segment4 + gla.segment5 + gla.segment6 + gla.segment7 + gla.segment8 + gla.segment9 + gla.segment10 + gla.segment11 + gla.segment12 + gla.segment13 + gla.segment14) as up_to_segment14_hash, dbo.sf_SimpleNumericParse(gla.segment1 + gla.segment2 + gla.segment3 + gla.segment4 + gla.segment5 + gla.segment6 + gla.segment7 + gla.segment8 + gla.segment9 + gla.segment10 + gla.segment11 + gla.segment12 + gla.segment13 + gla.segment14 + gla.segment15) as up_to_segment15_hash, dbo.sf_SimpleNumericParse(gla.segment1 + gla.segment2 + gla.segment3 + gla.segment4 + gla.segment5 + gla.segment6 + gla.segment7 + gla.segment8 + gla.segment9 + gla.segment10 + gla.segment11 + gla.segment12 + gla.segment13 + gla.segment14 + gla.segment15 + gla.segment16) as up_to_segment16_hash, dbo.sf_SimpleNumericParse(gla.segment1 + gla.segment2 + gla.segment3 + gla.segment4 + gla.segment5 + gla.segment6 + gla.segment7 + gla.segment8 + gla.segment9 + gla.segment10 + gla.segment11 + gla.segment12 + gla.segment13 + gla.segment14 + gla.segment15 + gla.segment16 + gla.segment17) as up_to_segment17_hash, dbo.sf_SimpleNumericParse(gla.segment1 + gla.segment2 + gla.segment3 + gla.segment4 + gla.segment5 + gla.segment6 + gla.segment7 + gla.segment8 + gla.segment9 + gla.segment10 + gla.segment11 + gla.segment12 + gla.segment13 + gla.segment14 + gla.segment15 + gla.segment16 + gla.segment17 + gla.segment18) as up_to_segment18_hash, dbo.sf_SimpleNumericParse(gla.segment1 + gla.segment2 + gla.segment3 + gla.segment4 + gla.segment5 + gla.segment6 + gla.segment7 + gla.segment8 + gla.segment9 + gla.segment10 + gla.segment11 + gla.segment12 + gla.segment13 + gla.segment14 + gla.segment15 + gla.segment16 + gla.segment17 + gla.segment18 + gla.segment19) as up_to_segment19_hash, dbo.sf_SimpleNumericParse(gla.segment1 + gla.segment2 + gla.segment3 + gla.segment4 + gla.segment5 + gla.segment6 + gla.segment7 + gla.segment8 + gla.segment9 + gla.segment10 + gla.segment11 + gla.segment12 + gla.segment13 + gla.segment14 + gla.segment15 + gla.segment16 + gla.segment17 + gla.segment18 + gla.segment19 + gla.segment20) as up_to_segment20_hash, dbo.sf_SimpleNumericParse(gla.segment1 + gla.segment2 + gla.segment3 + gla.segment4 + gla.segment5 + gla.segment6 + gla.segment7 + gla.segment8 + gla.segment9 + gla.segment10 + gla.segment11 + gla.segment12 + gla.segment13 + gla.segment14 + gla.segment15 + gla.segment16 + gla.segment17 + gla.segment18 + gla.segment19 + gla.segment20) as full_account_hash from dbo.GL_Account as gla | |||