Widest table
-
A table personally designed by a certain business end user who wants it HIS WAY has reached 478 columns in width. Performance is hideous; Informatica takes 8 hours daily to normalize it into an 8 column table for reporting. It grows weekly; We can't wait to see what happens when it hits SQL Server's 1024 column limit.
There must be more out there; can anyone top 470 useless columns so I don't feel like I've got the worst to deal with?
-
I heard of a case once where every year "Mr. Database" would add 13 columns to the table, to account for the next twelve months + summary. That was, oh, maybe 12 years ago, so I guess he'd still be under 200 columns, but if you stretch the pain over a decade...?
Philip
-
Sorry man, can't go over 200 either (not all that useless either). I just can't imagine having 1024 columns in a table.
-
We had over 300. The brain who created it then ran out of space. That didn't stop him. He just created original_table_extended. Now it has about 100 columns in it.
He's gone now. I'm the dictator now, so there won't be fields being added to that table anymore. I can't wait until we can normalize the stupid thing.
Derrick Leggett
Mean Old DBA
When life gives you a lemon, fire the DBA. -
Can someone post the ddl of one of those tables?? would like to laminate it or something
. -
I currently have a table with 224 columns. It is a copy of an old mainframe customer file. Performance is not an issue. But that's becuase most of the columns are 1 char.
Hardest part was typing up the Create statement with all those names.
Here is the format file used to load it.
6.0
224
1 SQLCHAR 0 8 "" 1 Customer_Number
2 SQLCHAR 0 25 "" 2 Customer_Name
3 SQLCHAR 0 25 "" 3 Customer_Address_1
4 SQLCHAR 0 25 "" 4 Customer_Address_2
5 SQLCHAR 0 25 "" 5 Customer_Address_3
6 SQLCHAR 0 2 "" 6 Customer_State
7 SQLCHAR 0 6 "" 7 Customer_Zip_Code
8 SQLCHAR 0 1 "" 8 GCA_Flag
9 SQLCHAR 0 1 "" 9 GAA_Flag
10 SQLCHAR 0 1 "" 10 GXA_Flag
11 SQLCHAR 0 1 "" 11 Customer_Type
12 SQLCHAR 0 1 "" 12 Bill_To_Flag
13 SQLCHAR 0 1 "" 13 New_Release_Days
14 SQLCHAR 0 1 "" 14 Fill_Kill_Code
15 SQLCHAR 0 1 "" 15 UPS_Zone
16 SQLCHAR 0 1 "" 16 Invoice_Required
17 SQLCHAR 0 1 "" 17 PO_Required
18 SQLCHAR 0 1 "" 18 Deleted_Flag
19 SQLCHAR 0 10 "" 19 Geo_Alpha_Code
20 SQLCHAR 0 1 "" 20 Multiple_Flag
21 SQLCHAR 0 1 "" 21 Freight_Flag
22 SQLCHAR 0 1 "" 22 Print_Day_1
23 SQLCHAR 0 1 "" 23 Print_Day_2
24 SQLCHAR 0 1 "" 24 Print_Day_3
25 SQLCHAR 0 1 "" 25 Print_Day_4
26 SQLCHAR 0 1 "" 26 Print_Day_5
27 SQLCHAR 0 1 "" 27 Combine_Flag
28 SQLCHAR 0 1 "" 28 Orders_Flag
29 SQLCHAR 0 6 "" 29 Bill_To_Customer
30 SQLCHAR 0 1 "" 30 Key_Customer
31 SQLCHAR 0 1 "" 31 Partenship_Flag
32 SQLCHAR 0 1 "" 32 Cycle_Catalog
33 SQLCHAR 0 1 "" 33 Cycle_Hits
34 SQLCHAR 0 1 "" 34 Cycle_New_Release
35 SQLCHAR 0 1 "" 35 Order_Ship_Flag
36 SQLCHAR 0 1 "" 36 Priority
37 SQLCHAR 0 1 "" 37 Routing_Flag
38 SQLCHAR 0 3 "" 38 Cancel_Days
39 SQLCHAR 0 1 "" 39 UPC_Flag
40 SQLCHAR 0 1 "" 40 Voucher_Price_Flag
41 SQLCHAR 0 1 "" 41 Box_Lot_Flag
42 SQLCHAR 0 1 "" 42 Status_Code
43 SQLCHAR 0 1 "" 43 Promo_Zone
44 SQLCHAR 0 6 "" 44 Extra_Dating
45 SQLCHAR 0 1 "" 45 Rack_Job_Flag
46 SQLCHAR 0 1 "" 46 Box_Only_Flag
47 SQLCHAR 0 1 "" 47 Returns_Flag
48 SQLCHAR 0 2 "" 48 Price_Code
49 SQLCHAR 0 2 "" 49 Warehouse_Code
50 SQLCHAR 0 4 "" 50 Salesman_Number
51 SQLCHAR 0 4 "" 51 Sales_Program
52 SQLCHAR 0 3 "" 52 Special_Inst
53 SQLCHAR 0 5 "" 53 Hybrid_Percent
54 SQLCHAR 0 1 "" 54 Incentive_Flag
55 SQLCHAR 0 1 "" 55 Disincentive_Flag
56 SQLCHAR 0 1 "" 56 Sls_Prog_Override
57 SQLCHAR 0 1 "" 57 Invoice_PO_Flag
58 SQLCHAR 0 1 "" 58 Extra_Months
59 SQLCHAR 0 1 "" 59 Bol_Required_Flag
60 SQLCHAR 0 1 "" 60 Order_Accept_Flag
61 SQLCHAR 0 3 "" 61 Total_Hybrid_1
62 SQLCHAR 0 3 "" 62 Total_Hybrid_2
63 SQLCHAR 0 3 "" 63 Total_Hybrid_3
64 SQLCHAR 0 3 "" 64 Total_Hybrid_4
65 SQLCHAR 0 5 "" 65 Hybrid_Percent_2
66 SQLCHAR 0 2 "" 66 Program_Class
67 SQLCHAR 0 2 "" 67 Sales_Channel
68 SQLCHAR 0 3 "" 68 Credit_Manager
69 SQLCHAR 0 1 "" 69 Corpse_FLag
70 SQLCHAR 0 3 "" 70 Corpse_Program
71 SQLCHAR 0 2 "" 71 Account_Class
72 SQLCHAR 0 3 "" 72 Activity_Code
73 SQLCHAR 0 1 "" 73 Parcel_Post_Zone
74 SQLCHAR 0 3 "" 74 Division_Tax_Code
75 SQLCHAR 0 1 "" 75 Exemption_Code
76 SQLCHAR 0 17 "" 76 Account_Number
77 SQLCHAR 0 1 "" 77 Resale_Certificate
78 SQLCHAR 0 1 "" 78 Adv_Participant
79 SQLCHAR 0 1 "" 79 Affidavit
80 SQLCHAR 0 4 "" 80 Tax_Date
81 SQLCHAR 0 5 "" 81 Return_Allowance
82 SQLCHAR 0 6 "" 82 Clone_Number
83 SQLCHAR 0 1 "" 83 Export_Type
84 SQLCHAR 0 5 "" 84 CARMS_Business_Code
85 SQLCHAR 0 6 "" 85 CARMS_ID_Number
86 SQLCHAR 0 1 "" 86 Statement_Flag
87 SQLCHAR 0 15 "" 87 Resale_Cert_Number
88 SQLCHAR 0 3 "" 88 Foreign_Country
89 SQLCHAR 0 1 "" 89 Parent_Child_Flag
90 SQLCHAR 0 5 "" 90 Parent_Business_Code
91 SQLCHAR 0 2 "" 91 Terms_Code
92 SQLCHAR 0 5 "" 92 GL_Prefix
93 SQLCHAR 0 3 "" 93 GL_Suffix
94 SQLCHAR 0 5 "" 94 Hybrid_Percent
95 SQLCHAR 0 2 "" 95 GL_Ledger
96 SQLCHAR 0 10 "" 96 Phone_Number
97 SQLCHAR 0 14 "" 97 Narm_Number
98 SQLCHAR 0 1 "" 98 Dist_Method
99 SQLCHAR 0 6 "" 99 ASI_Number
100 SQLCHAR 0 4 "" 100 BAG_Number
101 SQLCHAR 0 1 "" 101 Terms_Exception_Code_Video
102 SQLCHAR 0 1 "" 102 Terms_Exception_Code_Audio
103 SQLCHAR 0 1 "" 103 Profile_Flag_1
104 SQLCHAR 0 1 "" 104 Profile_Flag_2
105 SQLCHAR 0 1 "" 105 Profile_Flag_3
106 SQLCHAR 0 1 "" 106 Profile_Flag_4
107 SQLCHAR 0 1 "" 107 Profile_Flag_5
108 SQLCHAR 0 1 "" 108 Profile_Flag_6
109 SQLCHAR 0 1 "" 109 Profile_Flag_7
110 SQLCHAR 0 1 "" 110 Profile_Flag_8
111 SQLCHAR 0 1 "" 111 Profile_Flag_9
112 SQLCHAR 0 1 "" 112 Profile_Flag_10
113 SQLCHAR 0 1 "" 113 Profile_Flag_11
114 SQLCHAR 0 1 "" 114 Profile_Flag_12
115 SQLCHAR 0 1 "" 115 Profile_Flag_13
116 SQLCHAR 0 1 "" 116 Profile_Flag_14
117 SQLCHAR 0 1 "" 117 Profile_Flag_15
118 SQLCHAR 0 1 "" 118 Profile_Flag_16
119 SQLCHAR 0 1 "" 119 Profile_Flag_17
120 SQLCHAR 0 1 "" 120 Profile_Flag_18
121 SQLCHAR 0 1 "" 121 Profile_Flag_19
122 SQLCHAR 0 1 "" 122 Profile_Flag_20
123 SQLCHAR 0 1 "" 123 Profile_Flag_21
124 SQLCHAR 0 1 "" 124 Profile_Flag_22
125 SQLCHAR 0 1 "" 125 Profile_Flag_23
126 SQLCHAR 0 1 "" 126 Profile_Flag_24
127 SQLCHAR 0 1 "" 127 Profile_Flag_25
128 SQLCHAR 0 1 "" 128 Profile_Flag_26
129 SQLCHAR 0 1 "" 129 Profile_Flag_27
130 SQLCHAR 0 1 "" 130 Profile_Flag_28
131 SQLCHAR 0 1 "" 131 Profile_Flag_29
132 SQLCHAR 0 1 "" 132 Profile_Flag_30
133 SQLCHAR 0 1 "" 133 Profile_Flag_31
134 SQLCHAR 0 1 "" 134 Profile_Flag_32
135 SQLCHAR 0 1 "" 135 Profile_Flag_33
136 SQLCHAR 0 1 "" 136 Profile_Flag_34
137 SQLCHAR 0 1 "" 137 Profile_Flag_35
138 SQLCHAR 0 1 "" 138 Profile_Flag_36
139 SQLCHAR 0 1 "" 139 Profile_Flag_37
140 SQLCHAR 0 1 "" 140 Profile_Flag_38
141 SQLCHAR 0 1 "" 141 Profile_Flag_39
142 SQLCHAR 0 1 "" 142 Profile_Flag_40
143 SQLCHAR 0 1 "" 143 Long_Box_Flag
144 SQLCHAR 0 1 "" 144 Cust_Prop_Flag
145 SQLCHAR 0 1 "" 145 Print_Bo_Flag
146 SQLCHAR 0 3 "" 146 Min_Print_Units
147 SQLCHAR 0 3 "" 147 Min_Print_Dollars
148 SQLCHAR 0 2 "" 148 Video_Days
149 SQLCHAR 0 2 "" 149 Audio_Days
150 SQLCHAR 0 2 "" 150 Interactive_Days
151 SQLCHAR 0 1 "" 151 ASN_Flag
152 SQLCHAR 0 3 "" 152 Minimum_Order
153 SQLCHAR 0 5 "" 153 Audio_Pecent_1
154 SQLCHAR 0 5 "" 154 Audio_Pecent_2
155 SQLCHAR 0 5 "" 155 Video_Pecent_1
156 SQLCHAR 0 5 "" 156 Video_Pecent_2
157 SQLCHAR 0 5 "" 157 Inter_Pecent_1
158 SQLCHAR 0 5 "" 158 Inter_Pecent_2
159 SQLCHAR 0 2 "" 159 Video_Rental_Days
160 SQLCHAR 0 1 "" 160 CP_Address_Flag
161 SQLCHAR 0 1 "" 161 CP_Routing_Flag
162 SQLCHAR 0 1 "" 162 Print_Unit_Flag
163 SQLCHAR 0 1 "" 163 CP_Freight_Flag
164 SQLCHAR 0 2 "" 164 Med_0_NR_Days
165 SQLCHAR 0 2 "" 165 Med_1_NR_Days
166 SQLCHAR 0 2 "" 166 Med_2_NR_Days
167 SQLCHAR 0 2 "" 167 Med_3_NR_Days
168 SQLCHAR 0 2 "" 168 Med_4_NR_Days
169 SQLCHAR 0 2 "" 169 Med_5_NR_Days
170 SQLCHAR 0 2 "" 170 Med_6_NR_Days
171 SQLCHAR 0 2 "" 171 Med_7_NR_Days
172 SQLCHAR 0 2 "" 172 Med_8_NR_Days
173 SQLCHAR 0 2 "" 173 Med_9_NR_Days
174 SQLCHAR 0 2 "" 174 Med_A_NR_Days
175 SQLCHAR 0 2 "" 175 Med_B_NR_Days
176 SQLCHAR 0 2 "" 176 Med_C_NR_Days
177 SQLCHAR 0 2 "" 177 Med_D_NR_Days
178 SQLCHAR 0 2 "" 178 Med_E_NR_Days
179 SQLCHAR 0 2 "" 179 Med_F_NR_Days
180 SQLCHAR 0 2 "" 180 Med_G_NR_Days
181 SQLCHAR 0 2 "" 181 Med_H_NR_Days
182 SQLCHAR 0 2 "" 182 Med_I_NR_Days
183 SQLCHAR 0 2 "" 183 Med_Z_NR_Days
184 SQLCHAR 0 2 "" 184 Med_K_NR_Days
185 SQLCHAR 0 2 "" 185 Med_L_NR_Days
186 SQLCHAR 0 2 "" 186 Med_M_NR_Days
187 SQLCHAR 0 2 "" 187 Med_N_NR_Days
188 SQLCHAR 0 2 "" 188 Med_O_NR_Days
189 SQLCHAR 0 2 "" 189 Med_P_NR_Days
190 SQLCHAR 0 2 "" 190 Med_Q_NR_Days
191 SQLCHAR 0 2 "" 191 Med_R_NR_Days
192 SQLCHAR 0 2 "" 192 Med_S_NR_Days
193 SQLCHAR 0 2 "" 193 Med_T_NR_Days
194 SQLCHAR 0 2 "" 194 Med_U_NR_Days
195 SQLCHAR 0 2 "" 195 Med_V_NR_Days
196 SQLCHAR 0 2 "" 196 Med_W_NR_Days
197 SQLCHAR 0 2 "" 197 Med_X_NR_Days
198 SQLCHAR 0 2 "" 198 Med_Y_NR_Days
199 SQLCHAR 0 2 "" 199 Med_Z_NR_Days
200 SQLCHAR 0 1 "" 200 Price_Sticker
201 SQLCHAR 0 1 "" 201 PO_ACK_Flag
202 SQLCHAR 0 1 "" 202 Split_Flag
203 SQLCHAR 0 1 "" 203 JIT_Flag
204 SQLCHAR 0 4 "" 204 Hold_Code
205 SQLCHAR 0 15 "" 205 User_Code
206 SQLCHAR 0 1 "" 206 Non_Dorner-Flag
207 SQLCHAR 0 1 "" 207 Wait_For_Combine
208 SQLCHAR 0 1 "" 208 Dorner_Loose_Only
209 SQLCHAR 0 2 "" 209 Shipto_Country_Code
210 SQLCHAR 0 10 "" 210 Shipto_SAP_Zip_Code
211 SQLCHAR 0 25 "" 211 Billto_Name
212 SQLCHAR 0 25 "" 212 Billto_Address1
213 SQLCHAR 0 25 "" 213 Billto_Address2
214 SQLCHAR 0 25 "" 214 Billto_Address3
215 SQLCHAR 0 25 "" 215 Billto_Address4
216 SQLCHAR 0 6 "" 216 Billto_Zip_Code
217 SQLCHAR 0 10 "" 217 Billto_Foreign_Zip
218 SQLCHAR 0 2 "" 218 Billto_Country_Code
219 SQLCHAR 0 1 "" 219 Rework_Flag
220 SQLCHAR 0 1 "" 220 Ltl_Flag
221 SQLCHAR 0 1 "" 221 Convert_Selection_Flag
222 SQLCHAR 0 1 "" 222 Reworl_Hold_Flag
223 SQLCHAR 0 4 "" 223 Treatment_Code
224 SQLCHAR 0 1 "\r\n" 224 Checkpoint_Flag
-
You could just have copied the sql script that em generates
-
NULLs are yummy:
CREATE TABLE dbo.marketing
(
AccountManager varchar(30) NULL,
AccountNumber varchar(12) NULL,
CompanyAddress varchar(200) NULL,
CompanyAddress2 varchar(200) NULL,
CompanyAddress3 varchar(200) NULL,
CompanyAddress4 varchar(200) NULL,
CompanyCity varchar(200) NULL,
CompanyCountry varchar(200) NULL,
CompanyFax varchar(25) NULL,
CompanyId varchar(32) NULL,
CompanyName varchar(255) NULL,
CompanyPhone varchar(25) NULL,
CompanyPhoneExt varchar(15) NULL,
CompanyState varchar(3) NULL,
CompanySymbol varchar(10) NULL,
CompanyURL varchar(50) NULL,
CompanyZip varchar(15) NULL,
DispositionCategory varchar(20) NULL,
DispositionCode varchar(50) NULL,
Hist1 text NULL,
Hist2 text NULL,
Hist3 text NULL,
Hist4 text NULL,
Hist5 text NULL,
DispositionDate smalldatetime NULL,
IHSSource varchar(50) NULL,
LeadClassification varchar(10) NULL,
LeadDate smalldatetime NULL,
NoPeople varchar(10) NULL,
OrgType varchar(50) NULL,
PrimaryContactDept varchar(100) NULL,
PrimaryContactEmail varchar(100) NULL,
PrimaryContactFirstName varchar(25) NULL,
PrimaryContactLastName varchar(25) NULL,
PrimaryContactTitle varchar(100) NULL,
PrimaryContactType varchar(100) NULL,
ProductInterest varchar(255) NULL,
ProspectId varchar(50) NULL,
RenewalDate smalldatetime NULL,
SalesDate smalldatetime NULL,
SalesVolume money NULL,
SecPhoneType varchar(25) NULL,
SecondaryPhone varchar(25) NULL,
Status varchar(25) NULL,
Team varchar(50) NULL,
TechnologyArea varchar(50) NULL,
WebSiteRef varchar(100) NULL,
Modified smalldatetime NULL,
LeadCSM varchar(30) NULL,
VerticalMarket varchar(50) NULL,
ExistingCustomer bit NULL,
MultiSite bit NULL,
MediaType varchar(50) NULL,
AccountManager2 varchar(30) NULL,
AccountManager3 varchar(30) NULL,
AccountManager4 varchar(30) NULL,
AccountManager5 varchar(30) NULL,
AccountManager6 varchar(30) NULL,
NewComment text NULL,
LastNote text NULL,
CVPProgram bit NULL,
CVPOrderDate smalldatetime NULL,
ContactFrequency varchar(50) NULL,
LastMeetingDate smalldatetime NULL,
NextMeetingDate smalldatetime NULL,
LastTrainingDate smalldatetime NULL,
NextTrainingDate smalldatetime NULL,
IHSCampaign varchar(100) NULL,
DunsNumber varchar(9) NULL,
DunsNumberAddDate smalldatetime NULL,
HQDunsNo varchar(9) NULL,
DULtdDunsNo varchar(9) NULL,
GULtdDunsNo varchar(9) NULL,
MustKeepGetBack varchar(9) NULL,
event1aTargetMarket bit NULL,
event1bMailingInfo bit NULL,
event1cTargetConflicts bit NULL,
event1dSuitableContacts bit NULL,
event2aInitialComm bit NULL,
event2bContactIsDecisionMaker bit NULL,
event2cCriteriaSatisfied bit NULL,
event2dFollowupSent bit NULL,
event2eContactEngaged bit NULL,
event3aRolesDefined bit NULL,
event3bAppointmentSet bit NULL,
event3cInPersonAppointment bit NULL,
event3dNeedsAnanlysisComplete bit NULL,
event3eProofOfConcept bit NULL,
event3fProposalDevelopment bit NULL,
event4aProposalPresented bit NULL,
event4bProposalDefended bit NULL,
event4cSolutionAgreed bit NULL,
event4dPurchaseOrder bit NULL,
eventCloseDate smalldatetime NULL,
eventCloseAmount money NULL,
eventConfidence varchar(5) NULL,
event1aDTTargetMarket smalldatetime NULL,
event1bDTMailingInfo smalldatetime NULL,
event1cDTTargetConflicts smalldatetime NULL,
event1dDTSuitableContacts smalldatetime NULL,
event2aDTInitialComm smalldatetime NULL,
event2bDTContactIsDecisionMaker smalldatetime NULL,
event2cDTCriteriaSatisfied smalldatetime NULL,
event2dDTFollowupSent smalldatetime NULL,
event2eDTContactEngaged smalldatetime NULL,
event3aDTRolesDefined smalldatetime NULL,
event3bDTAppointmentSet smalldatetime NULL,
event3cDTInPersonAppointment smalldatetime NULL,
event3dDTNeedsAnalysisComplete smalldatetime NULL,
event3eDTProofOfConcept smalldatetime NULL,
event4aDTProposalDevelopment smalldatetime NULL,
event4bDTProposalPresented smalldatetime NULL,
event4cDTProposalDefended smalldatetime NULL,
event4dDTSolutionAgreed smalldatetime NULL,
eventDTPurchaseOrder smalldatetime NULL,
eventDTCloseAmount varchar(20) NULL,
eventDTConfidence varchar(20) NULL,
eventDTProductInterest varchar(20) NULL,
ForecastComments text NULL,
CloseDateComments text NULL,
ConfidenceComments text NULL,
ProductInterestComments text NULL,
Stage varchar(15) NULL,
eventsQ1a bit NULL,
eventsQ1b bit NULL,
eventsQ1c bit NULL,
eventsQ2a bit NULL,
eventsQ2b bit NULL,
eventsQ2c bit NULL,
eventsQ2d bit NULL,
eventsQ2e bit NULL,
eventsQ3a bit NULL,
eventsQ3b bit NULL,
eventsQ3c bit NULL,
eventsQ3d bit NULL,
eventsQ3e bit NULL,
eventsQ3f bit NULL,
eventsQ4a bit NULL,
eventsQ4b bit NULL,
eventsQ4c bit NULL,
eventsQ4d bit NULL,
eventsQ4e bit NULL,
eventsDTQ1a smalldatetime NULL,
eventsDTQ1b smalldatetime NULL,
eventsDTQ1c smalldatetime NULL,
eventsDTQ2a smalldatetime NULL,
eventsDTQ2b smalldatetime NULL,
eventsDTQ2c smalldatetime NULL,
eventsDTQ2d smalldatetime NULL,
eventsDTQ2e smalldatetime NULL,
eventsDTQ3a smalldatetime NULL,
eventsDTQ3b smalldatetime NULL,
eventsDTQ3c smalldatetime NULL,
eventsDTQ3d smalldatetime NULL,
eventsDTQ3e smalldatetime NULL,
eventsDTQ3f smalldatetime NULL,
eventsDTQ4a smalldatetime NULL,
eventsDTQ4b smalldatetime NULL,
eventsDTQ4c smalldatetime NULL,
eventsDTQ4d smalldatetime NULL,
eventsDTQ4e smalldatetime NULL,
ForecastChangeDate smalldatetime NULL,
OpportunityType varchar(25) NULL,
ParentUNID varchar(32) NULL,
UltimateParentID varchar(32) NULL,
RenewalCloseDate smalldatetime NULL,
RnCon int NULL,
RenewalTotal money NULL,
ForecastTotal money NULL,
Prodline1 varchar(25) NULL,
Prodline2 varchar(25) NULL,
Prodline3 varchar(25) NULL,
Prodline4 varchar(25) NULL,
Prodline5 varchar(25) NULL,
Prodline6 varchar(25) NULL,
Prodline7 varchar(25) NULL,
Prodline8 varchar(25) NULL,
Prodline9 varchar(25) NULL,
Prodline10 varchar(25) NULL,
Prodline11 varchar(25) NULL,
Prodline12 varchar(25) NULL,
Prodline13 varchar(25) NULL,
Prodline14 varchar(25) NULL,
Prodline15 varchar(25) NULL,
Prodline16 varchar(25) NULL,
Prodline17 varchar(25) NULL,
Prodline18 varchar(25) NULL,
Prodline19 varchar(25) NULL,
Prodline20 varchar(25) NULL,
Prodline21 varchar(25) NULL,
Prodline22 varchar(25) NULL,
Prodline23 varchar(25) NULL,
Prodline24 varchar(25) NULL,
Prodline25 varchar(25) NULL,
Prodline26 varchar(25) NULL,
Prodline27 varchar(25) NULL,
Prodline28 varchar(25) NULL,
Prodline29 varchar(25) NULL,
Prodline30 varchar(25) NULL,
Prodline31 varchar(25) NULL,
Prodline32 varchar(25) NULL,
Prodline33 varchar(25) NULL,
Prodline34 varchar(25) NULL,
Prodline35 varchar(25) NULL,
Prodline36 varchar(25) NULL,
Prodline37 varchar(25) NULL,
Prodline38 varchar(25) NULL,
Prodline39 varchar(25) NULL,
Prodline40 varchar(25) NULL,
Prodline41 varchar(25) NULL,
RenewalAmount1 money NULL,
RenewalAmount2 money NULL,
RenewalAmount3 money NULL,
RenewalAmount4 money NULL,
RenewalAmount5 money NULL,
RenewalAmount6 money NULL,
RenewalAmount7 money NULL,
RenewalAmount8 money NULL,
RenewalAmount9 money NULL,
RenewalAmount10 money NULL,
RenewalAmount11 money NULL,
RenewalAmount12 money NULL,
RenewalAmount13 money NULL,
RenewalAmount14 money NULL,
RenewalAmount15 money NULL,
RenewalAmount16 money NULL,
RenewalAmount17 money NULL,
RenewalAmount18 money NULL,
RenewalAmount19 money NULL,
RenewalAmount20 money NULL,
RenewalAmount21 money NULL,
RenewalAmount22 money NULL,
RenewalAmount23 money NULL,
RenewalAmount24 money NULL,
RenewalAmount25 money NULL,
RenewalAmount26 money NULL,
RenewalAmount27 money NULL,
RenewalAmount28 money NULL,
RenewalAmount29 money NULL,
RenewalAmount30 money NULL,
RenewalAmount31 money NULL,
RenewalAmount32 money NULL,
RenewalAmount33 money NULL,
RenewalAmount34 money NULL,
RenewalAmount35 money NULL,
RenewalAmount36 money NULL,
RenewalAmount37 money NULL,
RenewalAmount38 money NULL,
RenewalAmount39 money NULL,
RenewalAmount40 money NULL,
RenewalAmount41 money NULL,
RenewalForecast1 money NULL,
RenewalForecast2 money NULL,
RenewalForecast3 money NULL,
RenewalForecast4 money NULL,
RenewalForecast5 money NULL,
RenewalForecast6 money NULL,
RenewalForecast7 money NULL,
RenewalForecast8 money NULL,
RenewalForecast9 money NULL,
RenewalForecast10 money NULL,
RenewalForecast11 money NULL,
RenewalForecast12 money NULL,
RenewalForecast13 money NULL,
RenewalForecast14 money NULL,
RenewalForecast15 money NULL,
RenewalForecast16 money NULL,
RenewalForecast17 money NULL,
RenewalForecast18 money NULL,
RenewalForecast19 money NULL,
RenewalForecast20 money NULL,
RenewalForecast21 money NULL,
RenewalForecast22 money NULL,
RenewalForecast23 money NULL,
RenewalForecast24 money NULL,
RenewalForecast25 money NULL,
RenewalForecast26 money NULL,
RenewalForecast27 money NULL,
RenewalForecast28 money NULL,
RenewalForecast29 money NULL,
RenewalForecast30 money NULL,
RenewalForecast31 money NULL,
RenewalForecast32 money NULL,
RenewalForecast33 money NULL,
RenewalForecast34 money NULL,
RenewalForecast35 money NULL,
RenewalForecast36 money NULL,
RenewalForecast37 money NULL,
RenewalForecast38 money NULL,
RenewalForecast39 money NULL,
RenewalForecast40 money NULL,
RenewalForecast41 money NULL,
ShortTerm bit NULL,
ShortTermMonths varchar(5) NULL,
IHSSource2 varchar(50) NULL,
IHSSource3 varchar(50) NULL,
IHSSourceDate smalldatetime NULL,
IHSSourceDate2 smalldatetime NULL,
IHSSourceDate3 smalldatetime NULL,
OpportunityId char(11) NULL,
BasePrice money NULL,
event3fDTProposalDevelopment smalldatetime NULL,
makeparent nvarchar(15) NULL,
WANAccountNumber nvarchar(15) NULL,
Prodline42 varchar(25) NULL,
Prodline43 varchar(25) NULL,
Prodline44 varchar(25) NULL,
Prodline45 varchar(25) NULL,
Prodline100 varchar(25) NULL,
Prodline101 varchar(25) NULL,
Prodline102 varchar(25) NULL,
Prodline103 varchar(25) NULL,
Prodline104 varchar(25) NULL,
Prodline105 varchar(25) NULL,
Prodline106 varchar(25) NULL,
Prodline107 varchar(25) NULL,
Prodline108 varchar(25) NULL,
Prodline109 varchar(25) NULL,
Prodline110 varchar(25) NULL,
Prodline111 varchar(25) NULL,
Prodline112 varchar(25) NULL,
Prodline113 varchar(25) NULL,
Prodline114 varchar(25) NULL,
Prodline115 varchar(25) NULL,
RenewalAmount42 money NULL,
RenewalAmount43 money NULL,
RenewalAmount44 money NULL,
RenewalAmount45 money NULL,
RenewalAmount46 money NULL,
RenewalAmount47 money NULL,
RenewalAmount100 money NULL,
RenewalAmount101 money NULL,
RenewalAmount102 money NULL,
RenewalAmount103 money NULL,
RenewalAmount104 money NULL,
RenewalAmount105 money NULL,
RenewalAmount106 money NULL,
RenewalAmount107 money NULL,
RenewalAmount108 money NULL,
RenewalAmount109 money NULL,
RenewalAmount110 money NULL,
RenewalAmount111 money NULL,
RenewalAmount112 money NULL,
RenewalAmount113 money NULL,
RenewalAmount114 money NULL,
RenewalAmount115 money NULL,
RenewalForecast42 money NULL,
RenewalForecast43 money NULL,
RenewalForecast44 money NULL,
RenewalForecast45 money NULL,
RenewalForecast46 money NULL,
RenewalForecast47 money NULL,
RenewalForecast100 money NULL,
RenewalForecast101 money NULL,
RenewalForecast102 money NULL,
RenewalForecast103 money NULL,
RenewalForecast104 money NULL,
RenewalForecast105 money NULL,
RenewalForecast106 money NULL,
RenewalForecast107 money NULL,
RenewalForecast108 money NULL,
RenewalForecast109 money NULL,
RenewalForecast110 money NULL,
RenewalForecast111 money NULL,
RenewalForecast112 money NULL,
RenewalForecast113 money NULL,
RenewalForecast114 money NULL,
RenewalForecast115 money NULL,
BasePrice1 money NULL,
BasePrice2 money NULL,
BasePrice3 money NULL,
BasePrice4 money NULL,
BasePrice5 money NULL,
BasePrice6 money NULL,
BasePrice7 money NULL,
BasePrice8 money NULL,
BasePrice9 money NULL,
BasePrice10 money NULL,
BasePrice11 money NULL,
BasePrice12 money NULL,
BasePrice13 money NULL,
BasePrice14 money NULL,
BasePrice15 money NULL,
BasePrice16 money NULL,
BasePrice17 money NULL,
BasePrice18 money NULL,
BasePrice19 money NULL,
BasePrice20 money NULL,
BasePrice21 money NULL,
BasePrice22 money NULL,
BasePrice23 money NULL,
BasePrice24 money NULL,
BasePrice25 money NULL,
BasePrice26 money NULL,
BasePrice27 money NULL,
BasePrice28 money NULL,
BasePrice29 money NULL,
BasePrice30 money NULL,
BasePrice31 money NULL,
BasePrice32 money NULL,
BasePrice33 money NULL,
BasePrice34 money NULL,
BasePrice35 money NULL,
BasePrice36 money NULL,
BasePrice37 money NULL,
BasePrice38 money NULL,
BasePrice39 money NULL,
BasePrice40 money NULL,
BasePrice41 money NULL,
BasePrice42 money NULL,
BasePrice43 money NULL,
BasePrice44 money NULL,
BasePrice45 money NULL,
BasePrice46 money NULL,
BasePrice47 money NULL,
BasePrice100 money NULL,
BasePrice101 money NULL,
BasePrice102 money NULL,
BasePrice103 money NULL,
BasePrice104 money NULL,
BasePrice105 money NULL,
BasePrice106 money NULL,
BasePrice107 money NULL,
BasePrice108 money NULL,
BasePrice109 money NULL,
BasePrice110 money NULL,
BasePrice111 money NULL,
BasePrice112 money NULL,
BasePrice113 money NULL,
BasePrice114 money NULL,
BasePrice115 money NULL,
Prodline200 varchar(25) NULL,
Prodline201 varchar(25) NULL,
Prodline202 varchar(25) NULL,
Prodline204 varchar(25) NULL,
Prodline205 varchar(25) NULL,
Prodline206 varchar(25) NULL,
Prodline207 varchar(25) NULL,
RenewalAmount200 money NULL,
RenewalAmount201 money NULL,
RenewalAmount202 money NULL,
RenewalAmount204 money NULL,
RenewalAmount205 money NULL,
RenewalAmount206 money NULL,
RenewalAmount207 money NULL,
RenewalForecast200 money NULL,
RenewalForecast201 money NULL,
RenewalForecast202 money NULL,
RenewalForecast204 money NULL,
RenewalForecast205 money NULL,
RenewalForecast206 money NULL,
RenewalForecast207 money NULL,
BasePrice200 money NULL,
BasePrice201 money NULL,
BasePrice202 money NULL,
BasePrice204 money NULL,
BasePrice205 money NULL,
BasePrice206 money NULL,
BasePrice207 money NULL,
LeadReassignDate datetime NULL,
RACurrencyType char(3) NULL,
PBACurrencyType char(3) NULL,
CurrencyType char(3) NULL,
ExchangeRate decimal(18,4) NULL,
ContractStartDate smalldatetime NULL,
ValidatedBy varchar(50) NULL,
ValidatedOn smalldatetime NULL,
WebQuoteProcessID int NULL,
Committed bit NULL,
IHSSource4 varchar(50) NULL,
IHSSource5 varchar(50) NULL,
IHSSource6 varchar(50) NULL,
IHSSource7 varchar(50) NULL,
IHSSource8 varchar(50) NULL,
IHSSource9 varchar(50) NULL,
IHSSource10 varchar(50) NULL,
Prodline46 varchar(25) NULL,
Prodline47 varchar(25) NULL
)
-
I showed magarity's horror to Bill (next cube). He says "Normalization level -1".
Philip
-
I don't think you can reffer to normalization when talking about that thing. It could definitly be reworked a little bit (there seem to be a few flags missing
). -
Been there seen that!
* Noel -
Here's one of my favorites, left by a few self proclaimed "programmers" : admire the abscence of nulls, the good use of naming convention and the correct choice of datatype
.CREATE TABLE [dbo].[Chaudières] (
[no] [int] IDENTITY (1, 1) NOT NULL ,
[CNUM] [nvarchar] (50) COLLATE French_CI_AS NULL ,
[Nom du client] [nvarchar] (50) COLLATE French_CI_AS NOT NULL ,
[Succursale] [nvarchar] (50) COLLATE French_CI_AS NULL ,
[Numéro] [int] NULL ,
[Rue] [nvarchar] (50) COLLATE French_CI_AS NULL ,
[Ville] [nvarchar] (50) COLLATE French_CI_AS NOT NULL ,
[Responsable] [nvarchar] (50) COLLATE French_CI_AS NULL ,
[N° téléphone] [nvarchar] (50) COLLATE French_CI_AS NULL ,
[Appareil] [nvarchar] (50) COLLATE French_CI_AS NULL ,
[Date de dernière mise à jour] [smalldatetime] NULL ,
[Appareil #] [nvarchar] (50) COLLATE French_CI_AS NULL ,
[Eau Chaude] [bit] NOT NULL ,
[Vapeur] [bit] NOT NULL ,
[Huile Thermique] [bit] NOT NULL ,
[Huile#2] [bit] NOT NULL ,
[Huile#6] [bit] NOT NULL ,
[Huile usée] [bit] NOT NULL ,
[Gaz Naturel] [bit] NOT NULL ,
[Gaz Propane] [bit] NOT NULL ,
[Gaz Butane] [bit] NOT NULL ,
[Électrique] [bit] NOT NULL ,
[Autre1] [bit] NOT NULL ,
[Autre] [nvarchar] (50) COLLATE French_CI_AS NULL ,
[Pression de gaz] [nvarchar] (50) COLLATE French_CI_AS NULL ,
[Marque] [nvarchar] (50) COLLATE French_CI_AS NULL ,
[Modèle] [nvarchar] (50) COLLATE French_CI_AS NULL ,
[Série] [nvarchar] (50) COLLATE French_CI_AS NULL ,
[commande] [nvarchar] (50) COLLATE French_CI_AS NULL ,
[Capacité de la chaudière] [nvarchar] (50) COLLATE French_CI_AS NULL ,
[Capacité de la chaudière2] [nvarchar] (50) COLLATE French_CI_AS NULL ,
[Crn] [nvarchar] (50) COLLATE French_CI_AS NULL ,
[Surface de chauffe] [real] NULL ,
[dappareil usagé] [nvarchar] (50) COLLATE French_CI_AS NULL ,
[Trou de main qtée] [nvarchar] (50) COLLATE French_CI_AS NULL ,
[trou de main dim] [nvarchar] (50) COLLATE French_CI_AS NULL ,
[Trou de main qtée2] [nvarchar] (50) COLLATE French_CI_AS NULL ,
[trou de main dim2] [nvarchar] (50) COLLATE French_CI_AS NULL ,
[trou dhomme qtée] [nvarchar] (50) COLLATE French_CI_AS NULL ,
[trou dhomme dim] [nvarchar] (50) COLLATE French_CI_AS NULL ,
[Tubes Qtée] [nvarchar] (50) COLLATE French_CI_AS NULL ,
[Tubes Diamètre] [nvarchar] (50) COLLATE French_CI_AS NULL ,
[Tubes Longueur 1] [nvarchar] (50) COLLATE French_CI_AS NULL ,
[Tubes Quantité 2] [nvarchar] (50) COLLATE French_CI_AS NULL ,
[Tubes Diamètre 2] [nvarchar] (50) COLLATE French_CI_AS NULL ,
[Tubes Longueur 2] [nvarchar] (50) COLLATE French_CI_AS NULL ,
[Gauge Glass Ø] [nvarchar] (50) COLLATE French_CI_AS NULL ,
[Gauge Glass longueur] [nvarchar] (50) COLLATE French_CI_AS NULL ,
[Pression de conception] [int] NULL ,
[Pression dopération] [int] NULL ,
[Brûleur intégral] [bit] NOT NULL ,
[Brûleur Marque] [nvarchar] (50) COLLATE French_CI_AS NULL ,
[Brûleur Modèle] [nvarchar] (50) COLLATE French_CI_AS NULL ,
[Brûleur Série] [nvarchar] (50) COLLATE French_CI_AS NULL ,
[Moteur HP] [nvarchar] (255) COLLATE French_CI_AS NULL ,
[Moteur Volts] [nvarchar] (255) COLLATE French_CI_AS NULL ,
[Moteur RPM] [nvarchar] (50) COLLATE French_CI_AS NULL ,
[Moteur Frame] [nvarchar] (50) COLLATE French_CI_AS NULL ,
[Nozzle débit] [numeric](18, 2) NULL ,
[Nozzle degré] [int] NULL ,
[Nozzle type] [nvarchar] (50) COLLATE French_CI_AS NULL ,
[Electrodes] [nvarchar] (50) COLLATE French_CI_AS NULL ,
[Transformateur dallumage marque] [nvarchar] (50) COLLATE French_CI_AS NULL ,
[Transformateur dallumage modèle] [nvarchar] (50) COLLATE French_CI_AS NULL ,
[Type de ventilateur] [nvarchar] (50) COLLATE French_CI_AS NULL ,
[Dimension du ventilateur] [nvarchar] (50) COLLATE French_CI_AS NULL ,
[Sens de rotation du ventilateur] [nvarchar] (50) COLLATE French_CI_AS NULL ,
[Régulateur marque] [nvarchar] (50) COLLATE French_CI_AS NULL ,
[Régulateur modèle] [nvarchar] (50) COLLATE French_CI_AS NULL ,
[Régulateur orifice] [nvarchar] (50) COLLATE French_CI_AS NULL ,
[Régulateur spring] [nvarchar] (50) COLLATE French_CI_AS NULL ,
[Valve principale #1 marque] [nvarchar] (50) COLLATE French_CI_AS NULL ,
[Valve principale #1 modèle] [nvarchar] (50) COLLATE French_CI_AS NULL ,
[Valve #1 actuateur] [nvarchar] (50) COLLATE French_CI_AS NULL ,
[Valve principale #2 marque] [nvarchar] (50) COLLATE French_CI_AS NULL ,
[Valve principale #2 modèle] [nvarchar] (50) COLLATE French_CI_AS NULL ,
[Valve #2 actuateur] [nvarchar] (50) COLLATE French_CI_AS NULL ,
[Vent valve marque] [nvarchar] (50) COLLATE French_CI_AS NULL ,
[Vent valve modèle] [nvarchar] (50) COLLATE French_CI_AS NULL ,
[Valve modulante marque] [nvarchar] (50) COLLATE French_CI_AS NULL ,
[Valve modulante modèle] [nvarchar] (50) COLLATE French_CI_AS NULL ,
[Actuateur modulant marque] [nvarchar] (50) COLLATE French_CI_AS NULL ,
[Actuateur modulant modèle] [nvarchar] (50) COLLATE French_CI_AS NULL ,
[Lgps marque] [nvarchar] (50) COLLATE French_CI_AS NULL ,
[Lgps modele] [nvarchar] (50) COLLATE French_CI_AS NULL ,
[Hgps marque] [nvarchar] (50) COLLATE French_CI_AS NULL ,
[Hgps modele] [nvarchar] (50) COLLATE French_CI_AS NULL ,
[Valve lubrifiée principale marque] [nvarchar] (50) COLLATE French_CI_AS NULL ,
[Valve lubrifiée principale modèle] [nvarchar] (50) COLLATE French_CI_AS NULL ,
[Régulateur de veilleuse marque] [nvarchar] (50) COLLATE French_CI_AS NULL ,
[Régulateur de veilleuse modèle] [nvarchar] (50) COLLATE French_CI_AS NULL ,
[Régulateur de veilleuse orifice] [nvarchar] (50) COLLATE French_CI_AS NULL ,
[Régulateur de veilleuse spring] [nvarchar] (50) COLLATE French_CI_AS NULL ,
[Valve veilleuse #1 marque] [nvarchar] (50) COLLATE French_CI_AS NULL ,
[Valve veilleuse #1 modèle] [nvarchar] (50) COLLATE French_CI_AS NULL ,
[Valve veilleuse #2 marque] [nvarchar] (50) COLLATE French_CI_AS NULL ,
[Valve veilleuse #2 modèle] [nvarchar] (50) COLLATE French_CI_AS NULL ,
[Vent valve de veilleuse marque] [nvarchar] (50) COLLATE French_CI_AS NULL ,
[Vent valve de veilleuse modèle] [nvarchar] (50) COLLATE French_CI_AS NULL ,
[Valve lubrifiée de veilleuse marque] [nvarchar] (50) COLLATE French_CI_AS NULL ,
[Valve lubrifiée de veilleuse modèle] [nvarchar] (50) COLLATE French_CI_AS NULL ,
[Valve principale dhuile #1 marque] [nvarchar] (50) COLLATE French_CI_AS NULL ,
[Valve principale dhuile #1 modèle] [nvarchar] (50) COLLATE French_CI_AS NULL ,
[Valve principale dhuile #2 marque] [nvarchar] (50) COLLATE French_CI_AS NULL ,
[Valve principale dhuile #2 modèle] [nvarchar] (50) COLLATE French_CI_AS NULL ,
[Valve modulante dhuile marque] [nvarchar] (50) COLLATE French_CI_AS NULL ,
[Valve modulante dhuile modèle] [nvarchar] (50) COLLATE French_CI_AS NULL ,
[Actuateur modulant dhuile marque] [nvarchar] (50) COLLATE French_CI_AS NULL ,
[Actuateur modulant dhuile modèle] [nvarchar] (50) COLLATE French_CI_AS NULL ,
[Valve de retour marque] [nvarchar] (50) COLLATE French_CI_AS NULL ,
[Valve de retour modèle] [nvarchar] (50) COLLATE French_CI_AS NULL ,
[Valve de purge marque] [nvarchar] (50) COLLATE French_CI_AS NULL ,
[Valve de purge modèle] [nvarchar] (50) COLLATE French_CI_AS NULL ,
[Réchaud dhuile électrique marque] [nvarchar] (50) COLLATE French_CI_AS NULL ,
[Réchaud dhuile électrique modèle] [nvarchar] (50) COLLATE French_CI_AS NULL ,
[Réchaud dhuile à vapeur marque] [nvarchar] (50) COLLATE French_CI_AS NULL ,
[Réchaud dhuile à vapeur modèle] [nvarchar] (50) COLLATE French_CI_AS NULL ,
[Contrôle temp dhuile marque] [nvarchar] (50) COLLATE French_CI_AS NULL ,
[Contrôle temp dhuile modèle] [nvarchar] (50) COLLATE French_CI_AS NULL ,
[Carte de sortie du contrôle marque] [nvarchar] (50) COLLATE French_CI_AS NULL ,
[Carte de sortie du contrôle modèle] [nvarchar] (50) COLLATE French_CI_AS NULL ,
[Compresseur à air marque] [nvarchar] (50) COLLATE French_CI_AS NULL ,
[Compresseur à air modèle] [nvarchar] (50) COLLATE French_CI_AS NULL ,
[Filtre à air marque] [nvarchar] (50) COLLATE French_CI_AS NULL ,
[Filtre à air modèle] [nvarchar] (50) COLLATE French_CI_AS NULL ,
[Filtre à huile marque] [nvarchar] (50) COLLATE French_CI_AS NULL ,
[Filtre à huile modèle] [nvarchar] (50) COLLATE French_CI_AS NULL ,
[Courroie] [nvarchar] (50) COLLATE French_CI_AS NULL ,
[Moteur compresseur HP] [nvarchar] (50) COLLATE French_CI_AS NULL ,
[Moteur compresseur Volts] [nvarchar] (50) COLLATE French_CI_AS NULL ,
[Moteur compresseur RPM] [nvarchar] (50) COLLATE French_CI_AS NULL ,
[Moteur compresseur Frame] [nvarchar] (50) COLLATE French_CI_AS NULL ,
[Contrôle de bas niveau deau marque] [nvarchar] (50) COLLATE French_CI_AS NULL ,
[Contrôle de bas niveau deau modèle] [nvarchar] (50) COLLATE French_CI_AS NULL ,
[Contrôle de très bas niveau deau marque] [nvarchar] (50) COLLATE French_CI_AS NULL ,
[Contrôle de très bas niveau deau modèle] [nvarchar] (50) COLLATE French_CI_AS NULL ,
[Contrôle de haut niveau deau marque] [nvarchar] (50) COLLATE French_CI_AS NULL ,
[Contrôle de haut niveau deau modèle] [nvarchar] (50) COLLATE French_CI_AS NULL ,
[Haute limite marque] [nvarchar] (50) COLLATE French_CI_AS NULL ,
[Haute limite modèle] [nvarchar] (50) COLLATE French_CI_AS NULL ,
[Opérateur marque] [nvarchar] (50) COLLATE French_CI_AS NULL ,
[Opérateur modèle] [nvarchar] (50) COLLATE French_CI_AS NULL ,
[Contrôle modulation marque] [nvarchar] (50) COLLATE French_CI_AS NULL ,
[Contrôle modulation modèle] [nvarchar] (50) COLLATE French_CI_AS NULL ,
[Interrupteur de pression dair marque] [nvarchar] (50) COLLATE French_CI_AS NULL ,
[Interrupteur de pression dair modèle] [nvarchar] (50) COLLATE French_CI_AS NULL ,
[Superviseur de flamme marque] [nvarchar] (50) COLLATE French_CI_AS NULL ,
[Superviseur de flamme modèle] [nvarchar] (50) COLLATE French_CI_AS NULL ,
[Programmeur marque] [nvarchar] (50) COLLATE French_CI_AS NULL ,
[Programmeur modèle] [nvarchar] (50) COLLATE French_CI_AS NULL ,
[Amplificateur marque] [nvarchar] (50) COLLATE French_CI_AS NULL ,
[Amplificateur modèle] [nvarchar] (50) COLLATE French_CI_AS NULL ,
[Détecteur de flamme marque] [nvarchar] (50) COLLATE French_CI_AS NULL ,
[Détecteur de flamme modèle] [nvarchar] (50) COLLATE French_CI_AS NULL ,
[Valve de sureté #1 marque] [nvarchar] (50) COLLATE French_CI_AS NULL ,
[Valve de sureté #1 modèle] [nvarchar] (50) COLLATE French_CI_AS NULL ,
[Valve de sureté #1 pression] [nvarchar] (50) COLLATE French_CI_AS NULL ,
[Valve de sureté #1 capacité] [nvarchar] (50) COLLATE French_CI_AS NULL ,
[Valve de sureté #1 dimension] [nvarchar] (50) COLLATE French_CI_AS NULL ,
[Valve de sureté #2 marque] [nvarchar] (50) COLLATE French_CI_AS NULL ,
[Valve de sureté #2 modèle] [nvarchar] (50) COLLATE French_CI_AS NULL ,
[Valve de sureté #2 pression] [nvarchar] (50) COLLATE French_CI_AS NULL ,
[Valve de sureté #2 capacité] [nvarchar] (50) COLLATE French_CI_AS NULL ,
[Valve de sureté #2 dimension] [nvarchar] (50) COLLATE French_CI_AS NULL ,
[Valve de sureté #3 marque] [nvarchar] (50) COLLATE French_CI_AS NULL ,
[Valve de sureté #3 modèle] [nvarchar] (50) COLLATE French_CI_AS NULL ,
[Valve de sureté #3 pression] [nvarchar] (50) COLLATE French_CI_AS NULL ,
[Valve de sureté #3 capacité] [nvarchar] (50) COLLATE French_CI_AS NULL ,
[Valve de sureté #3 dimension] [nvarchar] (50) COLLATE French_CI_AS NULL ,
[Valve de sureté #4 marque] [nvarchar] (50) COLLATE French_CI_AS NULL ,
[Valve de sureté #4 modèle] [nvarchar] (50) COLLATE French_CI_AS NULL ,
[Valve de sureté #4 pression] [nvarchar] (50) COLLATE French_CI_AS NULL ,
[Valve de sureté #4 capacité] [nvarchar] (50) COLLATE French_CI_AS NULL ,
[Valve de sureté #4 dimension] [nvarchar] (50) COLLATE French_CI_AS NULL ,
[Valve de sureté #5 marque] [nvarchar] (50) COLLATE French_CI_AS NULL ,
[Valve de sureté #5 modèle] [nvarchar] (50) COLLATE French_CI_AS NULL ,
[Valve de sureté #5 pression] [nvarchar] (50) COLLATE French_CI_AS NULL ,
[Valve de sureté #5 capacité] [nvarchar] (50) COLLATE French_CI_AS NULL ,
[Valve de sureté #5 dimension] [nvarchar] (50) COLLATE French_CI_AS NULL ,
[Fusibles du moteur du ventilateur] [nvarchar] (50) COLLATE French_CI_AS NULL ,
[Fusibles de la metering pump] [nvarchar] (50) COLLATE French_CI_AS NULL ,
[Fusibles du réchaud électrique] [nvarchar] (50) COLLATE French_CI_AS NULL ,
[Fusibles du transformateur de contrôle] [nvarchar] (50) COLLATE French_CI_AS NULL ,
[Démarreur du moteur du ventilateur marque] [nvarchar] (50) COLLATE French_CI_AS NULL ,
[Démarreur du moteur du ventilateur modèle] [nvarchar] (50) COLLATE French_CI_AS NULL ,
[O/L modèle] [nvarchar] (50) COLLATE French_CI_AS NULL ,
[O/L Range] [nvarchar] (50) COLLATE French_CI_AS NULL ,
[Transformateur de contrôle] [nvarchar] (50) COLLATE French_CI_AS NULL ,
[DateInspection] [datetime] NULL ,
[Ouverte] [bit] NOT NULL ,
[DateNettoyage] [datetime] NULL ,
[InspecteurEstFaxe] [bit] NOT NULL ,
[FkContrat] [varchar] (10) COLLATE French_CI_AS NULL ,
[ANettoyer] [bit] NOT NULL ,
[AnneeInspection] [int] NULL
) ON [PRIMARY]
GO
-
I just had to hit the "Reply" button on this one ... however, I am at a total loss of what to say ...
RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."
-
Same reaction I had when I saw the design of the db
. -
I think I've won
The application is SAP. This table has "only" 266 columns.
BUT there is a stored procedure (still in SAP) which has 1015 parameters all with very meaningfull names like @P1 to @P1015!
Here is the table. Please notice all the varchar(1) columns! very effective
Thank you SAP!CREATE TABLE [PA0764] (
[MANDT] [varchar] (3) COLLATE SQL_Latin1_General_CP850_BIN NOT NULL ,
[PERNR] [varchar] (8) COLLATE SQL_Latin1_General_CP850_BIN NOT NULL ,
[SUBTY] [varchar] (4) COLLATE SQL_Latin1_General_CP850_BIN NOT NULL ,
[OBJPS] [varchar] (2) COLLATE SQL_Latin1_General_CP850_BIN NOT NULL ,
[SPRPS] [varchar] (1) COLLATE SQL_Latin1_General_CP850_BIN NOT NULL ,
[ENDDA] [varchar] (8) COLLATE SQL_Latin1_General_CP850_BIN NOT NULL ,
[BEGDA] [varchar] (8) COLLATE SQL_Latin1_General_CP850_BIN NOT NULL ,
[SEQNR] [varchar] (3) COLLATE SQL_Latin1_General_CP850_BIN NOT NULL ,
[AEDTM] [varchar] (8) COLLATE SQL_Latin1_General_CP850_BIN NULL ,
[UNAME] [varchar] (12) COLLATE SQL_Latin1_General_CP850_BIN NULL ,
[HISTO] [varchar] (1) COLLATE SQL_Latin1_General_CP850_BIN NULL ,
[ITXEX] [varchar] (1) COLLATE SQL_Latin1_General_CP850_BIN NULL ,
[REFEX] [varchar] (1) COLLATE SQL_Latin1_General_CP850_BIN NULL ,
[ORDEX] [varchar] (1) COLLATE SQL_Latin1_General_CP850_BIN NULL ,
[ITBLD] [varchar] (2) COLLATE SQL_Latin1_General_CP850_BIN NULL ,
[PREAS] [varchar] (2) COLLATE SQL_Latin1_General_CP850_BIN NULL ,
[FLAG1] [varchar] (1) COLLATE SQL_Latin1_General_CP850_BIN NULL ,
[FLAG2] [varchar] (1) COLLATE SQL_Latin1_General_CP850_BIN NULL ,
[FLAG3] [varchar] (1) COLLATE SQL_Latin1_General_CP850_BIN NULL ,
[FLAG4] [varchar] (1) COLLATE SQL_Latin1_General_CP850_BIN NULL ,
[RESE1] [varchar] (2) COLLATE SQL_Latin1_General_CP850_BIN NULL ,
[RESE2] [varchar] (2) COLLATE SQL_Latin1_General_CP850_BIN NULL ,
[SBMOD] [varchar] (4) COLLATE SQL_Latin1_General_CP850_BIN NULL ,
[SACHC] [varchar] (3) COLLATE SQL_Latin1_General_CP850_BIN NULL ,
[LGEDT] [varchar] (8) COLLATE SQL_Latin1_General_CP850_BIN NULL ,
[VANPW] [varchar] (1) COLLATE SQL_Latin1_General_CP850_BIN NULL ,
[ACT01] [varchar] (3) COLLATE SQL_Latin1_General_CP850_BIN NULL ,
[UTD01] [varchar] (8) COLLATE SQL_Latin1_General_CP850_BIN NULL ,
[END01] [varchar] (8) COLLATE SQL_Latin1_General_CP850_BIN NULL ,
[BEV01] [varchar] (1) COLLATE SQL_Latin1_General_CP850_BIN NULL ,
[ACT02] [varchar] (3) COLLATE SQL_Latin1_General_CP850_BIN NULL ,
[UTD02] [varchar] (8) COLLATE SQL_Latin1_General_CP850_BIN NULL ,
[END02] [varchar] (8) COLLATE SQL_Latin1_General_CP850_BIN NULL ,
[BEV02] [varchar] (1) COLLATE SQL_Latin1_General_CP850_BIN NULL ,
[ACT03] [varchar] (3) COLLATE SQL_Latin1_General_CP850_BIN NULL ,
[UTD03] [varchar] (8) COLLATE SQL_Latin1_General_CP850_BIN NULL ,
[END03] [varchar] (8) COLLATE SQL_Latin1_General_CP850_BIN NULL ,
[BEV03] [varchar] (1) COLLATE SQL_Latin1_General_CP850_BIN NULL ,
[ACT04] [varchar] (3) COLLATE SQL_Latin1_General_CP850_BIN NULL ,
[UTD04] [varchar] (8) COLLATE SQL_Latin1_General_CP850_BIN NULL ,
[END04] [varchar] (8) COLLATE SQL_Latin1_General_CP850_BIN NULL ,
[BEV04] [varchar] (1) COLLATE SQL_Latin1_General_CP850_BIN NULL ,
[ACT05] [varchar] (3) COLLATE SQL_Latin1_General_CP850_BIN NULL ,
[UTD05] [varchar] (8) COLLATE SQL_Latin1_General_CP850_BIN NULL ,
[END05] [varchar] (8) COLLATE SQL_Latin1_General_CP850_BIN NULL ,
[BEV05] [varchar] (1) COLLATE SQL_Latin1_General_CP850_BIN NULL ,
[ACT06] [varchar] (3) COLLATE SQL_Latin1_General_CP850_BIN NULL ,
[UTD06] [varchar] (8) COLLATE SQL_Latin1_General_CP850_BIN NULL ,
[END06] [varchar] (8) COLLATE SQL_Latin1_General_CP850_BIN NULL ,
[BEV06] [varchar] (1) COLLATE SQL_Latin1_General_CP850_BIN NULL ,
[ACT07] [varchar] (3) COLLATE SQL_Latin1_General_CP850_BIN NULL ,
[UTD07] [varchar] (8) COLLATE SQL_Latin1_General_CP850_BIN NULL ,
[END07] [varchar] (8) COLLATE SQL_Latin1_General_CP850_BIN NULL ,
[BEV07] [varchar] (1) COLLATE SQL_Latin1_General_CP850_BIN NULL ,
[ACT08] [varchar] (3) COLLATE SQL_Latin1_General_CP850_BIN NULL ,
[UTD08] [varchar] (8) COLLATE SQL_Latin1_General_CP850_BIN NULL ,
[END08] [varchar] (8) COLLATE SQL_Latin1_General_CP850_BIN NULL ,
[BEV08] [varchar] (1) COLLATE SQL_Latin1_General_CP850_BIN NULL ,
[ACT09] [varchar] (3) COLLATE SQL_Latin1_General_CP850_BIN NULL ,
[UTD09] [varchar] (8) COLLATE SQL_Latin1_General_CP850_BIN NULL ,
[END09] [varchar] (8) COLLATE SQL_Latin1_General_CP850_BIN NULL ,
[BEV09] [varchar] (1) COLLATE SQL_Latin1_General_CP850_BIN NULL ,
[ACT10] [varchar] (3) COLLATE SQL_Latin1_General_CP850_BIN NULL ,
[UTD10] [varchar] (8) COLLATE SQL_Latin1_General_CP850_BIN NULL ,
[END10] [varchar] (8) COLLATE SQL_Latin1_General_CP850_BIN NULL ,
[BEV10] [varchar] (1) COLLATE SQL_Latin1_General_CP850_BIN NULL ,
[ACT11] [varchar] (3) COLLATE SQL_Latin1_General_CP850_BIN NULL ,
[UTD11] [varchar] (8) COLLATE SQL_Latin1_General_CP850_BIN NULL ,
[END11] [varchar] (8) COLLATE SQL_Latin1_General_CP850_BIN NULL ,
[BEV11] [varchar] (1) COLLATE SQL_Latin1_General_CP850_BIN NULL ,
[ACT12] [varchar] (3) COLLATE SQL_Latin1_General_CP850_BIN NULL ,
[UTD12] [varchar] (8) COLLATE SQL_Latin1_General_CP850_BIN NULL ,
[END12] [varchar] (8) COLLATE SQL_Latin1_General_CP850_BIN NULL ,
[BEV12] [varchar] (1) COLLATE SQL_Latin1_General_CP850_BIN NULL ,
[ACT13] [varchar] (3) COLLATE SQL_Latin1_General_CP850_BIN NULL ,
[UTD13] [varchar] (8) COLLATE SQL_Latin1_General_CP850_BIN NULL ,
[END13] [varchar] (8) COLLATE SQL_Latin1_General_CP850_BIN NULL ,
[BEV13] [varchar] (1) COLLATE SQL_Latin1_General_CP850_BIN NULL ,
[ACT14] [varchar] (3) COLLATE SQL_Latin1_General_CP850_BIN NULL ,
[UTD14] [varchar] (8) COLLATE SQL_Latin1_General_CP850_BIN NULL ,
[END14] [varchar] (8) COLLATE SQL_Latin1_General_CP850_BIN NULL ,
[BEV14] [varchar] (1) COLLATE SQL_Latin1_General_CP850_BIN NULL ,
[ACT15] [varchar] (3) COLLATE SQL_Latin1_General_CP850_BIN NULL ,
[UTD15] [varchar] (8) COLLATE SQL_Latin1_General_CP850_BIN NULL ,
[END15] [varchar] (8) COLLATE SQL_Latin1_General_CP850_BIN NULL ,
[BEV15] [varchar] (1) COLLATE SQL_Latin1_General_CP850_BIN NULL ,
[ACT16] [varchar] (3) COLLATE SQL_Latin1_General_CP850_BIN NULL ,
[UTD16] [varchar] (8) COLLATE SQL_Latin1_General_CP850_BIN NULL ,
[END16] [varchar] (8) COLLATE SQL_Latin1_General_CP850_BIN NULL ,
[BEV16] [varchar] (1) COLLATE SQL_Latin1_General_CP850_BIN NULL ,
[ACT17] [varchar] (3) COLLATE SQL_Latin1_General_CP850_BIN NULL ,
[UTD17] [varchar] (8) COLLATE SQL_Latin1_General_CP850_BIN NULL ,
[END17] [varchar] (8) COLLATE SQL_Latin1_General_CP850_BIN NULL ,
[BEV17] [varchar] (1) COLLATE SQL_Latin1_General_CP850_BIN NULL ,
[ACT18] [varchar] (3) COLLATE SQL_Latin1_General_CP850_BIN NULL ,
[UTD18] [varchar] (8) COLLATE SQL_Latin1_General_CP850_BIN NULL ,
[END18] [varchar] (8) COLLATE SQL_Latin1_General_CP850_BIN NULL ,
[BEV18] [varchar] (1) COLLATE SQL_Latin1_General_CP850_BIN NULL ,
[ACT19] [varchar] (3) COLLATE SQL_Latin1_General_CP850_BIN NULL ,
[UTD19] [varchar] (8) COLLATE SQL_Latin1_General_CP850_BIN NULL ,
[END19] [varchar] (8) COLLATE SQL_Latin1_General_CP850_BIN NULL ,
[BEV19] [varchar] (1) COLLATE SQL_Latin1_General_CP850_BIN NULL ,
[ACT20] [varchar] (3) COLLATE SQL_Latin1_General_CP850_BIN NULL ,
[UTD20] [varchar] (8) COLLATE SQL_Latin1_General_CP850_BIN NULL ,
[END20] [varchar] (8) COLLATE SQL_Latin1_General_CP850_BIN NULL ,
[BEV20] [varchar] (1) COLLATE SQL_Latin1_General_CP850_BIN NULL ,
[ACT21] [varchar] (3) COLLATE SQL_Latin1_General_CP850_BIN NULL ,
[UTD21] [varchar] (8) COLLATE SQL_Latin1_General_CP850_BIN NULL ,
[END21] [varchar] (8) COLLATE SQL_Latin1_General_CP850_BIN NULL ,
[BEV21] [varchar] (1) COLLATE SQL_Latin1_General_CP850_BIN NULL ,
[ACT22] [varchar] (3) COLLATE SQL_Latin1_General_CP850_BIN NULL ,
[UTD22] [varchar] (8) COLLATE SQL_Latin1_General_CP850_BIN NULL ,
[END22] [varchar] (8) COLLATE SQL_Latin1_General_CP850_BIN NULL ,
[BEV22] [varchar] (1) COLLATE SQL_Latin1_General_CP850_BIN NULL ,
[ACT23] [varchar] (3) COLLATE SQL_Latin1_General_CP850_BIN NULL ,
[UTD23] [varchar] (8) COLLATE SQL_Latin1_General_CP850_BIN NULL ,
[END23] [varchar] (8) COLLATE SQL_Latin1_General_CP850_BIN NULL ,
[BEV23] [varchar] (1) COLLATE SQL_Latin1_General_CP850_BIN NULL ,
[ACT24] [varchar] (3) COLLATE SQL_Latin1_General_CP850_BIN NULL ,
[UTD24] [varchar] (8) COLLATE SQL_Latin1_General_CP850_BIN NULL ,
[END24] [varchar] (8) COLLATE SQL_Latin1_General_CP850_BIN NULL ,
[BEV24] [varchar] (1) COLLATE SQL_Latin1_General_CP850_BIN NULL ,
[ACT25] [varchar] (3) COLLATE SQL_Latin1_General_CP850_BIN NULL ,
[UTD25] [varchar] (8) COLLATE SQL_Latin1_General_CP850_BIN NULL ,
[END25] [varchar] (8) COLLATE SQL_Latin1_General_CP850_BIN NULL ,
[BEV25] [varchar] (1) COLLATE SQL_Latin1_General_CP850_BIN NULL ,
[ACT26] [varchar] (3) COLLATE SQL_Latin1_General_CP850_BIN NULL ,
[UTD26] [varchar] (8) COLLATE SQL_Latin1_General_CP850_BIN NULL ,
[END26] [varchar] (8) COLLATE SQL_Latin1_General_CP850_BIN NULL ,
[BEV26] [varchar] (1) COLLATE SQL_Latin1_General_CP850_BIN NULL ,
[ACT27] [varchar] (3) COLLATE SQL_Latin1_General_CP850_BIN NULL ,
[UTD27] [varchar] (8) COLLATE SQL_Latin1_General_CP850_BIN NULL ,
[END27] [varchar] (8) COLLATE SQL_Latin1_General_CP850_BIN NULL ,
[BEV27] [varchar] (1) COLLATE SQL_Latin1_General_CP850_BIN NULL ,
[ACT28] [varchar] (3) COLLATE SQL_Latin1_General_CP850_BIN NULL ,
[UTD28] [varchar] (8) COLLATE SQL_Latin1_General_CP850_BIN NULL ,
[END28] [varchar] (8) COLLATE SQL_Latin1_General_CP850_BIN NULL ,
[BEV28] [varchar] (1) COLLATE SQL_Latin1_General_CP850_BIN NULL ,
[ACT29] [varchar] (3) COLLATE SQL_Latin1_General_CP850_BIN NULL ,
[UTD29] [varchar] (8) COLLATE SQL_Latin1_General_CP850_BIN NULL ,
[END29] [varchar] (8) COLLATE SQL_Latin1_General_CP850_BIN NULL ,
[BEV29] [varchar] (1) COLLATE SQL_Latin1_General_CP850_BIN NULL ,
[ACT30] [varchar] (3) COLLATE SQL_Latin1_General_CP850_BIN NULL ,
[UTD30] [varchar] (8) COLLATE SQL_Latin1_General_CP850_BIN NULL ,
[END30] [varchar] (8) COLLATE SQL_Latin1_General_CP850_BIN NULL ,
[BEV30] [varchar] (1) COLLATE SQL_Latin1_General_CP850_BIN NULL ,
[ACT31] [varchar] (3) COLLATE SQL_Latin1_General_CP850_BIN NULL ,
[UTD31] [varchar] (8) COLLATE SQL_Latin1_General_CP850_BIN NULL ,
[END31] [varchar] (8) COLLATE SQL_Latin1_General_CP850_BIN NULL ,
[BEV31] [varchar] (1) COLLATE SQL_Latin1_General_CP850_BIN NULL ,
[ACT32] [varchar] (3) COLLATE SQL_Latin1_General_CP850_BIN NULL ,
[UTD32] [varchar] (8) COLLATE SQL_Latin1_General_CP850_BIN NULL ,
[END32] [varchar] (8) COLLATE SQL_Latin1_General_CP850_BIN NULL ,
[BEV32] [varchar] (1) COLLATE SQL_Latin1_General_CP850_BIN NULL ,
[ACT33] [varchar] (3) COLLATE SQL_Latin1_General_CP850_BIN NULL ,
[UTD33] [varchar] (8) COLLATE SQL_Latin1_General_CP850_BIN NULL ,
[END33] [varchar] (8) COLLATE SQL_Latin1_General_CP850_BIN NULL ,
[BEV33] [varchar] (1) COLLATE SQL_Latin1_General_CP850_BIN NULL ,
[ACT34] [varchar] (3) COLLATE SQL_Latin1_General_CP850_BIN NULL ,
[UTD34] [varchar] (8) COLLATE SQL_Latin1_General_CP850_BIN NULL ,
[END34] [varchar] (8) COLLATE SQL_Latin1_General_CP850_BIN NULL ,
[BEV34] [varchar] (1) COLLATE SQL_Latin1_General_CP850_BIN NULL ,
[ACT35] [varchar] (3) COLLATE SQL_Latin1_General_CP850_BIN NULL ,
[UTD35] [varchar] (8) COLLATE SQL_Latin1_General_CP850_BIN NULL ,
[END35] [varchar] (8) COLLATE SQL_Latin1_General_CP850_BIN NULL ,
[BEV35] [varchar] (1) COLLATE SQL_Latin1_General_CP850_BIN NULL ,
[ACT36] [varchar] (3) COLLATE SQL_Latin1_General_CP850_BIN NULL ,
[UTD36] [varchar] (8) COLLATE SQL_Latin1_General_CP850_BIN NULL ,
[END36] [varchar] (8) COLLATE SQL_Latin1_General_CP850_BIN NULL ,
[BEV36] [varchar] (1) COLLATE SQL_Latin1_General_CP850_BIN NULL ,
[ACT37] [varchar] (3) COLLATE SQL_Latin1_General_CP850_BIN NULL ,
[UTD37] [varchar] (8) COLLATE SQL_Latin1_General_CP850_BIN NULL ,
[END37] [varchar] (8) COLLATE SQL_Latin1_General_CP850_BIN NULL ,
[BEV37] [varchar] (1) COLLATE SQL_Latin1_General_CP850_BIN NULL ,
[ACT38] [varchar] (3) COLLATE SQL_Latin1_General_CP850_BIN NULL ,
[UTD38] [varchar] (8) COLLATE SQL_Latin1_General_CP850_BIN NULL ,
[END38] [varchar] (8) COLLATE SQL_Latin1_General_CP850_BIN NULL ,
[BEV38] [varchar] (1) COLLATE SQL_Latin1_General_CP850_BIN NULL ,
[ACT39] [varchar] (3) COLLATE SQL_Latin1_General_CP850_BIN NULL ,
[UTD39] [varchar] (8) COLLATE SQL_Latin1_General_CP850_BIN NULL ,
[END39] [varchar] (8) COLLATE SQL_Latin1_General_CP850_BIN NULL ,
[BEV39] [varchar] (1) COLLATE SQL_Latin1_General_CP850_BIN NULL ,
[ACT40] [varchar] (3) COLLATE SQL_Latin1_General_CP850_BIN NULL ,
[UTD40] [varchar] (8) COLLATE SQL_Latin1_General_CP850_BIN NULL ,
[END40] [varchar] (8) COLLATE SQL_Latin1_General_CP850_BIN NULL ,
[BEV40] [varchar] (1) COLLATE SQL_Latin1_General_CP850_BIN NULL ,
[ACT41] [varchar] (3) COLLATE SQL_Latin1_General_CP850_BIN NULL ,
[UTD41] [varchar] (8) COLLATE SQL_Latin1_General_CP850_BIN NULL ,
[END41] [varchar] (8) COLLATE SQL_Latin1_General_CP850_BIN NULL ,
[BEV41] [varchar] (1) COLLATE SQL_Latin1_General_CP850_BIN NULL ,
[ACT42] [varchar] (3) COLLATE SQL_Latin1_General_CP850_BIN NULL ,
[UTD42] [varchar] (8) COLLATE SQL_Latin1_General_CP850_BIN NULL ,
[END42] [varchar] (8) COLLATE SQL_Latin1_General_CP850_BIN NULL ,
[BEV42] [varchar] (1) COLLATE SQL_Latin1_General_CP850_BIN NULL ,
[ACT43] [varchar] (3) COLLATE SQL_Latin1_General_CP850_BIN NULL ,
[UTD43] [varchar] (8) COLLATE SQL_Latin1_General_CP850_BIN NULL ,
[END43] [varchar] (8) COLLATE SQL_Latin1_General_CP850_BIN NULL ,
[BEV43] [varchar] (1) COLLATE SQL_Latin1_General_CP850_BIN NULL ,
[ACT44] [varchar] (3) COLLATE SQL_Latin1_General_CP850_BIN NULL ,
[UTD44] [varchar] (8) COLLATE SQL_Latin1_General_CP850_BIN NULL ,
[END44] [varchar] (8) COLLATE SQL_Latin1_General_CP850_BIN NULL ,
[BEV44] [varchar] (1) COLLATE SQL_Latin1_General_CP850_BIN NULL ,
[ACT45] [varchar] (3) COLLATE SQL_Latin1_General_CP850_BIN NULL ,
[UTD45] [varchar] (8) COLLATE SQL_Latin1_General_CP850_BIN NULL ,
[END45] [varchar] (8) COLLATE SQL_Latin1_General_CP850_BIN NULL ,
[BEV45] [varchar] (1) COLLATE SQL_Latin1_General_CP850_BIN NULL ,
[ACT46] [varchar] (3) COLLATE SQL_Latin1_General_CP850_BIN NULL ,
[UTD46] [varchar] (8) COLLATE SQL_Latin1_General_CP850_BIN NULL ,
[END46] [varchar] (8) COLLATE SQL_Latin1_General_CP850_BIN NULL ,
[BEV46] [varchar] (1) COLLATE SQL_Latin1_General_CP850_BIN NULL ,
[ACT47] [varchar] (3) COLLATE SQL_Latin1_General_CP850_BIN NULL ,
[UTD47] [varchar] (8) COLLATE SQL_Latin1_General_CP850_BIN NULL ,
[END47] [varchar] (8) COLLATE SQL_Latin1_General_CP850_BIN NULL ,
[BEV47] [varchar] (1) COLLATE SQL_Latin1_General_CP850_BIN NULL ,
[ACT48] [varchar] (3) COLLATE SQL_Latin1_General_CP850_BIN NULL ,
[UTD48] [varchar] (8) COLLATE SQL_Latin1_General_CP850_BIN NULL ,
[END48] [varchar] (8) COLLATE SQL_Latin1_General_CP850_BIN NULL ,
[BEV48] [varchar] (1) COLLATE SQL_Latin1_General_CP850_BIN NULL ,
[ACT49] [varchar] (3) COLLATE SQL_Latin1_General_CP850_BIN NULL ,
[UTD49] [varchar] (8) COLLATE SQL_Latin1_General_CP850_BIN NULL ,
[END49] [varchar] (8) COLLATE SQL_Latin1_General_CP850_BIN NULL ,
[BEV49] [varchar] (1) COLLATE SQL_Latin1_General_CP850_BIN NULL ,
[ACT50] [varchar] (3) COLLATE SQL_Latin1_General_CP850_BIN NULL ,
[UTD50] [varchar] (8) COLLATE SQL_Latin1_General_CP850_BIN NULL ,
[END50] [varchar] (8) COLLATE SQL_Latin1_General_CP850_BIN NULL ,
[BEV50] [varchar] (1) COLLATE SQL_Latin1_General_CP850_BIN NULL ,
[ACT51] [varchar] (3) COLLATE SQL_Latin1_General_CP850_BIN NULL ,
[UTD51] [varchar] (8) COLLATE SQL_Latin1_General_CP850_BIN NULL ,
[END51] [varchar] (8) COLLATE SQL_Latin1_General_CP850_BIN NULL ,
[BEV51] [varchar] (1) COLLATE SQL_Latin1_General_CP850_BIN NULL ,
[ACT52] [varchar] (3) COLLATE SQL_Latin1_General_CP850_BIN NULL ,
[UTD52] [varchar] (8) COLLATE SQL_Latin1_General_CP850_BIN NULL ,
[END52] [varchar] (8) COLLATE SQL_Latin1_General_CP850_BIN NULL ,
[BEV52] [varchar] (1) COLLATE SQL_Latin1_General_CP850_BIN NULL ,
[ACT53] [varchar] (3) COLLATE SQL_Latin1_General_CP850_BIN NULL ,
[UTD53] [varchar] (8) COLLATE SQL_Latin1_General_CP850_BIN NULL ,
[END53] [varchar] (8) COLLATE SQL_Latin1_General_CP850_BIN NULL ,
[BEV53] [varchar] (1) COLLATE SQL_Latin1_General_CP850_BIN NULL ,
[ACT54] [varchar] (3) COLLATE SQL_Latin1_General_CP850_BIN NULL ,
[UTD54] [varchar] (8) COLLATE SQL_Latin1_General_CP850_BIN NULL ,
[END54] [varchar] (8) COLLATE SQL_Latin1_General_CP850_BIN NULL ,
[BEV54] [varchar] (1) COLLATE SQL_Latin1_General_CP850_BIN NULL ,
[ACT55] [varchar] (3) COLLATE SQL_Latin1_General_CP850_BIN NULL ,
[UTD55] [varchar] (8) COLLATE SQL_Latin1_General_CP850_BIN NULL ,
[END55] [varchar] (8) COLLATE SQL_Latin1_General_CP850_BIN NULL ,
[BEV55] [varchar] (1) COLLATE SQL_Latin1_General_CP850_BIN NULL ,
[ACT56] [varchar] (3) COLLATE SQL_Latin1_General_CP850_BIN NULL ,
[UTD56] [varchar] (8) COLLATE SQL_Latin1_General_CP850_BIN NULL ,
[END56] [varchar] (8) COLLATE SQL_Latin1_General_CP850_BIN NULL ,
[BEV56] [varchar] (1) COLLATE SQL_Latin1_General_CP850_BIN NULL ,
[ACT57] [varchar] (3) COLLATE SQL_Latin1_General_CP850_BIN NULL ,
[UTD57] [varchar] (8) COLLATE SQL_Latin1_General_CP850_BIN NULL ,
[END57] [varchar] (8) COLLATE SQL_Latin1_General_CP850_BIN NULL ,
[BEV57] [varchar] (1) COLLATE SQL_Latin1_General_CP850_BIN NULL ,
[ACT58] [varchar] (3) COLLATE SQL_Latin1_General_CP850_BIN NULL ,
[UTD58] [varchar] (8) COLLATE SQL_Latin1_General_CP850_BIN NULL ,
[END58] [varchar] (8) COLLATE SQL_Latin1_General_CP850_BIN NULL ,
[BEV58] [varchar] (1) COLLATE SQL_Latin1_General_CP850_BIN NULL ,
[ACT59] [varchar] (3) COLLATE SQL_Latin1_General_CP850_BIN NULL ,
[UTD59] [varchar] (8) COLLATE SQL_Latin1_General_CP850_BIN NULL ,
[END59] [varchar] (8) COLLATE SQL_Latin1_General_CP850_BIN NULL ,
[BEV59] [varchar] (1) COLLATE SQL_Latin1_General_CP850_BIN NULL ,
[ACT60] [varchar] (3) COLLATE SQL_Latin1_General_CP850_BIN NULL ,
[UTD60] [varchar] (8) COLLATE SQL_Latin1_General_CP850_BIN NULL ,
[END60] [varchar] (8) COLLATE SQL_Latin1_General_CP850_BIN NULL ,
[BEV60] [varchar] (1) COLLATE SQL_Latin1_General_CP850_BIN NULL ,
CONSTRAINT [PA0764~0] PRIMARY KEY CLUSTERED
(
[MANDT],
[PERNR],
[SUBTY],
[OBJPS],
[SPRPS],
[ENDDA],
[BEGDA],
[SEQNR]
 
ON [PRIMARY]) ON [PRIMARY]
GO
and here is the SP:
CREATE PROCEDURE Y8R10000000D7CC1959EPROFVERSVALUEi203 @P1 varchar(3) = ' ',@P2 varchar(18) = '000000000000000000',@P3 varchar(8) = '00000000',
@P4 varchar(6) = '000000',@P5 decimal(17, 0) = 0.0,@P6 varchar(3) = ' ',@P7 varchar(18) = '000000000000000000',
@P8 varchar(8) = '00000000',@P9 varchar(6) = '000000',@P10 decimal(17, 0) = 0.0,@P11 varchar(3) = ' ',
@P12 varchar(18) = '000000000000000000',@P13 varchar(8) = '00000000',@P14 varchar(6) = '000000',@P15 decimal(17, 0) = 0.0,
@P16 varchar(3) = ' ',@P17 varchar(18) = '000000000000000000',@P18 varchar(8) = '00000000',@P19 varchar(6) = '000000',
@P20 decimal(17, 0) = 0.0,@P21 varchar(3) = ' ',@P22 varchar(18) = '000000000000000000',@P23 varchar(8) = '00000000',
@P24 varchar(6) = '000000',@P25 decimal(17, 0) = 0.0,@P26 varchar(3) = ' ',@P27 varchar(18) = '000000000000000000',
@P28 varchar(8) = '00000000',@P29 varchar(6) = '000000',@P30 decimal(17, 0) = 0.0,@P31 varchar(3) = ' ',
@P32 varchar(18) = '000000000000000000',@P33 varchar(8) = '00000000',@P34 varchar(6) = '000000',@P35 decimal(17, 0) = 0.0,
@P36 varchar(3) = ' ',@P37 varchar(18) = '000000000000000000',@P38 varchar(8) = '00000000',@P39 varchar(6) = '000000',
@P40 decimal(17, 0) = 0.0,@P41 varchar(3) = ' ',@P42 varchar(18) = '000000000000000000',@P43 varchar(8) = '00000000',
@P44 varchar(6) = '000000',@P45 decimal(17, 0) = 0.0,@P46 varchar(3) = ' ',@P47 varchar(18) = '000000000000000000',
@P48 varchar(8) = '00000000',@P49 varchar(6) = '000000',@P50 decimal(17, 0) = 0.0,@P51 varchar(3) = ' ',
@P52 varchar(18) = '000000000000000000',@P53 varchar(8) = '00000000',@P54 varchar(6) = '000000',@P55 decimal(17, 0) = 0.0,
@P56 varchar(3) = ' ',@P57 varchar(18) = '000000000000000000',@P58 varchar(8) = '00000000',@P59 varchar(6) = '000000',
@P60 decimal(17, 0) = 0.0,@P61 varchar(3) = ' ',@P62 varchar(18) = '000000000000000000',@P63 varchar(8) = '00000000',
@P64 varchar(6) = '000000',@P65 decimal(17, 0) = 0.0,@P66 varchar(3) = ' ',@P67 varchar(18) = '000000000000000000',
@P68 varchar(8) = '00000000',@P69 varchar(6) = '000000',@P70 decimal(17, 0) = 0.0,@P71 varchar(3) = ' ',
@P72 varchar(18) = '000000000000000000',@P73 varchar(8) = '00000000',@P74 varchar(6) = '000000',@P75 decimal(17, 0) = 0.0,
@P76 varchar(3) = ' ',@P77 varchar(18) = '000000000000000000',@P78 varchar(8) = '00000000',@P79 varchar(6) = '000000',
@P80 decimal(17, 0) = 0.0,@P81 varchar(3) = ' ',@P82 varchar(18) = '000000000000000000',@P83 varchar(8) = '00000000',
@P84 varchar(6) = '000000',@P85 decimal(17, 0) = 0.0,@P86 varchar(3) = ' ',@P87 varchar(18) = '000000000000000000',
@P88 varchar(8) = '00000000',@P89 varchar(6) = '000000',@P90 decimal(17, 0) = 0.0,@P91 varchar(3) = ' ',
@P92 varchar(18) = '000000000000000000',@P93 varchar(8) = '00000000',@P94 varchar(6) = '000000',@P95 decimal(17, 0) = 0.0,
@P96 varchar(3) = ' ',@P97 varchar(18) = '000000000000000000',@P98 varchar(8) = '00000000',@P99 varchar(6) = '000000',
@P100 decimal(17, 0) = 0.0,@P101 varchar(3) = ' ',@P102 varchar(18) = '000000000000000000',@P103 varchar(8) = '00000000',
@P104 varchar(6) = '000000',@P105 decimal(17, 0) = 0.0,@P106 varchar(3) = ' ',@P107 varchar(18) = '000000000000000000',
@P108 varchar(8) = '00000000',@P109 varchar(6) = '000000',@P110 decimal(17, 0) = 0.0,@P111 varchar(3) = ' ',
@P112 varchar(18) = '000000000000000000',@P113 varchar(8) = '00000000',@P114 varchar(6) = '000000',@P115 decimal(17, 0) = 0.0,
@P116 varchar(3) = ' ',@P117 varchar(18) = '000000000000000000',@P118 varchar(8) = '00000000',@P119 varchar(6) = '000000',
@P120 decimal(17, 0) = 0.0,@P121 varchar(3) = ' ',@P122 varchar(18) = '000000000000000000',@P123 varchar(8) = '00000000',
@P124 varchar(6) = '000000',@P125 decimal(17, 0) = 0.0,@P126 varchar(3) = ' ',@P127 varchar(18) = '000000000000000000',
@P128 varchar(8) = '00000000',@P129 varchar(6) = '000000',@P130 decimal(17, 0) = 0.0,@P131 varchar(3) = ' ',
@P132 varchar(18) = '000000000000000000',@P133 varchar(8) = '00000000',@P134 varchar(6) = '000000',@P135 decimal(17, 0) = 0.0,
@P136 varchar(3) = ' ',@P137 varchar(18) = '000000000000000000',@P138 varchar(8) = '00000000',@P139 varchar(6) = '000000',
@P140 decimal(17, 0) = 0.0,@P141 varchar(3) = ' ',@P142 varchar(18) = '000000000000000000',@P143 varchar(8) = '00000000',
@P144 varchar(6) = '000000',@P145 decimal(17, 0) = 0.0,@P146 varchar(3) = ' ',@P147 varchar(18) = '000000000000000000',
@P148 varchar(8) = '00000000',@P149 varchar(6) = '000000',@P150 decimal(17, 0) = 0.0,@P151 varchar(3) = ' ',
@P152 varchar(18) = '000000000000000000',@P153 varchar(8) = '00000000',@P154 varchar(6) = '000000',@P155 decimal(17, 0) = 0.0,
@P156 varchar(3) = ' ',@P157 varchar(18) = '000000000000000000',@P158 varchar(8) = '00000000',@P159 varchar(6) = '000000',
@P160 decimal(17, 0) = 0.0,@P161 varchar(3) = ' ',@P162 varchar(18) = '000000000000000000',@P163 varchar(8) = '00000000',
@P164 varchar(6) = '000000',@P165 decimal(17, 0) = 0.0,@P166 varchar(3) = ' ',@P167 varchar(18) = '000000000000000000',
@P168 varchar(8) = '00000000',@P169 varchar(6) = '000000',@P170 decimal(17, 0) = 0.0,@P171 varchar(3) = ' ',
@P172 varchar(18) = '000000000000000000',@P173 varchar(8) = '00000000',@P174 varchar(6) = '000000',@P175 decimal(17, 0) = 0.0,
@P176 varchar(3) = ' ',@P177 varchar(18) = '000000000000000000',@P178 varchar(8) = '00000000',@P179 varchar(6) = '000000',
@P180 decimal(17, 0) = 0.0,@P181 varchar(3) = ' ',@P182 varchar(18) = '000000000000000000',@P183 varchar(8) = '00000000',
@P184 varchar(6) = '000000',@P185 decimal(17, 0) = 0.0,@P186 varchar(3) = ' ',@P187 varchar(18) = '000000000000000000',
@P188 varchar(8) = '00000000',@P189 varchar(6) = '000000',@P190 decimal(17, 0) = 0.0,@P191 varchar(3) = ' ',
@P192 varchar(18) = '000000000000000000',@P193 varchar(8) = '00000000',@P194 varchar(6) = '000000',@P195 decimal(17, 0) = 0.0,
@P196 varchar(3) = ' ',@P197 varchar(18) = '000000000000000000',@P198 varchar(8) = '00000000',@P199 varchar(6) = '000000',
@P200 decimal(17, 0) = 0.0,@P201 varchar(3) = ' ',@P202 varchar(18) = '000000000000000000',@P203 varchar(8) = '00000000',
@P204 varchar(6) = '000000',@P205 decimal(17, 0) = 0.0,@P206 varchar(3) = ' ',@P207 varchar(18) = '000000000000000000',
@P208 varchar(8) = '00000000',@P209 varchar(6) = '000000',@P210 decimal(17, 0) = 0.0,@P211 varchar(3) = ' ',
@P212 varchar(18) = '000000000000000000',@P213 varchar(8) = '00000000',@P214 varchar(6) = '000000',@P215 decimal(17, 0) = 0.0,
@P216 varchar(3) = ' ',@P217 varchar(18) = '000000000000000000',@P218 varchar(8) = '00000000',@P219 varchar(6) = '000000',
@P220 decimal(17, 0) = 0.0,@P221 varchar(3) = ' ',@P222 varchar(18) = '000000000000000000',@P223 varchar(8) = '00000000',
@P224 varchar(6) = '000000',@P225 decimal(17, 0) = 0.0,@P226 varchar(3) = ' ',@P227 varchar(18) = '000000000000000000',
@P228 varchar(8) = '00000000',@P229 varchar(6) = '000000',@P230 decimal(17, 0) = 0.0,@P231 varchar(3) = ' ',
@P232 varchar(18) = '000000000000000000',@P233 varchar(8) = '00000000',@P234 varchar(6) = '000000',@P235 decimal(17, 0) = 0.0,
@P236 varchar(3) = ' ',@P237 varchar(18) = '000000000000000000',@P238 varchar(8) = '00000000',@P239 varchar(6) = '000000',
@P240 decimal(17, 0) = 0.0,@P241 varchar(3) = ' ',@P242 varchar(18) = '000000000000000000',@P243 varchar(8) = '00000000',
@P244 varchar(6) = '000000',@P245 decimal(17, 0) = 0.0,@P246 varchar(3) = ' ',@P247 varchar(18) = '000000000000000000',
@P248 varchar(8) = '00000000',@P249 varchar(6) = '000000',@P250 decimal(17, 0) = 0.0,@P251 varchar(3) = ' ',
@P252 varchar(18) = '000000000000000000',@P253 varchar(8) = '00000000',@P254 varchar(6) = '000000',@P255 decimal(17, 0) = 0.0,
@P256 varchar(3) = ' ',@P257 varchar(18) = '000000000000000000',@P258 varchar(8) = '00000000',@P259 varchar(6) = '000000',
@P260 decimal(17, 0) = 0.0,@P261 varchar(3) = ' ',@P262 varchar(18) = '000000000000000000',@P263 varchar(8) = '00000000',
@P264 varchar(6) = '000000',@P265 decimal(17, 0) = 0.0,@P266 varchar(3) = ' ',@P267 varchar(18) = '000000000000000000',
@P268 varchar(8) = '00000000',@P269 varchar(6) = '000000',@P270 decimal(17, 0) = 0.0,@P271 varchar(3) = ' ',
@P272 varchar(18) = '000000000000000000',@P273 varchar(8) = '00000000',@P274 varchar(6) = '000000',@P275 decimal(17, 0) = 0.0,
@P276 varchar(3) = ' ',@P277 varchar(18) = '000000000000000000',@P278 varchar(8) = '00000000',@P279 varchar(6) = '000000',
@P280 decimal(17, 0) = 0.0,@P281 varchar(3) = ' ',@P282 varchar(18) = '000000000000000000',@P283 varchar(8) = '00000000',
@P284 varchar(6) = '000000',@P285 decimal(17, 0) = 0.0,@P286 varchar(3) = ' ',@P287 varchar(18) = '000000000000000000',
@P288 varchar(8) = '00000000',@P289 varchar(6) = '000000',@P290 decimal(17, 0) = 0.0,@P291 varchar(3) = ' ',
@P292 varchar(18) = '000000000000000000',@P293 varchar(8) = '00000000',@P294 varchar(6) = '000000',@P295 decimal(17, 0) = 0.0,
@P296 varchar(3) = ' ',@P297 varchar(18) = '000000000000000000',@P298 varchar(8) = '00000000',@P299 varchar(6) = '000000',
@P300 decimal(17, 0) = 0.0,@P301 varchar(3) = ' ',@P302 varchar(18) = '000000000000000000',@P303 varchar(8) = '00000000',
@P304 varchar(6) = '000000',@P305 decimal(17, 0) = 0.0,@P306 varchar(3) = ' ',@P307 varchar(18) = '000000000000000000',
@P308 varchar(8) = '00000000',@P309 varchar(6) = '000000',@P310 decimal(17, 0) = 0.0,@P311 varchar(3) = ' ',
@P312 varchar(18) = '000000000000000000',@P313 varchar(8) = '00000000',@P314 varchar(6) = '000000',@P315 decimal(17, 0) = 0.0,
@P316 varchar(3) = ' ',@P317 varchar(18) = '000000000000000000',@P318 varchar(8) = '00000000',@P319 varchar(6) = '000000',
@P320 decimal(17, 0) = 0.0,@P321 varchar(3) = ' ',@P322 varchar(18) = '000000000000000000',@P323 varchar(8) = '00000000',
@P324 varchar(6) = '000000',@P325 decimal(17, 0) = 0.0,@P326 varchar(3) = ' ',@P327 varchar(18) = '000000000000000000',
@P328 varchar(8) = '00000000',@P329 varchar(6) = '000000',@P330 decimal(17, 0) = 0.0,@P331 varchar(3) = ' ',
@P332 varchar(18) = '000000000000000000',@P333 varchar(8) = '00000000',@P334 varchar(6) = '000000',@P335 decimal(17, 0) = 0.0,
@P336 varchar(3) = ' ',@P337 varchar(18) = '000000000000000000',@P338 varchar(8) = '00000000',@P339 varchar(6) = '000000',
@P340 decimal(17, 0) = 0.0,@P341 varchar(3) = ' ',@P342 varchar(18) = '000000000000000000',@P343 varchar(8) = '00000000',
@P344 varchar(6) = '000000',@P345 decimal(17, 0) = 0.0,@P346 varchar(3) = ' ',@P347 varchar(18) = '000000000000000000',
@P348 varchar(8) = '00000000',@P349 varchar(6) = '000000',@P350 decimal(17, 0) = 0.0,@P351 varchar(3) = ' ',
@P352 varchar(18) = '000000000000000000',@P353 varchar(8) = '00000000',@P354 varchar(6) = '000000',@P355 decimal(17, 0) = 0.0,
@P356 varchar(3) = ' ',@P357 varchar(18) = '000000000000000000',@P358 varchar(8) = '00000000',@P359 varchar(6) = '000000',
@P360 decimal(17, 0) = 0.0,@P361 varchar(3) = ' ',@P362 varchar(18) = '000000000000000000',@P363 varchar(8) = '00000000',
@P364 varchar(6) = '000000',@P365 decimal(17, 0) = 0.0,@P366 varchar(3) = ' ',@P367 varchar(18) = '000000000000000000',
@P368 varchar(8) = '00000000',@P369 varchar(6) = '000000',@P370 decimal(17, 0) = 0.0,@P371 varchar(3) = ' ',
@P372 varchar(18) = '000000000000000000',@P373 varchar(8) = '00000000',@P374 varchar(6) = '000000',@P375 decimal(17, 0) = 0.0,
@P376 varchar(3) = ' ',@P377 varchar(18) = '000000000000000000',@P378 varchar(8) = '00000000',@P379 varchar(6) = '000000',
@P380 decimal(17, 0) = 0.0,@P381 varchar(3) = ' ',@P382 varchar(18) = '000000000000000000',@P383 varchar(8) = '00000000',
@P384 varchar(6) = '000000',@P385 decimal(17, 0) = 0.0,@P386 varchar(3) = ' ',@P387 varchar(18) = '000000000000000000',
@P388 varchar(8) = '00000000',@P389 varchar(6) = '000000',@P390 decimal(17, 0) = 0.0,@P391 varchar(3) = ' ',
@P392 varchar(18) = '000000000000000000',@P393 varchar(8) = '00000000',@P394 varchar(6) = '000000',@P395 decimal(17, 0) = 0.0,
@P396 varchar(3) = ' ',@P397 varchar(18) = '000000000000000000',@P398 varchar(8) = '00000000',@P399 varchar(6) = '000000',
@P400 decimal(17, 0) = 0.0,@P401 varchar(3) = ' ',@P402 varchar(18) = '000000000000000000',@P403 varchar(8) = '00000000',
@P404 varchar(6) = '000000',@P405 decimal(17, 0) = 0.0,@P406 varchar(3) = ' ',@P407 varchar(18) = '000000000000000000',
@P408 varchar(8) = '00000000',@P409 varchar(6) = '000000',@P410 decimal(17, 0) = 0.0,@P411 varchar(3) = ' ',
@P412 varchar(18) = '000000000000000000',@P413 varchar(8) = '00000000',@P414 varchar(6) = '000000',@P415 decimal(17, 0) = 0.0,
@P416 varchar(3) = ' ',@P417 varchar(18) = '000000000000000000',@P418 varchar(8) = '00000000',@P419 varchar(6) = '000000',
@P420 decimal(17, 0) = 0.0,@P421 varchar(3) = ' ',@P422 varchar(18) = '000000000000000000',@P423 varchar(8) = '00000000',
@P424 varchar(6) = '000000',@P425 decimal(17, 0) = 0.0,@P426 varchar(3) = ' ',@P427 varchar(18) = '000000000000000000',
@P428 varchar(8) = '00000000',@P429 varchar(6) = '000000',@P430 decimal(17, 0) = 0.0,@P431 varchar(3) = ' ',
@P432 varchar(18) = '000000000000000000',@P433 varchar(8) = '00000000',@P434 varchar(6) = '000000',@P435 decimal(17, 0) = 0.0,
@P436 varchar(3) = ' ',@P437 varchar(18) = '000000000000000000',@P438 varchar(8) = '00000000',@P439 varchar(6) = '000000',
@P440 decimal(17, 0) = 0.0,@P441 varchar(3) = ' ',@P442 varchar(18) = '000000000000000000',@P443 varchar(8) = '00000000',
@P444 varchar(6) = '000000',@P445 decimal(17, 0) = 0.0,@P446 varchar(3) = ' ',@P447 varchar(18) = '000000000000000000',
@P448 varchar(8) = '00000000',@P449 varchar(6) = '000000',@P450 decimal(17, 0) = 0.0,@P451 varchar(3) = ' ',
@P452 varchar(18) = '000000000000000000',@P453 varchar(8) = '00000000',@P454 varchar(6) = '000000',@P455 decimal(17, 0) = 0.0,
@p456 varchar(3) = ' ',@P457 varchar(18) = '000000000000000000',@P458 varchar(8) = '00000000',@P459 varchar(6) = '000000',
@P460 decimal(17, 0) = 0.0,@P461 varchar(3) = ' ',@P462 varchar(18) = '000000000000000000',@P463 varchar(8) = '00000000',
@P464 varchar(6) = '000000',@P465 decimal(17, 0) = 0.0,@P466 varchar(3) = ' ',@P467 varchar(18) = '000000000000000000',
@P468 varchar(8) = '00000000',@P469 varchar(6) = '000000',@P470 decimal(17, 0) = 0.0,@P471 varchar(3) = ' ',
@P472 varchar(18) = '000000000000000000',@P473 varchar(8) = '00000000',@P474 varchar(6) = '000000',@P475 decimal(17, 0) = 0.0,
@P476 varchar(3) = ' ',@P477 varchar(18) = '000000000000000000',@P478 varchar(8) = '00000000',@P479 varchar(6) = '000000',
@P480 decimal(17, 0) = 0.0,@P481 varchar(3) = ' ',@P482 varchar(18) = '000000000000000000',@P483 varchar(8) = '00000000',
@P484 varchar(6) = '000000',@P485 decimal(17, 0) = 0.0,@P486 varchar(3) = ' ',@P487 varchar(18) = '000000000000000000',
@P488 varchar(8) = '00000000',@P489 varchar(6) = '000000',@P490 decimal(17, 0) = 0.0,@P491 varchar(3) = ' ',
@P492 varchar(18) = '000000000000000000',@P493 varchar(8) = '00000000',@P494 varchar(6) = '000000',@P495 decimal(17, 0) = 0.0,
@P496 varchar(3) = ' ',@P497 varchar(18) = '000000000000000000',@P498 varchar(8) = '00000000',@P499 varchar(6) = '000000',
@P500 decimal(17, 0) = 0.0,@P501 varchar(3) = ' ',@P502 varchar(18) = '000000000000000000',@P503 varchar(8) = '00000000',
@P504 varchar(6) = '000000',@P505 decimal(17, 0) = 0.0,@P506 varchar(3) = ' ',@P507 varchar(18) = '000000000000000000',
@P508 varchar(8) = '00000000',@P509 varchar(6) = '000000',@P510 decimal(17, 0) = 0.0,@P511 varchar(3) = ' ',
@P512 varchar(18) = '000000000000000000',@P513 varchar(8) = '00000000',@P514 varchar(6) = '000000',@P515 decimal(17, 0) = 0.0,
@P516 varchar(3) = ' ',@P517 varchar(18) = '000000000000000000',@P518 varchar(8) = '00000000',@P519 varchar(6) = '000000',
@P520 decimal(17, 0) = 0.0,@P521 varchar(3) = ' ',@P522 varchar(18) = '000000000000000000',@P523 varchar(8) = '00000000',
@P524 varchar(6) = '000000',@P525 decimal(17, 0) = 0.0,@P526 varchar(3) = ' ',@P527 varchar(18) = '000000000000000000',
@P528 varchar(8) = '00000000',@P529 varchar(6) = '000000',@P530 decimal(17, 0) = 0.0,@P531 varchar(3) = ' ',
@P532 varchar(18) = '000000000000000000',@P533 varchar(8) = '00000000',@P534 varchar(6) = '000000',@P535 decimal(17, 0) = 0.0,
@P536 varchar(3) = ' ',@P537 varchar(18) = '000000000000000000',@P538 varchar(8) = '00000000',@P539 varchar(6) = '000000',
@P540 decimal(17, 0) = 0.0,@P541 varchar(3) = ' ',@P542 varchar(18) = '000000000000000000',@P543 varchar(8) = '00000000',
@P544 varchar(6) = '000000',@P545 decimal(17, 0) = 0.0,@P546 varchar(3) = ' ',@P547 varchar(18) = '000000000000000000',
@P548 varchar(8) = '00000000',@P549 varchar(6) = '000000',@P550 decimal(17, 0) = 0.0,@P551 varchar(3) = ' ',
@P552 varchar(18) = '000000000000000000',@P553 varchar(8) = '00000000',@P554 varchar(6) = '000000',@P555 decimal(17, 0) = 0.0,
@P556 varchar(3) = ' ',@P557 varchar(18) = '000000000000000000',@P558 varchar(8) = '00000000',@P559 varchar(6) = '000000',
@P560 decimal(17, 0) = 0.0,@P561 varchar(3) = ' ',@P562 varchar(18) = '000000000000000000',@P563 varchar(8) = '00000000',
@P564 varchar(6) = '000000',@P565 decimal(17, 0) = 0.0,@P566 varchar(3) = ' ',@P567 varchar(18) = '000000000000000000',
@P568 varchar(8) = '00000000',@P569 varchar(6) = '000000',@P570 decimal(17, 0) = 0.0,@P571 varchar(3) = ' ',
@P572 varchar(18) = '000000000000000000',@P573 varchar(8) = '00000000',@P574 varchar(6) = '000000',@P575 decimal(17, 0) = 0.0,
@P576 varchar(3) = ' ',@P577 varchar(18) = '000000000000000000',@P578 varchar(8) = '00000000',@P579 varchar(6) = '000000',
@P580 decimal(17, 0) = 0.0,@P581 varchar(3) = ' ',@P582 varchar(18) = '000000000000000000',@P583 varchar(8) = '00000000',
@P584 varchar(6) = '000000',@P585 decimal(17, 0) = 0.0,@P586 varchar(3) = ' ',@P587 varchar(18) = '000000000000000000',
@P588 varchar(8) = '00000000',@P589 varchar(6) = '000000',@P590 decimal(17, 0) = 0.0,@P591 varchar(3) = ' ',
@P592 varchar(18) = '000000000000000000',@P593 varchar(8) = '00000000',@P594 varchar(6) = '000000',@P595 decimal(17, 0) = 0.0,
@P596 varchar(3) = ' ',@P597 varchar(18) = '000000000000000000',@P598 varchar(8) = '00000000',@P599 varchar(6) = '000000',
@P600 decimal(17, 0) = 0.0,@P601 varchar(3) = ' ',@P602 varchar(18) = '000000000000000000',@P603 varchar(8) = '00000000',
@P604 varchar(6) = '000000',@P605 decimal(17, 0) = 0.0,@P606 varchar(3) = ' ',@P607 varchar(18) = '000000000000000000',
@P608 varchar(8) = '00000000',@P609 varchar(6) = '000000',@P610 decimal(17, 0) = 0.0,@P611 varchar(3) = ' ',
@P612 varchar(18) = '000000000000000000',@P613 varchar(8) = '00000000',@P614 varchar(6) = '000000',@P615 decimal(17, 0) = 0.0,
@P616 varchar(3) = ' ',@P617 varchar(18) = '000000000000000000',@P618 varchar(8) = '00000000',@P619 varchar(6) = '000000',
@P620 decimal(17, 0) = 0.0,@P621 varchar(3) = ' ',@P622 varchar(18) = '000000000000000000',@P623 varchar(8) = '00000000',
@P624 varchar(6) = '000000',@P625 decimal(17, 0) = 0.0,@P626 varchar(3) = ' ',@P627 varchar(18) = '000000000000000000',
@P628 varchar(8) = '00000000',@P629 varchar(6) = '000000',@P630 decimal(17, 0) = 0.0,@P631 varchar(3) = ' ',
@P632 varchar(18) = '000000000000000000',@P633 varchar(8) = '00000000',@P634 varchar(6) = '000000',@P635 decimal(17, 0) = 0.0,
@P636 varchar(3) = ' ',@P637 varchar(18) = '000000000000000000',@P638 varchar(8) = '00000000',@P639 varchar(6) = '000000',
@P640 decimal(17, 0) = 0.0,@P641 varchar(3) = ' ',@P642 varchar(18) = '000000000000000000',@P643 varchar(8) = '00000000',
@P644 varchar(6) = '000000',@P645 decimal(17, 0) = 0.0,@P646 varchar(3) = ' ',@P647 varchar(18) = '000000000000000000',
@P648 varchar(8) = '00000000',@P649 varchar(6) = '000000',@P650 decimal(17, 0) = 0.0,@P651 varchar(3) = ' ',
@P652 varchar(18) = '000000000000000000',@P653 varchar(8) = '00000000',@P654 varchar(6) = '000000',@P655 decimal(17, 0) = 0.0,
@P656 varchar(3) = ' ',@P657 varchar(18) = '000000000000000000',@P658 varchar(8) = '00000000',@P659 varchar(6) = '000000',
@P660 decimal(17, 0) = 0.0,@P661 varchar(3) = ' ',@P662 varchar(18) = '000000000000000000',@P663 varchar(8) = '00000000',
@P664 varchar(6) = '000000',@P665 decimal(17, 0) = 0.0,@P666 varchar(3) = ' ',@P667 varchar(18) = '000000000000000000',
@P668 varchar(8) = '00000000',@P669 varchar(6) = '000000',@P670 decimal(17, 0) = 0.0,@P671 varchar(3) = ' ',
@P672 varchar(18) = '000000000000000000',@P673 varchar(8) = '00000000',@P674 varchar(6) = '000000',@P675 decimal(17, 0) = 0.0,
@P676 varchar(3) = ' ',@P677 varchar(18) = '000000000000000000',@P678 varchar(8) = '00000000',@P679 varchar(6) = '000000',
@P680 decimal(17, 0) = 0.0,@P681 varchar(3) = ' ',@P682 varchar(18) = '000000000000000000',@P683 varchar(8) = '00000000',
@P684 varchar(6) = '000000',@P685 decimal(17, 0) = 0.0,@P686 varchar(3) = ' ',@P687 varchar(18) = '000000000000000000',
@P688 varchar(8) = '00000000',@P689 varchar(6) = '000000',@P690 decimal(17, 0) = 0.0,@P691 varchar(3) = ' ',
@P692 varchar(18) = '000000000000000000',@P693 varchar(8) = '00000000',@P694 varchar(6) = '000000',@P695 decimal(17, 0) = 0.0,
@P696 varchar(3) = ' ',@P697 varchar(18) = '000000000000000000',@P698 varchar(8) = '00000000',@P699 varchar(6) = '000000',
@P700 decimal(17, 0) = 0.0,@P701 varchar(3) = ' ',@P702 varchar(18) = '000000000000000000',@P703 varchar(8) = '00000000',
@P704 varchar(6) = '000000',@P705 decimal(17, 0) = 0.0,@P706 varchar(3) = ' ',@P707 varchar(18) = '000000000000000000',
@P708 varchar(8) = '00000000',@P709 varchar(6) = '000000',@P710 decimal(17, 0) = 0.0,@P711 varchar(3) = ' ',
@P712 varchar(18) = '000000000000000000',@P713 varchar(8) = '00000000',@P714 varchar(6) = '000000',@P715 decimal(17, 0) = 0.0,
@P716 varchar(3) = ' ',@P717 varchar(18) = '000000000000000000',@P718 varchar(8) = '00000000',@P719 varchar(6) = '000000',
@P720 decimal(17, 0) = 0.0,@P721 varchar(3) = ' ',@P722 varchar(18) = '000000000000000000',@P723 varchar(8) = '00000000',
@P724 varchar(6) = '000000',@P725 decimal(17, 0) = 0.0,@P726 varchar(3) = ' ',@P727 varchar(18) = '000000000000000000',
@P728 varchar(8) = '00000000',@P729 varchar(6) = '000000',@P730 decimal(17, 0) = 0.0,@P731 varchar(3) = ' ',
@P732 varchar(18) = '000000000000000000',@P733 varchar(8) = '00000000',@P734 varchar(6) = '000000',@P735 decimal(17, 0) = 0.0,
@P736 varchar(3) = ' ',@P737 varchar(18) = '000000000000000000',@P738 varchar(8) = '00000000',@P739 varchar(6) = '000000',
@P740 decimal(17, 0) = 0.0,@P741 varchar(3) = ' ',@P742 varchar(18) = '000000000000000000',@P743 varchar(8) = '00000000',
@P744 varchar(6) = '000000',@P745 decimal(17, 0) = 0.0,@P746 varchar(3) = ' ',@P747 varchar(18) = '000000000000000000',
@P748 varchar(8) = '00000000',@P749 varchar(6) = '000000',@P750 decimal(17, 0) = 0.0,@P751 varchar(3) = ' ',
@P752 varchar(18) = '000000000000000000',@P753 varchar(8) = '00000000',@P754 varchar(6) = '000000',@P755 decimal(17, 0) = 0.0,
@P756 varchar(3) = ' ',@P757 varchar(18) = '000000000000000000',@P758 varchar(8) = '00000000',@P759 varchar(6) = '000000',
@P760 decimal(17, 0) = 0.0,@P761 varchar(3) = ' ',@P762 varchar(18) = '000000000000000000',@P763 varchar(8) = '00000000',
@P764 varchar(6) = '000000',@P765 decimal(17, 0) = 0.0,@P766 varchar(3) = ' ',@P767 varchar(18) = '000000000000000000',
@P768 varchar(8) = '00000000',@P769 varchar(6) = '000000',@P770 decimal(17, 0) = 0.0,@P771 varchar(3) = ' ',
@P772 varchar(18) = '000000000000000000',@P773 varchar(8) = '00000000',@P774 varchar(6) = '000000',@P775 decimal(17, 0) = 0.0,
@P776 varchar(3) = ' ',@P777 varchar(18) = '000000000000000000',@P778 varchar(8) = '00000000',@P779 varchar(6) = '000000',
@P780 decimal(17, 0) = 0.0,@P781 varchar(3) = ' ',@P782 varchar(18) = '000000000000000000',@P783 varchar(8) = '00000000',
@P784 varchar(6) = '000000',@P785 decimal(17, 0) = 0.0,@P786 varchar(3) = ' ',@P787 varchar(18) = '000000000000000000',
@P788 varchar(8) = '00000000',@P789 varchar(6) = '000000',@P790 decimal(17, 0) = 0.0,@P791 varchar(3) = ' ',
@P792 varchar(18) = '000000000000000000',@P793 varchar(8) = '00000000',@P794 varchar(6) = '000000',@P795 decimal(17, 0) = 0.0,
@P796 varchar(3) = ' ',@P797 varchar(18) = '000000000000000000',@P798 varchar(8) = '00000000',@P799 varchar(6) = '000000',
@P800 decimal(17, 0) = 0.0,@P801 varchar(3) = ' ',@P802 varchar(18) = '000000000000000000',@P803 varchar(8) = '00000000',
@P804 varchar(6) = '000000',@P805 decimal(17, 0) = 0.0,@P806 varchar(3) = ' ',@P807 varchar(18) = '000000000000000000',
@P808 varchar(8) = '00000000',@P809 varchar(6) = '000000',@P810 decimal(17, 0) = 0.0,@P811 varchar(3) = ' ',
@P812 varchar(18) = '000000000000000000',@P813 varchar(8) = '00000000',@P814 varchar(6) = '000000',@P815 decimal(17, 0) = 0.0,
@P816 varchar(3) = ' ',@P817 varchar(18) = '000000000000000000',@P818 varchar(8) = '00000000',@P819 varchar(6) = '000000',
@P820 decimal(17, 0) = 0.0,@P821 varchar(3) = ' ',@P822 varchar(18) = '000000000000000000',@P823 varchar(8) = '00000000',
@P824 varchar(6) = '000000',@P825 decimal(17, 0) = 0.0,@P826 varchar(3) = ' ',@P827 varchar(18) = '000000000000000000',
@P828 varchar(8) = '00000000',@P829 varchar(6) = '000000',@P830 decimal(17, 0) = 0.0,@P831 varchar(3) = ' ',
@P832 varchar(18) = '000000000000000000',@P833 varchar(8) = '00000000',@P834 varchar(6) = '000000',@P835 decimal(17, 0) = 0.0,
@P836 varchar(3) = ' ',@P837 varchar(18) = '000000000000000000',@P838 varchar(8) = '00000000',@P839 varchar(6) = '000000',
@P840 decimal(17, 0) = 0.0,@P841 varchar(3) = ' ',@P842 varchar(18) = '000000000000000000',@P843 varchar(8) = '00000000',
@P844 varchar(6) = '000000',@P845 decimal(17, 0) = 0.0,@P846 varchar(3) = ' ',@P847 varchar(18) = '000000000000000000',
@P848 varchar(8) = '00000000',@P849 varchar(6) = '000000',@P850 decimal(17, 0) = 0.0,@P851 varchar(3) = ' ',
@P852 varchar(18) = '000000000000000000',@P853 varchar(8) = '00000000',@P854 varchar(6) = '000000',@P855 decimal(17, 0) = 0.0,
@P856 varchar(3) = ' ',@P857 varchar(18) = '000000000000000000',@P858 varchar(8) = '00000000',@P859 varchar(6) = '000000',
@P860 decimal(17, 0) = 0.0,@P861 varchar(3) = ' ',@P862 varchar(18) = '000000000000000000',@P863 varchar(8) = '00000000',
@P864 varchar(6) = '000000',@P865 decimal(17, 0) = 0.0,@P866 varchar(3) = ' ',@P867 varchar(18) = '000000000000000000',
@P868 varchar(8) = '00000000',@P869 varchar(6) = '000000',@P870 decimal(17, 0) = 0.0,@P871 varchar(3) = ' ',
@P872 varchar(18) = '000000000000000000',@P873 varchar(8) = '00000000',@P874 varchar(6) = '000000',@P875 decimal(17, 0) = 0.0,
@P876 varchar(3) = ' ',@P877 varchar(18) = '000000000000000000',@P878 varchar(8) = '00000000',@P879 varchar(6) = '000000',
@P880 decimal(17, 0) = 0.0,@P881 varchar(3) = ' ',@P882 varchar(18) = '000000000000000000',@P883 varchar(8) = '00000000',
@P884 varchar(6) = '000000',@P885 decimal(17, 0) = 0.0,@P886 varchar(3) = ' ',@P887 varchar(18) = '000000000000000000',
@p888 varchar(8) = '00000000',@P889 varchar(6) = '000000',@P890 decimal(17, 0) = 0.0,@P891 varchar(3) = ' ',
@P892 varchar(18) = '000000000000000000',@P893 varchar(8) = '00000000',@P894 varchar(6) = '000000',@P895 decimal(17, 0) = 0.0,
@P896 varchar(3) = ' ',@P897 varchar(18) = '000000000000000000',@P898 varchar(8) = '00000000',@P899 varchar(6) = '000000',
@P900 decimal(17, 0) = 0.0,@P901 varchar(3) = ' ',@P902 varchar(18) = '000000000000000000',@P903 varchar(8) = '00000000',
@P904 varchar(6) = '000000',@P905 decimal(17, 0) = 0.0,@P906 varchar(3) = ' ',@P907 varchar(18) = '000000000000000000',
@P908 varchar(8) = '00000000',@P909 varchar(6) = '000000',@P910 decimal(17, 0) = 0.0,@P911 varchar(3) = ' ',
@P912 varchar(18) = '000000000000000000',@P913 varchar(8) = '00000000',@P914 varchar(6) = '000000',@P915 decimal(17, 0) = 0.0,
@P916 varchar(3) = ' ',@P917 varchar(18) = '000000000000000000',@P918 varchar(8) = '00000000',@P919 varchar(6) = '000000',
@P920 decimal(17, 0) = 0.0,@P921 varchar(3) = ' ',@P922 varchar(18) = '000000000000000000',@P923 varchar(8) = '00000000',
@P924 varchar(6) = '000000',@P925 decimal(17, 0) = 0.0,@P926 varchar(3) = ' ',@P927 varchar(18) = '000000000000000000',
@P928 varchar(8) = '00000000',@P929 varchar(6) = '000000',@P930 decimal(17, 0) = 0.0,@P931 varchar(3) = ' ',
@P932 varchar(18) = '000000000000000000',@P933 varchar(8) = '00000000',@P934 varchar(6) = '000000',@P935 decimal(17, 0) = 0.0,
@P936 varchar(3) = ' ',@P937 varchar(18) = '000000000000000000',@P938 varchar(8) = '00000000',@P939 varchar(6) = '000000',
@P940 decimal(17, 0) = 0.0,@P941 varchar(3) = ' ',@P942 varchar(18) = '000000000000000000',@P943 varchar(8) = '00000000',
@P944 varchar(6) = '000000',@P945 decimal(17, 0) = 0.0,@P946 varchar(3) = ' ',@P947 varchar(18) = '000000000000000000',
@P948 varchar(8) = '00000000',@P949 varchar(6) = '000000',@P950 decimal(17, 0) = 0.0,@P951 varchar(3) = ' ',
@P952 varchar(18) = '000000000000000000',@P953 varchar(8) = '00000000',@P954 varchar(6) = '000000',@P955 decimal(17, 0) = 0.0,
@P956 varchar(3) = ' ',@P957 varchar(18) = '000000000000000000',@P958 varchar(8) = '00000000',@P959 varchar(6) = '000000',
@P960 decimal(17, 0) = 0.0,@P961 varchar(3) = ' ',@P962 varchar(18) = '000000000000000000',@P963 varchar(8) = '00000000',
@P964 varchar(6) = '000000',@P965 decimal(17, 0) = 0.0,@P966 varchar(3) = ' ',@P967 varchar(18) = '000000000000000000',
@P968 varchar(8) = '00000000',@P969 varchar(6) = '000000',@P970 decimal(17, 0) = 0.0,@P971 varchar(3) = ' ',
@P972 varchar(18) = '000000000000000000',@P973 varchar(8) = '00000000',@P974 varchar(6) = '000000',@P975 decimal(17, 0) = 0.0,
@P976 varchar(3) = ' ',@P977 varchar(18) = '000000000000000000',@P978 varchar(8) = '00000000',@P979 varchar(6) = '000000',
@P980 decimal(17, 0) = 0.0,@P981 varchar(3) = ' ',@P982 varchar(18) = '000000000000000000',@P983 varchar(8) = '00000000',
@P984 varchar(6) = '000000',@P985 decimal(17, 0) = 0.0,@P986 varchar(3) = ' ',@P987 varchar(18) = '000000000000000000',
@P988 varchar(8) = '00000000',@P989 varchar(6) = '000000',@P990 decimal(17, 0) = 0.0,@P991 varchar(3) = ' ',
@P992 varchar(18) = '000000000000000000',@P993 varchar(8) = '00000000',@P994 varchar(6) = '000000',@P995 decimal(17, 0) = 0.0,
@P996 varchar(3) = ' ',@P997 varchar(18) = '000000000000000000',@P998 varchar(8) = '00000000',@P999 varchar(6) = '000000',
@P1000 decimal(17, 0) = 0.0,@P1001 varchar(3) = ' ',@P1002 varchar(18) = '000000000000000000',@P1003 varchar(8) = '00000000',
@P1004 varchar(6) = '000000',@P1005 decimal(17, 0) = 0.0,@P1006 varchar(3) = ' ',@P1007 varchar(18) = '000000000000000000',
@P1008 varchar(8) = '00000000',@P1009 varchar(6) = '000000',@P1010 decimal(17, 0) = 0.0,@P1011 varchar(3) = ' ',
@P1012 varchar(18) = '000000000000000000',@P1013 varchar(8) = '00000000',@P1014 varchar(6) = '000000',@P1015 decimal(17, 0) = 0.0
AS BEGIN
INSERT INTO "EPROFVERSVALUE" ( "MANDT" ,"PROFVERSNO" ,"VALUEDAY" ,"VALUETIME" ,"VALUE" )
SELECT @P1 ,@P2 ,@P3 ,@P4 ,@P5 UNION ALL
SELECT @P6 ,@P7 ,@P8 ,@P9 ,@P10 UNION ALL
SELECT @P11 ,@P12 ,@P13 ,@P14 ,@P15 UNION ALL
SELECT @P16 ,@P17 ,@P18 ,@P19 ,@P20 UNION ALL
SELECT @P21 ,@P22 ,@P23 ,@P24 ,@P25 UNION ALL
SELECT @P26 ,@P27 ,@P28 ,@P29 ,@P30 UNION ALL
SELECT @P31 ,@P32 ,@P33 ,@P34 ,@P35 UNION ALL
SELECT @P36 ,@P37 ,@P38 ,@P39 ,@P40 UNION ALL
SELECT @P41 ,@P42 ,@P43 ,@P44 ,@P45 UNION ALL
SELECT @P46 ,@P47 ,@P48 ,@P49 ,@P50 UNION ALL
SELECT @P51 ,@P52 ,@P53 ,@P54 ,@P55 UNION ALL
SELECT @P56 ,@P57 ,@P58 ,@P59 ,@P60 UNION ALL
SELECT @P61 ,@P62 ,@P63 ,@P64 ,@P65 UNION ALL
SELECT @P66 ,@P67 ,@P68 ,@P69 ,@P70 UNION ALL
SELECT @P71 ,@P72 ,@P73 ,@P74 ,@P75 UNION ALL
SELECT @P76 ,@P77 ,@P78 ,@P79 ,@P80 UNION ALL
SELECT @P81 ,@P82 ,@P83 ,@P84 ,@P85 UNION ALL
SELECT @P86 ,@P87 ,@P88 ,@P89 ,@P90 UNION ALL
SELECT @P91 ,@P92 ,@P93 ,@P94 ,@P95 UNION ALL
SELECT @P96 ,@P97 ,@P98 ,@P99 ,@P100 UNION ALL
SELECT @P101 ,@P102 ,@P103 ,@P104 ,@P105 UNION ALL
SELECT @P106 ,@P107 ,@P108 ,@P109 ,@P110 UNION ALL
SELECT @P111 ,@P112 ,@P113 ,@P114 ,@P115 UNION ALL
SELECT @P116 ,@P117 ,@P118 ,@P119 ,@P120 UNION ALL
SELECT @P121 ,@P122 ,@P123 ,@P124 ,@P125 UNION ALL
SELECT @P126 ,@P127 ,@P128 ,@P129 ,@P130 UNION ALL
SELECT @P131 ,@P132 ,@P133 ,@P134 ,@P135 UNION ALL
SELECT @P136 ,@P137 ,@P138 ,@P139 ,@P140 UNION ALL
SELECT @P141 ,@P142 ,@P143 ,@P144 ,@P145 UNION ALL
SELECT @P146 ,@P147 ,@P148 ,@P149 ,@P150 UNION ALL
SELECT @P151 ,@P152 ,@P153 ,@P154 ,@P155 UNION ALL
SELECT @P156 ,@P157 ,@P158 ,@P159 ,@P160 UNION ALL
SELECT @P161 ,@P162 ,@P163 ,@P164 ,@P165 UNION ALL
SELECT @P166 ,@P167 ,@P168 ,@P169 ,@P170 UNION ALL
SELECT @P171 ,@P172 ,@P173 ,@P174 ,@P175 UNION ALL
SELECT @P176 ,@P177 ,@P178 ,@P179 ,@P180 UNION ALL
SELECT @P181 ,@P182 ,@P183 ,@P184 ,@P185 UNION ALL
SELECT @P186 ,@P187 ,@P188 ,@P189 ,@P190 UNION ALL
SELECT @P191 ,@P192 ,@P193 ,@P194 ,@P195 UNION ALL
SELECT @P196 ,@P197 ,@P198 ,@P199 ,@P200 UNION ALL
SELECT @P201 ,@P202 ,@P203 ,@P204 ,@P205 UNION ALL
SELECT @P206 ,@P207 ,@P208 ,@P209 ,@P210 UNION ALL
SELECT @P211 ,@P212 ,@P213 ,@P214 ,@P215 UNION ALL
SELECT @P216 ,@P217 ,@P218 ,@P219 ,@P220 UNION ALL
SELECT @P221 ,@P222 ,@P223 ,@P224 ,@P225 UNION ALL
SELECT @P226 ,@P227 ,@P228 ,@P229 ,@P230 UNION ALL
SELECT @P231 ,@P232 ,@P233 ,@P234 ,@P235 UNION ALL
SELECT @P236 ,@P237 ,@P238 ,@P239 ,@P240 UNION ALL
SELECT @P241 ,@P242 ,@P243 ,@P244 ,@P245 UNION ALL
SELECT @P246 ,@P247 ,@P248 ,@P249 ,@P250 UNION ALL
SELECT @P251 ,@P252 ,@P253 ,@P254 ,@P255 UNION ALL
SELECT @P256 ,@P257 ,@P258 ,@P259 ,@P260 UNION ALL
SELECT @P261 ,@P262 ,@P263 ,@P264 ,@P265 UNION ALL
SELECT @P266 ,@P267 ,@P268 ,@P269 ,@P270 UNION ALL
SELECT @P271 ,@P272 ,@P273 ,@P274 ,@P275 UNION ALL
SELECT @P276 ,@P277 ,@P278 ,@P279 ,@P280 UNION ALL
SELECT @P281 ,@P282 ,@P283 ,@P284 ,@P285 UNION ALL
SELECT @P286 ,@P287 ,@P288 ,@P289 ,@P290 UNION ALL
SELECT @P291 ,@P292 ,@P293 ,@P294 ,@P295 UNION ALL
SELECT @P296 ,@P297 ,@P298 ,@P299 ,@P300 UNION ALL
SELECT @P301 ,@P302 ,@P303 ,@P304 ,@P305 UNION ALL
SELECT @P306 ,@P307 ,@P308 ,@P309 ,@P310 UNION ALL
SELECT @P311 ,@P312 ,@P313 ,@P314 ,@P315 UNION ALL
SELECT @P316 ,@P317 ,@P318 ,@P319 ,@P320 UNION ALL
SELECT @P321 ,@P322 ,@P323 ,@P324 ,@P325 UNION ALL
SELECT @P326 ,@P327 ,@P328 ,@P329 ,@P330 UNION ALL
SELECT @P331 ,@P332 ,@P333 ,@P334 ,@P335 UNION ALL
SELECT @P336 ,@P337 ,@P338 ,@P339 ,@P340 UNION ALL
SELECT @P341 ,@P342 ,@P343 ,@P344 ,@P345 UNION ALL
SELECT @P346 ,@P347 ,@P348 ,@P349 ,@P350 UNION ALL
SELECT @P351 ,@P352 ,@P353 ,@P354 ,@P355 UNION ALL
SELECT @P356 ,@P357 ,@P358 ,@P359 ,@P360 UNION ALL
SELECT @P361 ,@P362 ,@P363 ,@P364 ,@P365 UNION ALL
SELECT @P366 ,@P367 ,@P368 ,@P369 ,@P370 UNION ALL
SELECT @P371 ,@P372 ,@P373 ,@P374 ,@P375 UNION ALL
SELECT @P376 ,@P377 ,@P378 ,@P379 ,@P380 UNION ALL
SELECT @P381 ,@P382 ,@P383 ,@P384 ,@P385 UNION ALL
SELECT @P386 ,@P387 ,@P388 ,@P389 ,@P390 UNION ALL
SELECT @P391 ,@P392 ,@P393 ,@P394 ,@P395 UNION ALL
SELECT @P396 ,@P397 ,@P398 ,@P399 ,@P400 UNION ALL
SELECT @P401 ,@P402 ,@P403 ,@P404 ,@P405 UNION ALL
SELECT @P406 ,@P407 ,@P408 ,@P409 ,@P410 UNION ALL
SELECT @P411 ,@P412 ,@P413 ,@P414 ,@P415 UNION ALL
SELECT @P416 ,@P417 ,@P418 ,@P419 ,@P420 UNION ALL
SELECT @P421 ,@P422 ,@P423 ,@P424 ,@P425 UNION ALL
SELECT @P426 ,@P427 ,@P428 ,@P429 ,@P430 UNION ALL
SELECT @P431 ,@P432 ,@P433 ,@P434 ,@P435 UNION ALL
SELECT @P436 ,@P437 ,@P438 ,@P439 ,@P440 UNION ALL
SELECT @P441 ,@P442 ,@P443 ,@P444 ,@P445 UNION ALL
SELECT @P446 ,@P447 ,@P448 ,@P449 ,@P450 UNION ALL
SELECT @P451 ,@P452 ,@P453 ,@P454 ,@P455 UNION ALL
SELECT @p456 ,@P457 ,@P458 ,@P459 ,@P460 UNION ALL
SELECT @P461 ,@P462 ,@P463 ,@P464 ,@P465 UNION ALL
SELECT @P466 ,@P467 ,@P468 ,@P469 ,@P470 UNION ALL
SELECT @P471 ,@P472 ,@P473 ,@P474 ,@P475 UNION ALL
SELECT @P476 ,@P477 ,@P478 ,@P479 ,@P480 UNION ALL
SELECT @P481 ,@P482 ,@P483 ,@P484 ,@P485 UNION ALL
SELECT @P486 ,@P487 ,@P488 ,@P489 ,@P490 UNION ALL
SELECT @P491 ,@P492 ,@P493 ,@P494 ,@P495 UNION ALL
SELECT @P496 ,@P497 ,@P498 ,@P499 ,@P500 UNION ALL
SELECT @P501 ,@P502 ,@P503 ,@P504 ,@P505 UNION ALL
SELECT @P506 ,@P507 ,@P508 ,@P509 ,@P510 UNION ALL
SELECT @P511 ,@P512 ,@P513 ,@P514 ,@P515 UNION ALL
SELECT @P516 ,@P517 ,@P518 ,@P519 ,@P520 UNION ALL
SELECT @P521 ,@P522 ,@P523 ,@P524 ,@P525 UNION ALL
SELECT @P526 ,@P527 ,@P528 ,@P529 ,@P530 UNION ALL
SELECT @P531 ,@P532 ,@P533 ,@P534 ,@P535 UNION ALL
SELECT @P536 ,@P537 ,@P538 ,@P539 ,@P540 UNION ALL
SELECT @P541 ,@P542 ,@P543 ,@P544 ,@P545 UNION ALL
SELECT @P546 ,@P547 ,@P548 ,@P549 ,@P550 UNION ALL
SELECT @P551 ,@P552 ,@P553 ,@P554 ,@P555 UNION ALL
SELECT @P556 ,@P557 ,@P558 ,@P559 ,@P560 UNION ALL
SELECT @P561 ,@P562 ,@P563 ,@P564 ,@P565 UNION ALL
SELECT @P566 ,@P567 ,@P568 ,@P569 ,@P570 UNION ALL
SELECT @P571 ,@P572 ,@P573 ,@P574 ,@P575 UNION ALL
SELECT @P576 ,@P577 ,@P578 ,@P579 ,@P580 UNION ALL
SELECT @P581 ,@P582 ,@P583 ,@P584 ,@P585 UNION ALL
SELECT @P586 ,@P587 ,@P588 ,@P589 ,@P590 UNION ALL
SELECT @P591 ,@P592 ,@P593 ,@P594 ,@P595 UNION ALL
SELECT @P596 ,@P597 ,@P598 ,@P599 ,@P600 UNION ALL
SELECT @P601 ,@P602 ,@P603 ,@P604 ,@P605 UNION ALL
SELECT @P606 ,@P607 ,@P608 ,@P609 ,@P610 UNION ALL
SELECT @P611 ,@P612 ,@P613 ,@P614 ,@P615 UNION ALL
SELECT @P616 ,@P617 ,@P618 ,@P619 ,@P620 UNION ALL
SELECT @P621 ,@P622 ,@P623 ,@P624 ,@P625 UNION ALL
SELECT @P626 ,@P627 ,@P628 ,@P629 ,@P630 UNION ALL
SELECT @P631 ,@P632 ,@P633 ,@P634 ,@P635 UNION ALL
SELECT @P636 ,@P637 ,@P638 ,@P639 ,@P640 UNION ALL
SELECT @P641 ,@P642 ,@P643 ,@P644 ,@P645 UNION ALL
SELECT @P646 ,@P647 ,@P648 ,@P649 ,@P650 UNION ALL
SELECT @P651 ,@P652 ,@P653 ,@P654 ,@P655 UNION ALL
SELECT @P656 ,@P657 ,@P658 ,@P659 ,@P660 UNION ALL
SELECT @P661 ,@P662 ,@P663 ,@P664 ,@P665 UNION ALL
SELECT @P666 ,@P667 ,@P668 ,@P669 ,@P670 UNION ALL
SELECT @P671 ,@P672 ,@P673 ,@P674 ,@P675 UNION ALL
SELECT @P676 ,@P677 ,@P678 ,@P679 ,@P680 UNION ALL
SELECT @P681 ,@P682 ,@P683 ,@P684 ,@P685 UNION ALL
SELECT @P686 ,@P687 ,@P688 ,@P689 ,@P690 UNION ALL
SELECT @P691 ,@P692 ,@P693 ,@P694 ,@P695 UNION ALL
SELECT @P696 ,@P697 ,@P698 ,@P699 ,@P700 UNION ALL
SELECT @P701 ,@P702 ,@P703 ,@P704 ,@P705 UNION ALL
SELECT @P706 ,@P707 ,@P708 ,@P709 ,@P710 UNION ALL
SELECT @P711 ,@P712 ,@P713 ,@P714 ,@P715 UNION ALL
SELECT @P716 ,@P717 ,@P718 ,@P719 ,@P720 UNION ALL
SELECT @P721 ,@P722 ,@P723 ,@P724 ,@P725 UNION ALL
SELECT @P726 ,@P727 ,@P728 ,@P729 ,@P730 UNION ALL
SELECT @P731 ,@P732 ,@P733 ,@P734 ,@P735 UNION ALL
SELECT @P736 ,@P737 ,@P738 ,@P739 ,@P740 UNION ALL
SELECT @P741 ,@P742 ,@P743 ,@P744 ,@P745 UNION ALL
SELECT @P746 ,@P747 ,@P748 ,@P749 ,@P750 UNION ALL
SELECT @P751 ,@P752 ,@P753 ,@P754 ,@P755 UNION ALL
SELECT @P756 ,@P757 ,@P758 ,@P759 ,@P760 UNION ALL
SELECT @P761 ,@P762 ,@P763 ,@P764 ,@P765 UNION ALL
SELECT @P766 ,@P767 ,@P768 ,@P769 ,@P770 UNION ALL
SELECT @P771 ,@P772 ,@P773 ,@P774 ,@P775 UNION ALL
SELECT @P776 ,@P777 ,@P778 ,@P779 ,@P780 UNION ALL
SELECT @P781 ,@P782 ,@P783 ,@P784 ,@P785 UNION ALL
SELECT @P786 ,@P787 ,@P788 ,@P789 ,@P790 UNION ALL
SELECT @P791 ,@P792 ,@P793 ,@P794 ,@P795 UNION ALL
SELECT @P796 ,@P797 ,@P798 ,@P799 ,@P800 UNION ALL
SELECT @P801 ,@P802 ,@P803 ,@P804 ,@P805 UNION ALL
SELECT @P806 ,@P807 ,@P808 ,@P809 ,@P810 UNION ALL
SELECT @P811 ,@P812 ,@P813 ,@P814 ,@P815 UNION ALL
SELECT @P816 ,@P817 ,@P818 ,@P819 ,@P820 UNION ALL
SELECT @P821 ,@P822 ,@P823 ,@P824 ,@P825 UNION ALL
SELECT @P826 ,@P827 ,@P828 ,@P829 ,@P830 UNION ALL
SELECT @P831 ,@P832 ,@P833 ,@P834 ,@P835 UNION ALL
SELECT @P836 ,@P837 ,@P838 ,@P839 ,@P840 UNION ALL
SELECT @P841 ,@P842 ,@P843 ,@P844 ,@P845 UNION ALL
SELECT @P846 ,@P847 ,@P848 ,@P849 ,@P850 UNION ALL
SELECT @P851 ,@P852 ,@P853 ,@P854 ,@P855 UNION ALL
SELECT @P856 ,@P857 ,@P858 ,@P859 ,@P860 UNION ALL
SELECT @P861 ,@P862 ,@P863 ,@P864 ,@P865 UNION ALL
SELECT @P866 ,@P867 ,@P868 ,@P869 ,@P870 UNION ALL
SELECT @P871 ,@P872 ,@P873 ,@P874 ,@P875 UNION ALL
SELECT @P876 ,@P877 ,@P878 ,@P879 ,@P880 UNION ALL
SELECT @P881 ,@P882 ,@P883 ,@P884 ,@P885 UNION ALL
SELECT @P886 ,@P887 ,@P888 ,@P889 ,@P890 UNION ALL
SELECT @P891 ,@P892 ,@P893 ,@P894 ,@P895 UNION ALL
SELECT @P896 ,@P897 ,@P898 ,@P899 ,@P900 UNION ALL
SELECT @P901 ,@P902 ,@P903 ,@P904 ,@P905 UNION ALL
SELECT @P906 ,@P907 ,@P908 ,@P909 ,@P910 UNION ALL
SELECT @P911 ,@P912 ,@P913 ,@P914 ,@P915 UNION ALL
SELECT @P916 ,@P917 ,@P918 ,@P919 ,@P920 UNION ALL
SELECT @P921 ,@P922 ,@P923 ,@P924 ,@P925 UNION ALL
SELECT @P926 ,@P927 ,@P928 ,@P929 ,@P930 UNION ALL
SELECT @P931 ,@P932 ,@P933 ,@P934 ,@P935 UNION ALL
SELECT @P936 ,@P937 ,@P938 ,@P939 ,@P940 UNION ALL
SELECT @P941 ,@P942 ,@P943 ,@P944 ,@P945 UNION ALL
SELECT @P946 ,@P947 ,@P948 ,@P949 ,@P950 UNION ALL
SELECT @P951 ,@P952 ,@P953 ,@P954 ,@P955 UNION ALL
SELECT @P956 ,@P957 ,@P958 ,@P959 ,@P960 UNION ALL
SELECT @P961 ,@P962 ,@P963 ,@P964 ,@P965 UNION ALL
SELECT @P966 ,@P967 ,@P968 ,@P969 ,@P970 UNION ALL
SELECT @P971 ,@P972 ,@P973 ,@P974 ,@P975 UNION ALL
SELECT @P976 ,@P977 ,@P978 ,@P979 ,@P980 UNION ALL
SELECT @P981 ,@P982 ,@P983 ,@P984 ,@P985 UNION ALL
SELECT @P986 ,@P987 ,@P988 ,@P989 ,@P990 UNION ALL
SELECT @P991 ,@P992 ,@P993 ,@P994 ,@P995 UNION ALL
SELECT @P996 ,@P997 ,@P998 ,@P999 ,@P1000 UNION ALL
SELECT @P1001 ,@P1002 ,@P1003 ,@P1004 ,@P1005 UNION ALL
SELECT @P1006 ,@P1007 ,@P1008 ,@P1009 ,@P1010 UNION ALL
SELECT @P1011 ,@P1012 ,@P1013 ,@P1014 ,@P1015
RETURN @@ROWCOUNT
END
Bye
Gabor
Viewing 15 posts - 1 through 15 (of 31 total)
You must be logged in to reply to this topic. Login to reply