Post reply

Invalid column name EE0_Classification

  • March 11, 2009 at 10:41 am

    #97360

    CREATE TABLE Job (

    EEO_Classification VARCHAR(60)NOT NULL ,

    Job_title VARCHAR(50) NOT NULL PRIMARY KEY,

    Job_description VARCHAR(1000) NULL,

    Exemption_Status VARCHAR(20) NOT NULL );

    INSERT INTO Job (EE0_Classification, Job_title, Job_description, Exemption_Status)

    SELECT 'Office/Clerical','Accounting Clerk','Computes, classifies, records, and

    verifies numerical data for use in maintaining accounting records','Non-exempt'

    UNION ALL

    SELECT 'Officials & Managers','Asst. Manager','Supervises and coordinates activities

    of workers in department of food store. Assists store manager in daily operations of

    store','Exempt'

    UNION ALL

    SELECT 'Sales Workers','Bagger','Places customer orders in bags. Performs carryout

    duties for customers','Non-exempt'

    UNION ALL

    SELECT 'Sales Workers','Cashier','Operates cash register to itemize and total

    customers purchases in grocery store.','Non-exempt'

    UNION ALL

    SELECT 'Technician','Computer Support Specialist','Installs, modifies, and makes minor

    repairs to personal computer hardware and software systems and provides technical

    assistance and training to system users','Non-exempt'

    UNION ALL

    SELECT 'Officials & Managers','Director of Finance & Accounting','Plans and directs the

    finance and accounting activities for Kudler Fine Foods.','Exempt'

    UNION ALL

    SELECT 'Craft Workers(skilled)','Retail Asst. Bakery & Pastry','Obtains or prepares

    food items requested by customers in retail food store.','Non-exempt'

    UNION ALL

    SELECT 'Craft Workers(skilled)','Retail Asst. Butchers and Seafood Specialists','Obtains

    or prepares food items requested by customers in retail food store.','Non-exempt'

    UNION ALL

    SELECT 'Office/Clerical','Stocker','Stores, prices, and restocks merchandise displays

    in store','Non-exempt'

    Any help is greatly appreciated as I am just starting a SQL SERVER class.

  • March 11, 2009 at 10:53 am

    #957678

    it's not obvious, but the table definition says 'eeo'_Classification, but the insert is 'ee0'_Classification

    so the chars look the same, but the "O" is not the same character "0" in both places.

    EEO_Classification

    EE0_Classification

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • March 11, 2009 at 10:56 am

    #957683

    You've got to be kidding me!!! I've gone over this thing with a magnifying glass and it was something that simple.....

    Thanks man, I appreciate it!!

    Michael

  • March 11, 2009 at 11:29 am

    #957734

    it's always the little things that cost the largest amounts of time; I've gotten zapped like that when i was playing in case sensitive databases.

    an extra pair of eyes helps in those moments.

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply