asked on December 1, 2014
I code a stored procedure reason for return count of rows from a table.
Here is my code.
USE [MTechTables] GO /****** Object: StoredProcedure [dbo].[sp_PCVLimitbyAccount] Script Date: 12/01/2014 15:01:59 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO ALTER PROCEDURE [dbo].[sp_PCVLimitbyAccount] @AccountName nvarchar(50) AS BEGIN Declare @myTable table ( [paramApprovedDate] nvarchar(12), [paramLimit] float, [paramAddupPoint] float, [paramCurrentLimit] float, [paramTempCurrentLimit] float, [paramApprovedName] nvarchar(100), [paramPosition] nvarchar(100), [paramAdminAmount] float, [paramAccountName] nvarchar(50), [paramComments] nvarchar(max), [paramFound] nvarchar(20) ) Declare @paramCount int Begin insert into @myTable select ApprovedDate,Limit,AddupPoint,CurrentLimit,TempCurrentLimit,ApprovedName,Position,AdminAmount,AccountName,Comments,N'มีข้อมูลแล้ว' from dbo.PCLimit where EditedDate = (select max(EditedDate) from PCLimit where AccountName = @AccountName) and AccountName = @AccountName; select * from @mytable select @paramCount = (select count(*) from @mytable) End END
The issue is when I refer to @paramCount in lookup rule page(in attached file) I couldn't receive the count of row as I wish.Any way no error appeared when executed this stored procedure.
I wonder How to refer to this parameter or did I miss something?
Thank you in advance.
0
0