Solved

Need help with an error message

Posted on 2008-10-17
3
225 Views
Last Modified: 2012-05-05
Here is the output from my messages panel when I run this query.  When I double click on the error message, it would highlight the GO right before my Delete statement.  Can anyone see what's wrong here?
GO
DELETE FROM [CtsiMembershipProduction].[dbo].CtsiApplication
      WHERE [CtsiMembershipProduction].[dbo].CtsiApplication.Id IS NULL


(201 row(s) affected)

(205 row(s) affected)

(205 row(s) affected)

(224 row(s) affected)

(224 row(s) affected)

(221 row(s) affected)

(221 row(s) affected)

(493 row(s) affected)

(493 row(s) affected)

(431 row(s) affected)
Msg 207, Level 16, State 1, Line 0
Invalid column name 'Research Interest 1'.

--And now we're ready to put it all into one big table

SELECT a.Id

	,a.MembershipLevel

	,a.ProfessionalOrganizations

	,a.Department

	,a.Gender

	,a.Ethnicity

	,a.Race

	,a.YearOfBirth

	,a.Title_id

	,a.EmailAddress

	,a.LastName

	,a.Firstname

	,a.PhoneNumber

	,a.Institution

	,a.MailingAddress

	,a.OfficeAddress

	,a.TitleOther

	,a.PhdTraineeCount

	,a.MscTraineeCount

	,a.InstitutionOther

	,a.MembershipReasonOther

	,a.RaceOther

	,a.MailingAddressLine1

	,a.MailingAddressLine2

	,a.MailingAddressCity

	,a.MailingAddressState

	,a.MailingAddressZip

	,a.CommunityOrganization

	,C.[Degree 1]

	,D.[Membership Reason 1]

	,E.[Membership Service Requirement 1]

	,F.parentId as RchChildId--child Rch id

INTO CtsiApplication

	FROM dbo.Applications a 

		INNER JOIN dbo.Temp B on a.Id = B.tempId

		FULL JOIN dbo.CtsiDegree C on a.Id = C.ApplicationId

		FULL JOIN dbo.CtsiReasons D on a.Id = D.ApplicationId

		FULL JOIN dbo.CtsiRequirement E on a.Id = E.ApplicationId

		INNER JOIN dbo.CtsiRschInterest F on a.Id = F.ApplicationId

ORDER BY a.Id
 

GO

DELETE FROM [CtsiMembershipProduction].[dbo].CtsiApplication

      WHERE [CtsiMembershipProduction].[dbo].CtsiApplication.Id IS NULL
 

--some other code before this
 

--Add the 4 Interest fields

ALTER TABLE CtsiApplication ADD [Research Interest 1] VARCHAR(50)

ALTER TABLE CtsiApplication ADD [Research Interest 2] VARCHAR(50)

ALTER TABLE CtsiApplication ADD [Research Interest 3] VARCHAR(50)

ALTER TABLE CtsiApplication ADD [Research Interest 4] VARCHAR(50)

Open in new window

0
Comment
Question by:lapucca
  • 2
3 Comments
 
LVL 59

Expert Comment

by:Kevin Cross
ID: 22740965
Try running your different pieces of code separate and see if error is really with DELETE statement or not.

Try adding a GO statement underneath the DELETE statement as well.  This will allow the rest of the code to run even if there is an error here, again so you can verify what is really not working.
0
 

Author Comment

by:lapucca
ID: 22745464
Yes, I removed the Delete code and the code is now running.  I still Can't see that would cause the error though.
0
 
LVL 59

Accepted Solution

by:
Kevin Cross earned 500 total points
ID: 22746876
Did you run the delete code by itself?  Do you get the error?

If you did and you don't get the error, did you try adding GO after the DELETE statement in code above?
0

Featured Post

DevOps Toolchain Recommendations

Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
PL/SQL LOOP CURSOR 3 58
MSSQL 2014 Query Synthax 8 47
Create A query for disabled users 5 30
SQL Query Syntax Join 4 33
In database programming, custom sort order seems to be necessary quite often, at least in my experience and time here at EE. Within the realm of custom sorting is the sorting of numbers and text independently (i.e., treating the numbers as number…
PL/SQL can be a very powerful tool for working directly with database tables. Being able to loop will allow you to perform more complex operations, but can be a little tricky to write correctly. This article will provide examples of basic loops alon…
This tutorial gives a high-level tour of the interface of Marketo (a marketing automation tool to help businesses track and engage prospective customers and drive them to purchase). You will see the main areas including Marketing Activities, Design …
As a trusted technology advisor to your customers you are likely getting the daily question of, ‘should I put this in the cloud?’ As customer demands for cloud services increases, companies will see a shift from traditional buying patterns to new…

910 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

25 Experts available now in Live!

Get 1:1 Help Now