So I cannot do that? Even if I use another table to store value or have you some idea?

Thanx

Hi,

the function is the following:

ALTER FUNCTION [dbo].[LI_Vista_RigheEvadibili_FiltrataFn]()

RETURNS @Results TABLE (Progr decimal(18,0),

codclifor varchar(7),

DOCTYPE varchar(3),

NUMDOC decimal(18,0),

AS

insert into @Results (Progr,codclifor ,DOCTYPE,

NUMDOC)

(select td.Progr,td.codclfor,

td.DOCTYPE,td.NUMDOC,

where extd.maglogisticaT=1 and

td.TIPODOC in ('AAA','BBB')

return

end

The td table is like:

ProgrYear...

yes correct...

I need to pass the codart value and retrive all rows related to this article saving them on a table

ferrarielly (7/28/2011)

---

what I need to do is:

receiving a codart from an external code..I need to do a select in 2 different table extracting the rows related to this specific codart..

The...

what I need to do is:

receiving a codart from an external code..I need to do a select in 2 different table extracting the rows related to this specific codart..

The result...

what you suggest? To create a "real" tale?

How can I check if my value are really written in my table?

I need to check the generated recordset

Thanx