Skip to content

Instantly share code, notes, and snippets.

/gist:332686

Created March 15, 2010 10:02
Show Gist options
  • Save anonymous/332686 to your computer and use it in GitHub Desktop.
Save anonymous/332686 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.txt
INSERT INTO "H_ANLAGEN_2001" ("BVDEP_ID_NUMBER", "PATENTE", "GOODWILL", "LAND", "GEBAUDE", "MASCHIENEN")
SELECT
("ASSETS"."BVDEP_ID_NUMBER"), ("ASSETS"."INTANGIBLE_FIXED_ASSETS"*0,5), ("ASSETS"."INTANGIBLE_FIXED_ASSETS"*0,5), (("EXTRA"."DEPRECIATION"-(0,429*"ASSETS"."TANGIBLE_FIXED_ASSETS"))/0,461*2/3), (("EXTRA"."DEPRECIATION"-(0,429*"ASSETS"."TANGIBLE_FIXED_ASSETS"))/0,461*1/3),("ASSETS"."TANGIBLE_FIXED_ASSETS"-(("EXTRA"."DEPRECIATION"-(0,429*"ASSETS"."TANGIBLE_FIXED_ASSETS"))/0,461))
FROM "EXTRA", "ASSETS", "COMPANIES_ENTWICKLUNG"
WHERE "ASSETS"."BVDEP_ID_NUMBER" = "EXTRA"."BVDEP_ID_NUMBER" = "COMPANIES"."BVDEP_ID_NUMBER"
AND "EXTRA"."YEAR" = "ASSETS"."YEAR" = 2001
AND "COUNTRY"."COMPANIES_ENTWICKLUNG" = DE
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment