InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comThu, 23 May 2013 12:33:23 GMT20http://www.sqlservercentral.com/Forums/Topic1406482-392-1.aspxHello Lynn PettisYes, you are right i forget my parameters (bostamp,ref,cor)Thanks for your replyLuis SantosSun, 13 Jan 2013 10:35:01 GMTluissantoshttp://www.sqlservercentral.com/Forums/Topic1406482-392-1.aspx[quote][b]luissantos (1/13/2013)[/b][hr]Hello comunityI have create this function to return total pairs:CREATE FUNCTION [dbo].[fnQtRefCor](@bostamp varchar(25), @ref varchar(20), @cor varchar(50))RETURNS intASBEGIN DECLARE @retval int SELECT @retval = SUM(qtt) FROM bi WHERE @bostamp = bostamp AND @ref = ref AND @cor = cor and bi.ref <> '' SET @retval = ISNULL(@retval, 0) RETURN @retvalENDIf i run this query:SELECT SUM(qtt) FROM bi WHERE bostamp = 'jm13010767476,323000001' AND ref = '2120910'and (bi.ref <> '')group by bi.bostamp,ref,corI obtain the correct value of : 24 if i run this select to test the result :select [dbo].[fnQtRefCor] from bi where bi.bostamp = 'jm13010767476,323000001 'This error appear :Msg 4104, Level 16, State 1, Line 1The multi-part identifier "dbo.fnQtRefCor" could not be bound.I can run this SELECT without error ?Many thanks,Luis Santos[/quote]One thing I see is that you aren't passing in any parameters to the function.Try the following with the proper values for the parameters.select [dbo].[fnQtRefCor](@bostamp = ??, @ref = ??, @cor= ??);Sun, 13 Jan 2013 10:28:41 GMTLynn Pettishttp://www.sqlservercentral.com/Forums/Topic1406482-392-1.aspxSorry, i forget to mencioned that the compatibility level is :SQL SERVER 2000 (80)Maybe the problem is here ??ThanksSun, 13 Jan 2013 10:05:44 GMTluissantoshttp://www.sqlservercentral.com/Forums/Topic1406482-392-1.aspxHello comunityI have create this function to return total pairs:CREATE FUNCTION [dbo].[fnQtRefCor](@bostamp varchar(25), @ref varchar(20), @cor varchar(50))RETURNS intASBEGIN DECLARE @retval int SELECT @retval = SUM(qtt) FROM bi WHERE @bostamp = bostamp AND @ref = ref AND @cor = cor and bi.ref <> '' SET @retval = ISNULL(@retval, 0) RETURN @retvalENDIf i run this query:SELECT SUM(qtt) FROM bi WHERE bostamp = 'jm13010767476,323000001' AND ref = '2120910'and (bi.ref <> '')group by bi.bostamp,ref,corI obtain the correct value of : 24 if i run this select to test the result :select [dbo].[fnQtRefCor] from bi where bi.bostamp = 'jm13010767476,323000001 'This error appear :Msg 4104, Level 16, State 1, Line 1The multi-part identifier "dbo.fnQtRefCor" could not be bound.I can run this SELECT without error ?Many thanks,Luis SantosSun, 13 Jan 2013 10:02:42 GMTluissantos