sp procedure error

Question

Post reply

sp procedure error

Frances L

SSCarpal Tunnel

Points: 4727
More actions
December 28, 2010 at 7:54 am

#157370

Here is my select statement generated scripted by sql
SELECT [HName]
,[EmplID]
,[AAGraduate]
,[MSNGraduate]
,[Diploma]
,[PhDGraduate]
,[BSNGraduate]
,[OtherEdu]
,[OtherEduGraduate]
,[BSNEduEnrollment]
,[PhDEduEnrollment]
,[MSNEduEnrollment]
,[OtherEduEnrollment]
,[CollegeEduEnrollment]
,[CollegialityPEMaterials]
,[CollegialityPJournal]
,[CollegialityOtherBrochures]
,[CollegialityBooks]
,[Mentoring]
,[Facultyposition]
,[AcademicInstitution]
,[CourseTitle]
,[FulljournalName]
,[FulljournalYear]
,[CSHealthFair]
,[CSBLS]
,[CSOutreachclinic]
,[CSHealthRelatedCommunityActivity]
,[CSCareerDay]
,[CSOther]
,[ReResearchJournalClub]
,[ReProduct]
,[ReClinical]
,[ProfileY]
,[Submitter]
,[SubmitTime]
FROM [InternalEduTest].[dbo].[NursingProfile]
[highlight=#ffff11]Msg 207, Level 16, State 1, Procedure SaveNursingProfile, Line 40
Invalid column name 'SubmittedTime'.[/highlight]
set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go
ALTER PROCEDURE [dbo].[SaveNursingProfile]
( @HName char (25) ,
@EmplID char (10) ,
@AAGraduate int =null ,
@MSNGraduate int =null,
@diploma int =null ,
@PhDGraduate int =null ,
@BSNGraduate int =null ,
@OtherEdu varchar (50)=null ,
@OtherEduGraduate int=null ,
@BSNEduEnrollment bit =null ,
@PhDEduEnrollment bit =null ,
@MSNEduEnrollment bit=null ,
@OtherEduEnrollment varchar (50) =null ,
@CollegeEduEnrollment varchar (50) =null ,
@CollegialityPEMaterials varchar (50) =null ,
@CollegialityPJournal varchar (50) =null ,
@CollegialityOtherBrochures varchar (50) =null ,
@CollegialityBooks varchar (50) =null ,
@Mentoring varchar (50) =null ,
@Facultyposition varchar (50) =null ,
@AcademicInstitution varchar (50) =null ,
@CourseTitle varchar (50) =null,
@FulljournalName varchar (50) =null ,
@FulljournalYear int=null ,
@CSHealthFair bit =null,
@CSBLS bit =null,
@CSOutreachclinic bit=null ,
@CSHealthRelatedCommunityActivity bit =null ,
@CSCareerDay bit =null,
@CSOther varchar (50) =null,
@ReResearchJournalClub varchar (50) =null ,
@ReProduct varchar (50) =null ,
@ReClinical varchar (50) =null ,
@ProfileY int,
@Submitter varchar(50),
@SubmitTime datetime
)
As
INSERT INTO [InternalEdu].[dbo].[NursingProfile]
([HName]
,[EmplID]
,[AAGraduate]
,[MSNGraduate]
,[Diploma]
,[PhDGraduate]
,[BSNGraduate]
,[OtherEdu]
,[OtherEduGraduate]
,[BSNEduEnrollment]
,[PhDEduEnrollment]
,[MSNEduEnrollment]
,[OtherEduEnrollment]
,[CollegeEduEnrollment]
,[CollegialityPEMaterials]
,[CollegialityPJournal]
,[CollegialityOtherBrochures]
,[CollegialityBooks]
,[Mentoring]
,[Facultyposition]
,[AcademicInstitution]
,[CourseTitle]
,[FulljournalName]
,[FulljournalYear]
,[CSHealthFair]
,[CSBLS]
,[CSOutreachclinic]
,[CSHealthRelatedCommunityActivity]
,[CSCareerDay]
,[CSOther]
,[ReResearchJournalClub]
,[ReProduct]
,[ReClinical]
,[ProfileY]
,[Submitter]
,SubmittedTime
)
VALUES (@HName
,@EmplID
,@AAGraduate
,@MSNGraduate
,@Diploma
,@PhDGraduate
,@BSNGraduate
,@OtherEdu
,@OtherEduGraduate
,@BSNEduEnrollment
,@PhDEduEnrollment
,@MSNEduEnrollment
,@OtherEduEnrollment
,@CollegeEduEnrollment
,@CollegialityPEMaterials
,@CollegialityPJournal
,@CollegialityOtherBrochures
,@CollegialityBooks
,@Mentoring
,@Facultyposition
,@AcademicInstitution
,@CourseTitle
,@FulljournalName
,@FulljournalYear
,@CSHealthFair
,@CSBLS
,@CSOutreachclinic
,@CSHealthRelatedCommunityActivity
,@CSCareerDay
,@CSOther
,@ReResearchJournalClub
,@ReProduct
,@ReClinical
,@ProfileY
,@Submitter
,@SubmitTime
)
Thanks.
Just a error I overlooked that it update the live site which the table does not have the column. Thx.

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

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

Steve Jones - SSC Editor SSC Guru Points: 734605 More actions · Answer 1

Steve Jones - SSC Editor

SSC Guru

Points: 734605

January 4, 2011 at 8:20 am

#1268994

Is there a question here?

Lowell SSC Guru Points: 323507 More actions · Answer 2

spelling error.

select statement gets SubmitTime,

but the update statement is using SubmittedTime

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!

Frances L SSCarpal Tunnel Points: 4727 More actions · Answer 3

I posted that question and found the solution myself. I tried to change the field name. it did not work. Thx.