tempali
سه شنبه 22 آذر 1390, 09:25 صبح
سلام من یک فانکشن نوشتم زمانی که می خوام ذخیره کنم خطای 170 میده
CREATE FUNCTION [dbo].[kaf] (@e varchar(3))
RETURNS TABLE
AS
BEGIN
declare @x varchar(5000)
SELECT [_VIW_ONHAND_].* INTO ONHAND FROM [_VIW_ONHAND_]
set @x='select [part no] '
select @x=@x +', (select [total] from [ONHAND] where [part no]=s.[part no] and [customer id]='+
cast(max([customer id]) as varchar(10))+') as ['+cast(max([customer name]) as varchar(50))+']'
from [_customer_]
group by [customer id]
order by [customer id]
set @x=@x+' from [ONHAND] as s
group by [part no],[supplier name],[part main id]
order by [supplier name],[part main id]'
exec(@x)
return(select * from onhand)
END
لطفا کمکم کنید . تو اینترنت هم سرچ کردم ولی نتیجه ای نگرفتم
CREATE FUNCTION [dbo].[kaf] (@e varchar(3))
RETURNS TABLE
AS
BEGIN
declare @x varchar(5000)
SELECT [_VIW_ONHAND_].* INTO ONHAND FROM [_VIW_ONHAND_]
set @x='select [part no] '
select @x=@x +', (select [total] from [ONHAND] where [part no]=s.[part no] and [customer id]='+
cast(max([customer id]) as varchar(10))+') as ['+cast(max([customer name]) as varchar(50))+']'
from [_customer_]
group by [customer id]
order by [customer id]
set @x=@x+' from [ONHAND] as s
group by [part no],[supplier name],[part main id]
order by [supplier name],[part main id]'
exec(@x)
return(select * from onhand)
END
لطفا کمکم کنید . تو اینترنت هم سرچ کردم ولی نتیجه ای نگرفتم