Skip to Content
0
Former Member
Jul 18, 2008 at 05:52 AM

SQL Command and Table-valued Functions in SQL Server

745 Views

Hi,

From Crystal Reports 2008, I am trying to retrieve data from a table-valued function: fn_XXX(@a,@b,@c) which exists in SQL Server 2005 database. But to retrieve data from this table-valued function I have to pass the parameters @a, @b & @c from Crystal to SQL Server.

In SQL Command (Under Database Expert / Connections) I created parameters A, B, C and entered the following command

Declare @a, @b, @c

Set @a = A

Set @b = B

Set @c = C

Select * from fn_XXX(@a,@b,@c)

But no success. Would you please let me know what I am doing wrong?

Thanks,

Al