Store Procedure Help - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2008 Forums

Transact-SQL (2008)

Store Procedure Help

Author

Topic

jscot
Posting Yak Master

106 Posts

Posted - 2010-10-09 : 19:16:14

Guys I need help.

I want to create a Store Procedure that will convert data from the excel spreadsheets/ mapping and imported into SQL tables. I have documentation of the project. Urgent help man. I can provide documentation through via email. Thanks in advance SQL GURUSSSSS.

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2010-10-09 : 19:23:35

Whatever documentation you have will need to be provided here and not through email.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

jscot
Posting Yak Master

106 Posts

Posted - 2010-10-09 : 20:36:49

Tara, From a security reason i can't publish my office documentation online. I will send other information and scenario. i can send you through Private message?

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2010-10-09 : 23:35:19

No. Just scrub the data for us and provide that. We do not require your actual data.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

jscot
Posting Yak Master

106 Posts

Posted - 2010-10-10 : 01:26:56

1.1.1 DATA MAPPING
SOURCE: FEATURE = F
FEATURE1 = F1
FEATURE2 = F2
FEATURE3 = F3 OWNER
COLUMN DATA TYPE FIELD NAME DATA TYPE NOTES
F2.LOCATIONTYPE CHAR(50) GTYPE VARCHAR(30) See Note c)
F.IMPR_FCV CURRENCY IVALUE FLOAT
F .LAND_FCV CURRENCY LVALUE FLOAT
F .PARCEL_SIZE
F .LAND_INDICATOR NUMBER
CHAR(2) LOT_SIZE FLOAT See Note b)
M_ADDRESS INTEGER Default = 0
F .ADDRESS CHAR(40) O_ADDR1 VARCHAR(30)
F .ADDRESS CHAR(40) O_ADDR2 VARCHAR(30)
F .CITY CHAR(40) O_CITY VARCHAR(24)
F1 .OWNER_NAME1 CHAR(40) O_NAME VARCHAR(30)
F.STATE CHAR(2) O_STATE VARCHAR(2)
F .ZIP_CODE CHAR(10) O_ZIP VARCHAR(10)
F .SECTION
F .TOWNSHIP
F .RANGE CHAR(4)
CHAR(3)
CHAR(3) S_TWP_RNG VARCHAR(20)
F2.LOCATION CHAR(250) S_ADDR VARCHAR(70)
F1.APN
F2.GID CHAR(15)
NUMBER S_APN VARCHAR(20)
F2.JURISDICTION CHAR(255) S_CITY VARCHAR(30)
F3.NOTES CHAR(68) S_DESCRIPTION VARCHAR(2000) See Note d)
F2.SNO NUMBER S_NUMBER VARCHAR(10)
S_STATE VARCHAR(2) Default = ‘AZ’
F2.STREET_NAME CHAR(255) S_STREETNAME VARCHAR(60)
F1.REFERENCE CHAR(200) S_SUBDIVISION VARCHAR(100)
F2.UNIT_NO CHAR(50) S_UNIT_NO VARCHAR(10)
F2.ZIP_CODE CHAR(10) S_ZIP VARCHAR(10)
STATUS VARCHAR(20) See Note a)
F1.ZONING CHAR(50) Z_CODE1 VARCHAR(40)

DATA MAPPING NOTES
a)
LAND_LEGAL_CLASS LANDLGLCLASS
0101 PRODUCING MINES
0102 STANDING TIMBER
0103 CVP
0104 AIRPORT FUEL DELIVERY
0105 PRODUCING OIL & GAS
0106 WATER UTILITY COMPANIES
0107 PIPELINES
0108 SHOPPING CENTERS
0109 GOLF COURSES
0110 COMMERCIAL / MANUFACTURERS
0111 TELECOMMUNICATIONS
0112 COMMERCIAL
0113 COMMERCIAL PERSONAL PROPERTY
02P AG / PERSONAL PROPERTY
02PD GOLF COURSES / REAL AND PERSONAL PROPERTY NOT IN 0109 – EXEMPTION
02R VACANT LAND
02RD GOLF COURSES / REAL AND PERSONAL PROPERTY NOT IN 0109
03 RESIDENTIAL
04 RENTAL RESIDENTIAL
0407 RESIDENTIAL COMMON AREAS VALUED PURSUANT TO ARS 42-13353
05F RAILROADS FCV
05L RAILROADS LPV
0601 NON-COMMERCIAL HISTORICAL
0602 FOREIGN TRADE ZONES
0603 MILITARY REUSE ZONES
0604 ENTERPRISE ZONES FCV / LPV
0605 ENVIRONMENTAL TECHNOLOGY
0606 ENVIRONMENTAL REMEDIATION
07B COMMERCIAL HISTORICAL BASE VALUE
07H COMMERCIAL HISTORICAL RENOVATION VALUE
08B RESIDENTIAL / COMMERCIAL HISTORICAL BASE VALUE
08H RESIDENTIAL / COMMERCIAL HISTORICAL RENOVATION VALUE
09 CERTAIN IMPROVEMENTS ON GOVT PROPERTY
M MIXED LEGAL CLASSES

b)
PROPERTY_STATUS_CODE SRC DESCRIP
A1 PHYSICALLY UNCHANGED - VACANT LAND
A2 PHYSICALLY UNCHANGED - IMPROVED LAND
A3 PREVIOUS PARTIAL ESCAPE - NO BOARD APPROVAL
B1 NEW PROPERTY - VACANT LAND
B2 NEW PROPERTY - IMPROVED LAND
B3 COMPLETED NEW IMPROVEMENT(S)
B4 REMOVED, DESTROYED OR DAMAGED IMPROVEMENT(S)
B5 PARTIAL COMPLETION(S)
B6 COMPLETED PREVIOUS IMPROVEMENT(S)
B7 REPLACED IMPROVEMENT(S)
B8 PHYSICAL CHANGE TO EXISTING IMPROVEMENT(S)
B9 PREVIOUS PARTIAL ESCAPE - BOARD APPROVAL OBTAINED

c) The first 2 characters from USE_CODE will be used for the translation

USE_CODE (PREFIX) GEO_UDF.USECODE
00 VACANT LAND
01 SINGLE FAMILY RESIDENCES,5 AC OR LESS
02, 90, 91 ** INVALID USE CODE **
03 MULTIPLE RESIDENTIAL
04 HOTELS
05 MOTELS
06 RESORTS
07 CONDOMINIUMS & TOWNHOUSES
08 MOBILE HOME, 5 AC OR LESS
0890 MOBILE HOME, TRAVEL TRAILER
09 SALVAGE
10 MISC COMM,CONVERTED RESIDENCE,LAUNDRY
11 STORE BLDGS & SMALL GROCER
12 STORE COMBINED WITH
13 DEPARTMENT STORES
14 SHOPPING CENTERS
15 OFFICE BUILDINGS
16 FINANCIAL INSTITUTIONS
17 SERV STA,TRUCK STP,AUTO/TRUCK REPAIR
18 AUTOMOTIVE SALES,LEASE,STORAGE,PARTS
19 NURSING CARE FACILITIES
20 RESTAURANT & BAR
21 HOSPITALS & MEDICAL BUILDINGS
22 RACE TRACKS & PRIVATE AIR FIELDS
23 CEMETERIES & MORTUARIES
24 GOLF COURSES
25 THEATERS & OTHER AMUSEMENT FACILITIES
26 PARKING FACILITIES
27 CLUBS, LODGES, RECREATION CENTERS
29 PRIVATE SCHOOLS & DAY CARE CENTERS
30 INDUSTRIAL PROPERTIES
37 INDUSTRIAL WAREHOUSE
40 PLANT NURSERIES AND GREENHOUSES
41 FIELD CROPS
42 VINEYARDS
43 TREE CROPS
45 HIGH DENSITY AGRICULTURAL
46 JOJOBA
47 RANCH PROPERTY
48 PASTURE LAND
87 RESIDENTIAL IMPROVED, MORE THAN 5 AC
88 LIMITED USE-WELL SITES,PVT ROADS,ETC.
92 RELIGIOUS PROPERTIES
94 FEDERAL LANDS
95 STATE LANDS
96 COUNTY LANDS
97 MUNICIPAL LANDS
99 SPECIAL DISTRICTS, EXEMPT

Here is the data. Thanks in advance.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources