Database error with SQL Server 2008 R2

Question

0.00/5 (No votes)

See more:

Hi all

Here's my stored procedure for a select statement

SQL

CREATE PROCEDURE [dbo].[uspStudentEquipment]
@studentNumber nvarchar (50)
AS
BEGIN
	SELECT EquipmentName,EquipmentModel,Description,[Equipment Type Id],DateInRoom,TimeInRoom
	FROM Equipment 
	WHERE Equipment.StudentNumber = Student.StudentNumber AND Equipment.StudentNumber=@studentNumber
END
GO

-When I execute this stored procedure i get this error message:

Msg 4104, Level 16, State 1, Procedure uspStudentEquipment, Line 12
The multi-part identifier "Student.StudentNumber" could not be bound.

I am not too sure what this error means. Could anyone please help?
Thanks

Posted 6-Sep-13 4:24am

zikhona nkebe

Updated 6-Sep-13 4:27am

ridoy

v3

Add a Solution

Comments

TryAndSucceed 6-Sep-13 10:33am

I think you need to add Student table beside your equipment table i.e.
From Equipement, Student

3 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

thatraja · Answer 1 · 2013-09-06T04:31:00

Solution 1

You forgot to add the table Student in your query.

SQL

SELECT EquipmentName,EquipmentModel,Description,[Equipment Type Id],DateInRoom,TimeInRoom
    FROM Equipment, Student    WHERE Equipment.StudentNumber = Student.StudentNumber AND Equipment.StudentNumber=@studentNumber

Posted 6-Sep-13 4:31am

thatraja

Updated 6-Sep-13 4:32am

v2

Comments

phil.o 6-Sep-13 12:32pm

See my comment to solution 2 :)

Gitanjali Singh · Answer 2 · 2013-09-06T04:31:00

Solution 2

SQL

CREATE PROCEDURE [dbo].[uspStudentEquipment]
@studentNumber nvarchar (50)
AS
BEGIN
    SELECT EquipmentName,EquipmentModel,Description,[Equipment Type Id],DateInRoom,TimeInRoom
    FROM Equipment
    WHERE Equipment.StudentNumber=@studentNumber
END
GO

try this

Posted 6-Sep-13 4:31am

Gitanjali Singh

Comments

thatraja 6-Sep-13 10:33am

why(did you remove that criteria)? He needs the join to fetch matching records.

Gitanjali Singh 6-Sep-13 10:36am

that is not join.

thatraja 6-Sep-13 10:40am

then what?

phil.o 6-Sep-13 12:27pm

He's right, that is no join.
No column of Student table is included in SELECT clause ; so there is no point to join both tables. The condition is here managed with the variable @studentNumber.
I upvoted the solution, because we cannot say this procedure is incorrect with what the OP has given to us.

Mubin M. Shaikh · Answer 3 · 2013-09-09T01:53:00

Hi,

You can go for this, it will solve your requirement

SQL

CREATE PROCEDURE [dbo].[uspStudentEquipment]
@studentNumber nvarchar (50)
AS
BEGIN
	select * from (SELECT EquipmentName,EquipmentModel,Description,[Equipment Type Id],DateInRoom,TimeInRoom
	FROM Equipment,student
	WHERE Equipment.StudentNumber = Student.StudentNumber 
	)as x where  x.StudentNumber=@studentNumber
END
GO

Regards
Mubin

Database error with SQL Server 2008 R2

3 solutions

Solution 1

Solution 2

Solution 3

Add your solution here

Preview 0

Existing Members

...or Join us