luissantos (1/13/2013)

---

Hello comunity

I have create this function to return total pairs:

CREATE FUNCTION [dbo].[fnQtRefCor]

(@bostamp varchar(25), @ref varchar(20), @cor varchar(50))

RETURNS int

AS

BEGIN

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 @retval

END

If i run this query:

SELECT SUM(qtt) FROM bi

WHERE bostamp = 'jm13010767476,323000001' AND ref = '2120910'

and (bi.ref <> '')

group by bi.bostamp,ref,cor

I 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 1

The multi-part identifier "dbo.fnQtRefCor" could not be bound.

I can run this SELECT without error ?

Many thanks,

Luis Santos