• Please remember to wrap not safe for work text/images in [NSFW][/NSFW] tags.
    Example: [NSFW][img]http://darklygaming.com/images/spinnysgapedass.jpg[/img][/NSFW]

ctrl+v Part DEUX!

mandy

TD Member
2gwt8hy.jpg
 

Leroy

2012 Troll of the Year
you guys asked for it



CREATE VIEW V_WELL_ATTRIBUTES
AS
SELECT
WELL.WELL_ID AS ENUM_0,
WELL.DISPLAY_NAME_FORMAT AS ENUM_10,
WELL.WELL_NAME AS ENUM_20,
WELL.WELL_ALIAS_NAME AS ENUM_30,
WELL.API_NUMBER AS ENUM_40,
'' AS ENUM_50,
WELL.DLS AS ENUM_60,
WELL.NTS AS ENUM_70,
WELL.PROD_ID AS ENUM_80,
WELL.IMPORT_STATUS_DATE AS ENUM_90,
LKUP_GIS_STATUS.GIS_STATUS AS ENUM_100,
LKUP_PRIMARY_FLUID.PRIMARY_FLUID AS ENUM_110,
WELL.IMPORT_STATUS AS ENUM_120,
LKUP_COUNTRY.COUNTRY_NAME AS ENUM_130,
LKUP_PROVINCE_STATE.PROVINCE_STATE_NAME AS ENUM_140,
LKUP_COUNTY.COUNTY_NAME AS ENUM_150,
WELL.DISTRICT AS ENUM_160,
LKUP_PROPERTY.PROPERTY_NAME AS ENUM_170,
WELL.ONSHORE_OFFSHORE AS ENUM_180,
LKUP_BASIN.BASIN_NAME AS ENUM_190,
LKUP_BASIN.BASIN_CODE AS ENUM_200,
LKUP_FIELD.FIELD_NAME AS ENUM_210,
LKUP_FIELD.FIELD_CODE AS ENUM_220,
LKUP_FORMATION.FORMATION_NAME AS ENUM_230,
LKUP_FORMATION.FORMATION_CODE AS ENUM_240,
LKUP_POOL.POOL_NAME AS ENUM_250,
LKUP_POOL.POOL_CODE AS ENUM_260,
' ' AS ENUM_270,
' ' AS ENUM_280,
' ' AS ENUM_290,
' ' AS ENUM_300,
' ' AS ENUM_310,
' ' AS ENUM_320,
' ' AS ENUM_330,
' ' AS ENUM_340,
' ' AS ENUM_350,
' ' AS ENUM_360,
' ' AS ENUM_370,
' ' AS ENUM_380,
WELL.RIG_RELEASE_DATE AS ENUM_390,
WELL.SPUD_DATE AS ENUM_400,
WELL.KELLY_BUSHING_MSL AS ENUM_410,
WELL.GROUND_LEVEL_MSL AS ENUM_420,
WELL.CASING_FLANGE_MSL AS ENUM_430,
WELL.PLUGBACK_DEPTH_TVD_KB AS ENUM_440,
WELL.PLUGBACK_DEPTH_MD_KB AS ENUM_450,
LKUP_OPERATOR1.OPERATOR_NAME AS ENUM_460,
LKUP_OPERATOR1.OPERATOR_CODE AS ENUM_470,
LKUP_OPERATOR2.OPERATOR_NAME AS ENUM_480,
LKUP_OPERATOR2.OPERATOR_CODE AS ENUM_490,
' ' AS ENUM_500,
LKUP_BATTERY.BATTERY_NAME AS ENUM_510,
LKUP_BATTERY.BATTERY_CODE AS ENUM_520,
LKUP_PLANT_TYPE.PLANT_TYPE AS ENUM_530,
LKUP_PLANT_TYPE.PLANT_TYPE_DESC AS ENUM_540,
LKUP_PLANT_CODE.PLANT_CODE AS ENUM_550,
LKUP_PLANT_CODE.PLANT_CODE AS ENUM_560,
LKUP_LATERAL.LATERAL_NAME AS ENUM_570,
LKUP_LATERAL.LATERAL_CODE AS ENUM_580,
WELL.METER_NUMBER AS ENUM_590,
WELL.OIL_CONDENSATE_GATHERER AS ENUM_600,
WELL.GAS_GATHERER AS ENUM_610,
WELL.wellbore_radius AS ENUM_620,
WELL.well_type_ID AS ENUM_630,
' ' AS ENUM_640,
' ' AS ENUM_650,
' ' AS ENUM_660,
' ' AS ENUM_670,
' ' AS ENUM_680,
' ' AS ENUM_690,
' ' AS ENUM_700,
' ' AS ENUM_710,
' ' AS ENUM_720,
' ' AS ENUM_730,
' ' AS ENUM_740,
' ' AS ENUM_750,
' ' AS ENUM_760,
' ' AS ENUM_770,
' ' AS ENUM_780,
' ' AS ENUM_790,
' ' AS ENUM_800,
' ' AS ENUM_810,
' ' AS ENUM_820,
' ' AS ENUM_830,
' ' AS ENUM_840,
' ' AS ENUM_850,
' ' AS ENUM_860,
' ' AS ENUM_870,
' ' AS ENUM_880,
' ' AS ENUM_890,
' ' AS ENUM_900,
' ' AS ENUM_910,
' ' AS ENUM_920,
' ' AS ENUM_930,
' ' AS ENUM_940,
' ' AS ENUM_950,
' ' AS ENUM_960,
' ' AS ENUM_970,
' ' AS ENUM_980,
' ' AS ENUM_990,
' ' AS ENUM_1000,
' ' AS ENUM_1010,
' ' AS ENUM_1020,
' ' AS ENUM_1030,
' ' AS ENUM_1040,
' ' AS ENUM_1050,
' ' AS ENUM_1060
FROM
WELL
LEFT OUTER JOIN LKUP_GIS_STATUS LKUP_GIS_STATUS ON ( WELL.GIS_STATUS_ID = LKUP_GIS_STATUS.GIS_STATUS_ID)
LEFT OUTER JOIN LKUP_PRIMARY_FLUID LKUP_PRIMARY_FLUID ON ( WELL.primary_fluid_ID = LKUP_PRIMARY_FLUID.primary_fluid_ID )
LEFT OUTER JOIN LKUP_COUNTRY LKUP_COUNTRY ON ( WELL.country_ID = LKUP_COUNTRY.country_ID )
LEFT OUTER JOIN LKUP_PROVINCE_STATE LKUP_PROVINCE_STATE ON ( WELL.province_state_ID = LKUP_PROVINCE_STATE.province_state_ID )
LEFT OUTER JOIN LKUP_COUNTY LKUP_COUNTY ON ( WELL.county_ID = LKUP_COUNTY.county_ID )
LEFT OUTER JOIN LKUP_PROPERTY LKUP_PROPERTY ON ( WELL.property_ID = LKUP_PROPERTY.property_id)
LEFT OUTER JOIN LKUP_BASIN LKUP_BASIN ON ( WELL.basin_ID = LKUP_BASIN.basin_ID)
LEFT OUTER JOIN LKUP_FIELD LKUP_FIELD ON ( WELL.Field_ID = LKUP_FIELD.Field_ID)
LEFT OUTER JOIN LKUP_FORMATION LKUP_FORMATION ON ( WELL.Formation_ID = LKUP_FORMATION.Formation_ID)
LEFT OUTER JOIN LKUP_POOL LKUP_POOL ON ( WELL.Pool_ID = LKUP_POOL.Pool_ID)
LEFT OUTER JOIN LKUP_OPERATOR LKUP_OPERATOR1 ON ( WELL.Original_Operator_ID = LKUP_OPERATOR1.Operator_ID)
LEFT OUTER JOIN LKUP_OPERATOR LKUP_OPERATOR2 ON ( WELL.Operator_ID = LKUP_OPERATOR2.Operator_ID)
LEFT OUTER JOIN LKUP_BATTERY LKUP_BATTERY ON ( WELL.battery_ID = LKUP_BATTERY.Battery_ID)
LEFT OUTER JOIN LKUP_PLANT_CODE LKUP_PLANT_CODE ON ( WELL.Plant_Code_ID = LKUP_PLANT_CODE.Plant_Code_ID)
LEFT OUTER JOIN LKUP_PLANT_TYPE LKUP_PLANT_TYPE ON ( WELL.Plant_Type_ID = LKUP_PLANT_TYPE.Plant_Type_ID)
LEFT OUTER JOIN LKUP_LATERAL LKUP_LATERAL ON ( WELL.Lateral_ID = LKUP_LATERAL.Lateral_ID)
LEFT OUTER JOIN FACILITY FACILITY ON ( FACILITY.facility_ID = WELL.well_ID )
LEFT OUTER JOIN ANALYSIS_PROP ANALYSIS_PROP ON ( FACILITY.facility_ID = ANALYSIS_PROP.facility_ID)
LEFT OUTER JOIN RESERVOIR_DATA RESERVOIR_DATA ON ( RESERVOIR_DATA.analysis_prop_ID = ANALYSIS_PROP.analysis_prop_ID);
 

Leroy

2012 Troll of the Year
public var... that sounds dangerously like a web scripting language, you ain't a web scripter are ya boy?

[to the tune of ODB]
We gots some DBA's in the house(skd_mrk, me)
We gots some network admins in the house (narf)
Boogie down coders in the house (you, shotgun)
Web devs up in the house (35, vinny)
Tech support are ya in the house?
IT are in the house?
 

dead mike

TD Member, Legend, Puncher of Faces, Chatbox King
[quote1282930106=cock]
18037334

I dunno what the fuck that is.
[/quote1282930106]
18 million bucks man
 
Top