Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2006-10-20 : 07:59:11
|
| elen writes "i want to create a SP with thisselect A1,max(A2),max(A3)from Agroup by A1and the SP will return the resultcan i ?need this a.s.s.pthanks" |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2006-10-20 : 08:01:03
|
Well, crap, this is gonna take a good bit of effort:create procedure myProc asselect A1,max(A2),max(A3)from Agroup by A1Whew! Man, good thing I looked that up in Books Online, I never would have figured it out.This message was brought to you by the letter A, G, and sarcasm.  |
 |
|
|
DonAtWork
Master Smack Fu Yak Hacker
2167 Posts |
Posted - 2006-10-20 : 13:20:11
|
naughty, NAUGHTY Rob.CREATE PROCEDURE dbo.myProc as ..... [Signature]For fast help, follow this link:http://weblogs.sqlteam.com/brettk/archive/2005/05/25.aspxLearn SQLhttp://www.sql-tutorial.net/ http://www.firstsql.com/tutor.htm http://www.w3schools.com/sql/default.asp |
|
|
|
|
|
|
CREATE PROCEDURE