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 |
|
jgrant
Yak Posting Veteran
69 Posts |
 Posted - 2007-08-26 : 02:33:34
|
| For some reason this procedure is expecting @short_desc as an input even though I listed it as output. Can someone help me with this?alter proc dbo.Edit_Equipment(@EquipmentId bigint, @short_desc nvarchar(20) output, @long_desc nvarchar(50) output, @Owned nvarchar(3) output, @Job_rate money output, @Job_cost money output)asSelect @short_desc = txt_short_desc, @long_desc = txt_full_desc, @owned = txt_owed, @Job_rate = txt_price, @Job_cost = txt_costfrom equipment_table where int_equipment_id = @equipmentIdThe Yak Village Idiot |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-08-26 : 12:14:35
|
| What is the error and where are you getting the error? Show us the code that is executing the stored procedure to get the error.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
 |
|
|
jgrant
Yak Posting Veteran
69 Posts |
Posted - 2007-09-01 : 19:17:08
|
| I was able to figure this one out. Trying to learn to many languages at the same time and I had a syntax error. I earned "idiot" this time.The Yak Village Idiot |
|
|
|
|
|
|
sp outputs error