Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
anishap
Yak Posting Veteran
61 Posts |
 Posted - 2006-02-02 : 15:43:09
|
| Hi,I have a table Employee.REC_NUM long(8) Primary Key ID char(25) ID LNAME char(40) Last Name FNAME char(40) First Name MI char(20) Middle Initial LASTFMI char(40) Computed Last, First MI. SEX char(1) References GENDER.CODE Gender BDATE date Date of birth HOMEPHON char(20) Home telephone # DEPT char(12) References DEPT.CODE Department code JOB char(12) References JOB.CODE Job code ADD1 char(30) Address line 1 ADD2 char(30) Address line 2 CITY char(20) City STATE char(4) References STATE.CODE State USERSTR[60] char(30) User String Field We have inserted data into the userstr(1). I want to display rows from this field.Select id,lname,fname,userstr(1) from employee doesn't work.Can any one help me how to retrieve data from array using select statement.Many thanks |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-02-02 : 15:56:53
|
| What does userstr(1) even mean?SELECT *FROM YourTableWHERE USERSTR = 'SomeValueGoesHere'Is this even Microsoft SQL Server? If not, you might want to try www.dbforums.com .Tara Kizeraka tduggan |
 |
|
|
anishap
Yak Posting Veteran
61 Posts |
Posted - 2006-02-02 : 17:52:39
|
| It is MS SQL Server.userstr[60]We have budget number added to this field userstr[1]. I want to display all rows in this field.select userstr[1] from employee is not giving the correct information.It is just giving some numbers.thanks |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-02-02 : 17:55:28
|
| Could you run SELECT @@VERSION and put the results here? SQL Server 2000 doesn't support this array option in a column. I'm not sure about 2005.Tara Kizeraka tduggan |
|
|
|
anishap
Yak Posting Veteran
61 Posts |
Posted - 2006-02-02 : 18:17:25
|
| Microsoft SQL Server 2000 |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-02-02 : 18:21:16
|
| SQL Server 2000 does not support arrays in a column. Please post the DDL for the table. DDL would be the CREATE TABLE statement. It can generated from Enterprise Manager by right clicking, All tasks, generate SQL scripts. Post the DDL here.Tara Kizeraka tduggan |
|
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2006-02-02 : 18:23:42
|
| Can you post the DDL of your employee table ?----------------------------------'KH' |
|
|
|
jsmith8858
Dr. Cross Join
7423 Posts |
Posted - 2006-02-02 : 19:01:58
|
| I am pretty baffled by this one so far ... I think we have our first nominee for "most cryptic question of the year" for 2006. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-02-02 : 19:22:09
|
| I actually understand the problem. I'm not believing that he is using SQL Server 2000 though as it doesn't support arrays in a column. Well not in the traditional array sense. I guess you could store comma separated values, but that would hardly be considered an array. Plus you couldn't do userstr[1] on it as Anish is suggesting.Tara Kizeraka tduggan |
|
|
|
anishap
Yak Posting Veteran
61 Posts |
Posted - 2006-02-02 : 19:49:35
|
| I'm using a vendor software Below is the DDL provided by vendor.Table: EMPLOYEE, Description: Employee DemographicsREC_NUM long(8) Primary Key SSN char(25) SSN ID char(25) ID LNAME char(40) Last Name FNAME char(40) First Name MI char(20) Middle Initial LASTFMI char(40) Computed Last, First MI. SEX char(1) References GENDER.CODE Gender SEXWORD char(6) Computed Sex Word (Male/Female) RACE char(6) References RACE.CODE Ethnic Group BDATE date Date of birth HOMEPHON char(20) Home telephone # MARITAL char(1) References MARITAL.CODE Marital Status SHIFT char(8) References SHIFT.CODE Work shift COMP char(12) References COMP.CODE Company code LOC char(12) References LOC.CODE Location code DEPT char(12) References DEPT.CODE Department code JOB char(12) References JOB.CODE Job code WAGEHOUR long(8,2) Wage/Hour WAGE_DAY long(8,2) Wage per day WAGEWEEK long(8,2) Wage/Week HOURDAY int(4,2)) Hours / day DAY/WEEK int(4,2)) Days/Week UNION char(6) References UNION.CODE Union Code ADD1 char(30) Address line 1 ADD2 char(30) Address line 2 CITY char(20) City STATE char(4) References STATE.CODE State ZIP char(9) Zip code COUNTY char(20) County CITYSTZP char(40) Computed City, State, Zip Code MAILSTOP char(10) Mail Stop WORKPHON char(20) Work phone HIREDATE date Date of hire JOBDATE date Date started current job JOBYRS int(2) Computed Number of years on job JOBMON int(1) Computed Number of months on job JOBTIME char(20) Computed Job Time - Years, Months RESTRCN memo Permanent Restrictions Memo RSTRTYPE[100] char(6) References RESTRCAT.CODE Restriction Types HDCAPTYP[10] char(6) References HDCAPTYP.CODE Handicap Type HANDICAP memo Handicaps CURMEDS[20] char(6) References MEDICINE.CODE Current Medications CMEDNAME[20] char(40) Medication name CMEDDOSE[20] char(20) Current Medication Dosage CMEDROUT[20] char(10) Current Medication Route ALLERGY[20] char(6) References ALLERGY.CODE Allergies ALLDESCR[20] char(40) Allergy description STATUS char(6) References EMPSTATS.CODE Employment status SUPER char(12) References SUPER.CODE Supervisor code SUPRNAME char(25) Supervisor Name EXPOSURE[200] char(6) References EXPOSURE.CODE Exam/Training Programs ERCNTACT char(30) Emergency Contacts ERRELATE char(20) Emergency Contact Relationship ERADDESS[3] char(40) Emergency Contact Address ERHPHONE char(20) Emergency Contact Home Phone ERWPHONE char(20) Emergency Contact Work Phone MD char(30) Personal Physician MDADD[3] char(40) Personal Physician Address MDPHONE char(20) Personal Physician Phone MEDHIS memo Medical History Overview TERMDATE date Termination Date NOTEDISP char(14) Computed Notes notify display string NTNTFFLG char(1) Notify Notes Flag NOTE memo Note pad USERSTR[60] char(30) User String Field USERDATE[30] date User Date Field DEPENDNT[10] char(30) Dependents DEPNDDOB[10] date Dependent Date Of Birth DEPNDREL[10] char(20) Dependent Relationship FEESCHDL char(10) References FEESCHDL.CODE INSRDLNM char(20) Insured's last name INSRDFNM char(15) Insured's first name INSRMI char(1) Insured's middle initial INSRLFMI char(30) Computed Insured's Name (Last, First Mi) INSRDOB date Insured's date of birth INSRDAD1 char(30) Insured's address line 1 INSRDAD2 char(30) Insured's address line 2 INSRCITY char(20) Insured's city INSRDST char(2) Insured's state INSRDZIP char(9) Insured's zip code INSRDSEX char(1) Insured's sex INSRDREL char(6) References RELATE.CODE Insured's relationship to employee INSRDPHN char(20) Insured's home phone INSRDWPH char(20) Insured's work phone INSURANC char(10) References INSCOMP.CODE Insurance INSPOLNM char(16) Insured's policy number EXCEXAM[100] char(6) References PHYSICAL.CODE Exams/Training Employee Is Excluded From INSGROUP char(20) Insurance Group Number 2NDINSR char(1) Employee Has Secondary Insurance(y/n) PAYCODE char(6) References PAYCODE.CODE Pay Code SERVCODE char(6) References SERVCOMP.CODE Military Service Code DOD_COMP char(6) References DODCOMP.CODE DOD Component CIVGRADE char(8) References CIVGRADE.CODE Civilian Grade MAJCMND char(12) Military Major Command PERSTYPE char(1) References PERSTYPE.CODE Person Type IMPORTED char(1) FHWA char(1) Employee Covered By Fed Highway Admin FAA char(1) Employee Covered By FAA FRA char(1) Employee Covered By FRA FTA char(1) Employee Covered By FTA RSPA char(1) Employee Covered By RSPA USCG char(1) Employee Covered By USCG DOTCOVRD char(1) Computed Employee Covered By DOT Drug/Alcohol Testing MAIDEN char(20) Maiden Name INSCAT char(4) References INSCATG.CODE Insurance Category BIRPLACE char(20) Birth Place EMAIL char(80) e-mail Address RESTRBEG[100] date Date Restrictions Begin RESTREND[100] date Date Restrictions End RESTRRVD[100] date Date Restrictions Need To Be Reviewed SALARY char(1) Salaried Employee(y/n) INSRSSN char(9) Insured's SSN INSREMPL char(40) Insured's Employer INSREMAD char(40) Insured's Employer Address INSREMCT char(20) Insured's Employer City INSREMST char(2) Insured's Employer State INSREMZP char(10) Insured's Employer Zip INSREMIC char(10) References INSCOMP.CODE Insured's Insurance Company GUARPOLC char(20) Guarantor Policy/Group Number DIVISION char(12) References DIVISION.CODE Division INSPLAN char(12) References INSPLAN.CODE WHYRMEDR char(6) References WHYRMEDR.CODE Why Refused To Give Medical Record Number SMOKSTAT char(1) References SMOKSTAT.CODE Smoking Status LANGUAGE char(2) References LANGUAGE.CODE Language CHARTLOC char(6) References CHARTLOC.CODE Chart Location COUNTRY char(6) References COUNTRY.CODE Country RCNTRBFE date Most Recent Body Fluid Exposure STATACTN char(6) References STATACTN.CODE Status Action WKFRCGRP char(6) References WKFRCGRP.CODE Work Force Group WKFRCCAT char(6) References WKFRCCAT.CODE Work Force Category HROFFICE char(8) References HROFFICE.CODE HR Office REGION char(12) References REGION.CODE Region ORGUNIT char(12) References ORGUNIT.CODE Organization Unit PLACEGRP char(6) References PLACEGRP.CODE Placement Group HMADCNTR char(6) References COUNTRY.CODE Home Mailing Address Country ADDRDATE date Effective Date Of Address POSTITLE char(40) Position Title WORKGRP char(20) References WORKGRP.CODE Work Group MEDRECNO char(20) Medical Record Number EXPSFROM[200] int(2) Exposure From SMOKUPDT date Date Smoking Information Updated PACKDAY int(2) Packs/Day Smoked YEARSMOK int(2) Years Smoking NUMDEPND int(2) Number Of Dependents ULNAME char(40) Uppercase Last Name UFNAME char(40) Uppercase First Name ADD3 char(30) Address Line 3 ADD4 char(30) Address Line 4 ID2 char(16) Employee ID 2 ID3 char(16) Employee ID 3 SSNEND char(4) Last 4 Digits Of SSN COSTCTR char(12) References COSTCTR.CODE Cost Center DOD date Date Of Death HIDENAME char(1) Hide Name On Reports AGE int(3) Computed Employee's current age YREMP int(2) Computed Years Employed MONEMP int(4) Computed Months Employed EMPTIME char(20) Computed CPRCERT date Computed Date of most recent CPR Certification 1SAIDCRT date Computed Date of most recent first aid certification CPRRECRT date Computed Date due for CPR Recertification 1STAIDRC date Computed Date due for 1st Aid Recertification ACTIVE char(1) Computed Active(y/n) - determined from status SALUTE char(25) Computed Salutation (Mr/Ms lastname) TETANUS long(8) Computed References IMMUNE.REC_NUM Last Tetanus Immunization Record CURABSRC long(8) Computed References ABSENTEE.REC_NUM Current Absentee Record SSN_ID char(12) Computed SSN Or ID Depending On Security CURHEPB long(8) Computed References HEPATITS.REC_NUM Current Hepatitis B Record CURAUDIO long(8) Computed References HEAR.REC_NUM Current Hearing Test CURPFT long(8) Computed References PFT.REC_NUM Current PFT Record CURRUBTR long(8) Computed References TITER.REC_NUM Current Rubella Titer CURRBOTR long(8) Computed References TITER.REC_NUM Current Rubeola Titer CURMUMTR long(8) Computed References TITER.REC_NUM Current Mumps Titer CURVARTR long(8) Computed References TITER.REC_NUM Current Varicella Titer CURPPD long(8) Computed References TUBER.REC_NUM Current PPD CURRUBVC long(8) Computed References IMMUNE.REC_NUM Current Rubella Vaccine CURMMRVC long(8) Computed References IMMUNE.REC_NUM Current MMR CURRBOVC long(8) Computed References IMMUNE.REC_NUM Current Rubeola Vaccine CURVARVC long(8) Computed References IMMUNE.REC_NUM Current Varicella Vaccine CURMUMVC long(8) Computed References IMMUNE.REC_NUM Current Mumps Vaccine CURPOLVC long(8) Computed References IMMUNE.REC_NUM Current Polio Vaccine HEPLABSA long(8) Computed References HEPLAB.REC_NUM Hep B Surface Antibody Record HEPLABAN long(8) Computed References HEPLAB.REC_NUM Hepatits B Antigen Record HEPLABCR long(8) Computed References HEPLAB.REC_NUM Hep B Core Antibody Record CURFLEXE long(8) Computed References FLEXIBLE.REC_NUM Current Flexibility Evaluation CURBFAT long(8) Computed References BODYFAT.REC_NUM Current Body Fat Evaluation CURCHOL long(8) Computed References CHOL.REC_NUM Current Cholesterol LNAMEFIN char(25) Computed Last Name With First Name Initial PACKYEAR int(4) Computed Pack Years .I'm using SQL Server 2000.Below is the DDLCREATE TABLE [EMPLOYEE] ( [FLDMODDATE] [datetime] NULL , [FLDUSERID] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [FLDREC_NUM] [int] NOT NULL , [FLDSSN] [varchar] (25) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [FLDID] [varchar] (25) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [FLDLNAME] [varchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [FLDFNAME] [varchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [FLDMI] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [FLDSEX] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [FLDRACE] [varchar] (6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [FLDBDATE] [datetime] NULL , [FLDHOMEPHON] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [FLDMARITAL] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [FLDSHIFT] [varchar] (8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [FLDCOMP] [varchar] (12) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [FLDLOC] [varchar] (12) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [FLDDEPT] [varchar] (12) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [FLDJOB] [varchar] (12) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [FLDWAGEHOUR] [int] NULL , [FLDWAGE_DAY] [int] NULL , [FLDWAGEWEEK] [int] NULL , [FLDHOURDAY] [smallint] NULL , [FLDDAY_WEEK] [smallint] NULL , [FLDUNION] [varchar] (6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [FLDADD1] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [FLDADD2] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [FLDCITY] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [FLDSTATE] [varchar] (4) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [FLDZIP] [varchar] (9) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [FLDCOUNTY] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [FLDMAILSTOP] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [FLDWORKPHON] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [FLDHIREDATE] [datetime] NULL , [FLDJOBDATE] [datetime] NULL , [FLDRESTRCN] [int] NULL , [FLDRSTRTYPE] [int] NULL , [FLDHDCAPTYP] [int] NULL , [FLDHANDICAP] [int] NULL , [FLDCURMEDS] [int] NULL , [FLDCMEDNAME] [int] NULL , [FLDCMEDDOSE] [int] NULL , [FLDCMEDROUT] [int] NULL , [FLDALLERGY] [int] NULL , [FLDALLDESCR] [int] NULL , [FLDSTATUS] [varchar] (6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [FLDSUPER] [varchar] (12) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [FLDSUPRNAME] [varchar] (25) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [FLDEXPOSURE] [int] NULL , [FLDERCNTACT] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [FLDERRELATE] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [FLDERADDESS1] [varchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [FLDERADDESS2] [varchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [FLDERADDESS3] [varchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [FLDERHPHONE] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [FLDERWPHONE] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [FLDMD] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [FLDMDADD1] [varchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [FLDMDADD2] [varchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [FLDMDADD3] [varchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [FLDMDPHONE] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [FLDMEDHIS] [int] NULL , [FLDTERMDATE] [datetime] NULL , [FLDNTNTFFLG] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [FLDNOTE] [int] NULL , [FLDUSERSTR] [int] NULL , [FLDUSERDATE] [int] NULL , [FLDDEPENDNT] [int] NULL , [FLDDEPNDDOB] [int] NULL , [FLDDEPNDREL] [int] NULL , [FLDFEESCHDL] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [FLDINSRDLNM] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [FLDINSRDFNM] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [FLDINSRMI] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [FLDINSRDOB] [datetime] NULL , [FLDINSRDAD1] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [FLDINSRDAD2] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [FLDINSRCITY] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [FLDINSRDST] [varchar] (2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [FLDINSRDZIP] [varchar] (9) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [FLDINSRDSEX] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [FLDINSRDREL] [varchar] (6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [FLDINSRDPHN] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [FLDINSRDWPH] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [FLDINSURANC] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [FLDINSPOLNM] [varchar] (16) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [FLDEXCEXAM] [int] NULL , [FLDINSGROUP] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [FLD2NDINSR] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [FLDPAYCODE] [varchar] (6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [FLDSERVCODE] [varchar] (6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [FLDDOD_COMP] [varchar] (6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [FLDCIVGRADE] [varchar] (8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [FLDMAJCMND] [varchar] (12) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [FLDPERSTYPE] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [FLDIMPORTED] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [FLDFHWA] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [FLDFAA] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [FLDFRA] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [FLDFTA] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [FLDRSPA] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [FLDUSCG] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [FLDMAIDEN] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [FLDINSCAT] [varchar] (4) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [FLDBIRPLACE] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [FLDEMAIL] [varchar] (80) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [FLDRESTRBEG] [int] NULL , [FLDRESTREND] [int] NULL , [FLDRESTRRVD] [int] NULL , [FLDSALARY] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [FLDINSRSSN] [varchar] (9) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [FLDINSREMPL] [varchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [FLDINSREMAD] [varchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [FLDINSREMCT] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [FLDINSREMST] [varchar] (2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [FLDINSREMZP] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [FLDINSREMIC] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [FLDGUARPOLC] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [FLDDIVISION] [varchar] (12) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [FLDINSPLAN] [varchar] (12) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [FLDWHYRMEDR] [varchar] (6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [FLDSMOKSTAT] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [FLDLANGUAGE] [varchar] (2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [FLDCHARTLOC] [varchar] (6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [FLDCOUNTRY] [varchar] (6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [FLDRCNTRBFE] [datetime] NULL , [FLDSTATACTN] [varchar] (6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [FLDWKFRCGRP] [varchar] (6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [FLDWKFRCCAT] [varchar] (6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [FLDHROFFICE] [varchar] (8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [FLDREGION] [varchar] (12) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [FLDORGUNIT] [varchar] (12) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [FLDPLACEGRP] [varchar] (6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [FLDHMADCNTR] [varchar] (6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [FLDADDRDATE] [datetime] NULL , [FLDPOSTITLE] [varchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [FLDWORKGRP] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [FLDMEDRECNO] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [FLDEXPSFROM] [int] NULL , [FLDSMOKUPDT] [datetime] NULL , [FLDPACKDAY] [smallint] NULL , [FLDYEARSMOK] [smallint] NULL , [FLDNUMDEPND] [smallint] NULL , [FLDULNAME] [varchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [FLDUFNAME] [varchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [FLDADD3] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [FLDADD4] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [FLDID2] [varchar] (16) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [FLDID3] [varchar] (16) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [FLDSSNEND] [varchar] (4) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [FLDCOSTCTR] [varchar] (12) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [FLDDOD] [datetime] NULL , [FLDHIDENAME] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [FLDHCP] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , PRIMARY KEY CLUSTERED ( [FLDREC_NUM] ) WITH FILLFACTOR = 90 ON [PRIMARY] , CHECK ([FLDREC_NUM] > 0)) ON [PRIMARY]GO |
|
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2006-02-02 : 20:52:39
|
| anishap, you have to use the second DDL for your query but you will need to know how the 1st DDL (Vendor provided) is mapped to the actual table (2nd DDL).----------------------------------'KH' |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-02-03 : 12:45:13
|
| If FLDUSERSTR is the column that is receiving USERSTR, then your column is defined as an int. So what you are trying to input into it is not going to work.Tara Kizeraka tduggan |
|
|
|
|
|
|
|
|
Selecting rows from array