SP

filipczako · #1 (**permalink**) December 9th, 2005, 08:54 AM

I use UDF in my stored procedure:

CREATE PROC [dbo].[alg_mainSP] AS SELECT P1 * P1 AS [COL1], P1 * P1 AS [COL2], P1 * [u]dbo.do1_g ( S1 ) AS [COL3]</u> FROM testowa;

P1 and S1 are columns of course.

and some of Udf have "_" char in his name (like do_1g UDF in COL3) and i think this causes this error how to solve that problem ?

thanx for help

jbenson001 · #2 (**permalink**) December 9th, 2005, 02:22 PM

check the value in the UDF. If it contains characters, return 0.

filipczako · #3 (**permalink**) December 12th, 2005, 03:50 AM

Quote:

quote:Originally posted by jbenson001
check the value in the UDF. If it contains characters, return 0.

i dont know if u understand me...:)
i have _ char in UDF name and i wonder if that causes problem with executing SP which uses this UDF ...

jbenson001 · #4 (**permalink**) December 12th, 2005, 10:50 AM

What is the error you are getting

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
[Resolved] Error calling a sp - parameter error	snufse	.NET Framework 2.0	2	February 12th, 2008 04:46 PM
selecting rows returned by executing a SP	dsekar_nat	SQL Server 2000	4	May 11th, 2006 11:12 AM
SP executing time on progressBar control	filipczako	ADO.NET	0	November 29th, 2005 06:48 PM
Executing a SP for each recordset of a Table	anandham	SQL Server 2000	1	October 19th, 2005 06:34 PM
Executing DTS package from ASP page via SP	savoym	Classic ASP Basics	0	April 28th, 2005 07:02 AM