v_price_row := get_price_row(pos.global_product_id,v_legal_entity,pos.master_margin_center,in_data_status); 
  v_product_row := get_product_row(pos.global_product_id, v_legal_entity, pos.master_margin_center, 'O'); 

CREATE FUNCTION LargeOrderShippers ( @FreightParm money )
RETURNS @OrderShipperTab TABLE
   (
    ShipperID     int,
    ShipperName   nvarchar(80),
    OrderID       int,
    ShippedDate   datetime,
    Freight       money
   )
AS
BEGIN
   INSERT @OrderShipperTab
        SELECT S.ShipperID, S.CompanyName,
               O.OrderID, O.ShippedDate, O.Freight
        FROM Shippers AS S INNER JOIN Orders AS O
              ON S.ShipperID = O.ShipVia
        WHERE O.Freight > @FreightParm
   RETURN
END

quote:

---

Are you
attempting some sort of procedural row-by-row processing? If so, maybe there
is a set-based solution that avoids the need for this. Please describe your
requirements

---

-- Create New Type
IF NOT EXISTS 
(
	SELECT * 
	FROM sys.types st 
	JOIN sys.schemas ss 
	ON st.schema_id = ss.schema_id 
	WHERE st.name = N'OrderShipperTableType' 
	AND ss.name = N'dbo'
)
CREATE TYPE dbo.OrderShipperTableType AS TABLE
(
    ShipperID     int,
    ShipperName   nvarchar(80),
    OrderID       int,
    ShippedDate   datetime,
    Freight       money
)
GO

-- Declare and User new type
DECLARE @MyTab dbo.OrderShipperTableType

-- Can insert all or jsut one row from the fucntion
INSERT @MyTab
SELECT TOP 1 * FROM dbo.LargeOrderShippers($100.00)

-- Insert stored procedure call here, passing @MyTab

--DROP TYPE dbo.MyTableType