Stored Procedure Moron

Results 1 to 3 of 3

Thread: Stored Procedure Moron

  1. #1
    Join Date
    Dec 1969

    Default Stored Procedure Moron

    I have been trying to call a Stored Procedure from and now I think the problem may have been with my Stored Procedure.<BR><BR>Here is the procedure:<BR><BR>ALTER PROCEDURE dbo.NavigationOld<BR>(<BR>@GroupName varChar,<BR>@Result Int OUTPUT<BR>)<BR>As<BR><BR>Select @Result = Count(groupname)<BR>FROM [Group]<BR>WHERE(GroupName = @GroupName) and (GroupAccessOutlook = 1)<BR><BR>When I call the procedure it says it needs the @Result value passed to it. But I want that to be the output value that is passed back to me.<BR><BR>What am I doing wrong?<BR><BR>Chris Messineo

  2. #2

    Default RE: Stored Procedure Moron

    @Result Int=0 OUTPUT

  3. #3
    Join Date
    Dec 1969
    Indianapolis, IN

    Default RE: Stored Procedure Moron

    Try this:<BR><BR>DECLARE @myresult INT<BR>NavigationOld(&#039;Blahblah&#039;, @myresult OUTPUT)<BR><BR>SELECT @myresult

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts