View: dbo.State_View | |||
View definition | |||
-- This view exists to provide an integer key on state information that can be used in filters. -- It also adds the id and description columns to ease other aspects of the system that automate -- features based on the standard of having kan id-type column. -- This is really a kind of type table, so it follows those rules. -- Yeah, we'll end up with an oddball key for Federal (zero), but that's life. At this point -- it's more important that we get something easy to deal with - it'll match the ste_state_code_KEY. create view dbo.State_View as select state_KEY = convert(int, convert(decimal, S.ste_state_code_KEY)) , ste_state_code_KEY = S.ste_state_code_KEY , state_id = S.postal_code , description = S.name from dbo.Ste_State_Code S | |||