Need help for stored procedure.

ASP Free Forums Sponsor:

November 21st, 2004, 02:34 PM

rainbow11

Contributing User

Join Date: Aug 2004

Location: Canada

Posts: 132

Time spent in forums: 13 h 34 m 9 sec
Reputation Power: 5

Need help for stored procedure.

Hi All,
I have two tables
1) bedType table

bedTypeID, bedType
---
1 , king
2, queen
3 , single
4 , double
---

2) room_bedType table( this is junction table between bedType and room table)

roomID, bedTypeID
---
3 , 1
3, 2
4 , 2
4 , 3
---

I need to make a following stored procedure
Select all bedType from bedType table, but not those are in second table room_bedType and roomID is equal to 3

Any idea how to do this.
Thanks in advance for your help
Rainbow11

November 21st, 2004, 04:17 PM

Memnoch

Unholy Moderator

ASP Free God 14th Plane (11500 - 11999 posts)

Join Date: Oct 2003

Location: In hell, where did you think?

Posts: 11,770

Time spent in forums: 3 Weeks 5 Days 7 h 4 m 39 sec
Reputation Power: 469

Something like this?

Code:

Create Procedure stp_GetBedType
   @RoomID As int
AS
SELECT *
FROM BedType 
WHERE BedTypeID NOT IN
(
   SELECT DISTINCT BedTypeID
   FROM Room_BedType
   WHERE RoomID = @RoomID
)

Last edited by Memnoch : November 21st, 2004 at 04:20 PM.

November 23rd, 2004, 10:44 PM

rainbow11

Contributing User

Join Date: Aug 2004

Location: Canada

Posts: 132

Time spent in forums: 13 h 34 m 9 sec
Reputation Power: 5

Quote:

Originally Posted by Memnoch

Something like this?

Code:

Create Procedure stp_GetBedType
@RoomID As int
AS
SELECT *
FROM BedType 
WHERE BedTypeID NOT IN
(
SELECT DISTINCT BedTypeID
FROM Room_BedType
WHERE RoomID = @RoomID
)

thanks it works.
thanks again for your time and reply.
rainbow11

Viewing: ASP Free Forums > Database > Microsoft SQL Server > Need help for stored procedure.

« Previous Thread | Next Thread »

Thread Tools	Search this Thread
Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode	Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts vB code is On Smilies are On [IMG] code is On HTML code is Off

View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox

Forum Jump