The Shed is going Social! Join us on FaceBook and Twitter and chime in on the conversation.
|
 |
|
Dev Shed Forums
> Databases
> MS SQL Development
|
SQL statement with 2 parameters
Discuss SQL statement with 2 parameters in the MS SQL Development forum on Dev Shed. SQL statement with 2 parameters MS SQL Development forum discussing administration, MS SQL queries, and other MS SQL-related topics. SQL Server is Microsoft's enterprise database engine.
|
|
 |
|
|
|
|

Dev Shed Forums Sponsor:
|
|
|

September 15th, 2003, 06:45 PM
|
|
Junior Member
|
|
Join Date: Sep 2003
Location: Minnesota
Posts: 2
Time spent in forums: < 1 sec
Reputation Power: 0
|
|
|
SQL statement with 2 parameters
I'm making a query for a database and want to have 2 having parameters. this first one works but can't get the second one to.
SELECT Alum.LastName, Alum.FirstName, Alum.Street, Alum.City, Alum.State, Alum.Zipcode, Alum.Country, Alum.Phone, Alum.Email, Alum.Employer, Alum.Title, Alum.WhenGraduated, Alum.DateUpdated, Alum.InitiateNumber, Alum.CompName
FROM Alum
GROUP BY Alum.LastName, Alum.FirstName, Alum.Street, Alum.City, Alum.State, Alum.Zipcode, Alum.Country, Alum.Phone, Alum.Email, Alum.Employer, Alum.Title, Alum.WhenGraduated, Alum.DateUpdated, Alum.InitiateNumber, Alum.CompName
HAVING (((Alum.InitiateNumber)='::inum::'));
I would like to include Alum.FirstName='::fname::' in the having parameter but it keeps giving me an error. What I'm doing is having the two parameters query a database table and where the 2 equal what is entered, return the data from the record.
Any suggestions??!!
Thank you.
|

September 29th, 2003, 11:26 AM
|
 |
Digitally Challenged
|
|
Join Date: May 2003
Posts: 280
Time spent in forums: 54 m 14 sec
Reputation Power: 11
|
|
instead of using HAVING you should be using WHERE because you aren't using a group by clause. so it should look something like this
Code:
SELECT Alum.LastName, Alum.FirstName, Alum.Street, Alum.City, Alum.State, Alum.Zipcode, Alum.Country, Alum.Phone, Alum.Email, Alum.Employer, Alum.Title, Alum.WhenGraduated, Alum.DateUpdated, Alum.InitiateNumber, Alum.CompName
FROM Alum
GROUP BY Alum.LastName, Alum.FirstName, Alum.Street, Alum.City, Alum.State, Alum.Zipcode, Alum.Country, Alum.Phone, Alum.Email, Alum.Employer, Alum.Title, Alum.WhenGraduated, Alum.DateUpdated, Alum.InitiateNumber, Alum.CompName
WHERE Alum.InitiateNumber = 1;
the '1' is just the example number i used. if you want it related to a specific number you'll have to tell me what language you are using to display the data. hope that helps
__________________
My brain cells are like a storm trooper's armor: useless
|

September 29th, 2003, 05:38 PM
|
|
Junior Member
|
|
Join Date: Sep 2003
Location: Minnesota
Posts: 2
Time spent in forums: < 1 sec
Reputation Power: 0
|
|
|
Thank you, that makes more sense than the way I had it!!
|

September 29th, 2003, 08:44 PM
|
 |
SQL Consultant
|
|
Join Date: Feb 2003
Location: Toronto Canada
|
|
except that you cannot put WHERE after GROUP BY!!
furthermore, if you aren't going to use any aggregate functions, then you might as well drop the GROUP BY and use DISTINCT instead
rudy
http://r937.com/
|
Developer Shed Advertisers and Affiliates
| Thread Tools |
Search this Thread |
|
|
|
| Display Modes |
Rate This Thread |
Linear Mode
|
|
Posting Rules
|
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
HTML code is Off
|
|
|
|
|