The revolutionary project management tool is here! Plan visually with a single glance and make sure your projects get done.
When I execute it:
ALTER PROCEDURE dxf1s_qqq.Getup_GetFriends -- Add the parameters for the stored procedure here @FriendListID varchar(max), @FacebookID bigint OUTPUT, @CurrentL float OUTPUT, @CurrentP float OUTPUT, @CurrentU int OUTPUT, @Created datetime OUTPUT AS -- SET NOCOUNT ON added to prevent extra result sets from -- interfering with SELECT statements. SET NOCOUNT ON; BEGIN SELECT @FacebookID = FacebookID, @CurrentL = CurrentL, @CurrentP = CurrentP, @CurrentU = CurrentU, @Created = Created FROM Getup_Log.SplitInts(@FriendListID, ','); RETURN END
I get null when I execute it, and I do have a data inside my table with these two FacebookID's
Running [dxf1s_qqq].[Getup_GetFriends] ( @FriendListID = 3391443009,3391443008, @FacebookID = <DEFAULT>, @CurrentL = <DEFAULT>, @CurrentP = <DEFAULT>, @CurrentU = <DEFAULT>, @Created = <DEFAULT> ). Procedure or function 'Getup_GetFriends' expects parameter '@FacebookID', which was not supplied. No rows affected. (0 row(s) returned) @FacebookID = <NULL> @CurrentL = <NULL> @CurrentP = <NULL> @CurrentU = <NULL> @Created = <NULL> @RETURN_VALUE = Finished running [dxf1s_qqq].[Getup_GetFriends].
Join the community of 500,000 technology professionals and ask your questions.