27,579
社区成员
发帖
与我相关
我的任务
分享
select
VC_UI_CODE
,''
,VC_MT_NAME
,''
,VC_MT_NAME
,I_FM_DECIMAL
,VC_MI_DIRECTION
,''
,VC_MI_CARDNO
,''
,VC_MT_METERSET
,I_MI_SALECOUNT
,'' --表值函数返回值1
,'' --表值函数返回值2
,D_UI_CREATEDATE
,VC_O_NAME
,''
,[GUID]
from
View_2
select * from aa(View.Guid,'',1,0,0)
declare @guid varchar(50)
declare @i int
declare @a1 int
declare @a2 int
set @i=0
while (@i<=28038)
begin
select @guid=[guid] from CSVTable where id=@i
select @a1=a1,@a2=a2 from aa(@guid,'',1,0,0)
update CSVTable set a1=@a1,a2=@a2 where id=@i
set @i=@i+1
end
select
VC_UI_CODE
,''
,VC_MT_NAME
,''
,VC_MT_NAME
,I_FM_DECIMAL
,VC_MI_DIRECTION
,''
,VC_MI_CARDNO
,''
,VC_MT_METERSET
,I_MI_SALECOUNT
,b.a1
,b.a2
,D_UI_CREATEDATE
,VC_O_NAME
,''
,[GUID]
from View_2 a
outer apply dbo.aa(a.Guid,'',1,0,0) b
select
VC_UI_CODE
,''
,VC_MT_NAME
,''
,VC_MT_NAME
,I_FM_DECIMAL
,VC_MI_DIRECTION
,''
,VC_MI_CARDNO
,''
,VC_MT_METERSET
,I_MI_SALECOUNT
,b.a1
,b.a2
,D_UI_CREATEDATE
,VC_O_NAME
,''
,[GUID]
from View_2 a
outer apply aa(a.Guid,'',1,0,0) b
select
a.VC_UI_CODE
,''
,a.VC_MT_NAME
,''
,a.VC_MT_NAME
,a.I_FM_DECIMAL
,a.VC_MI_DIRECTION
,''
,a.VC_MI_CARDNO
,''
,a.VC_MT_METERSET
,a.I_MI_SALECOUNT
,b.字段名1 --表值函数返回值1 --> 自行填入字段名
,b.字段名2 --表值函数返回值2 --> 自行填入字段名
,a.D_UI_CREATEDATE
,a.VC_O_NAME
,''
,a.[GUID]
from View_2 a
outer apply aa(a.Guid,'',1,0,0) b
select * from aa(View_2.Guid,'',1,0,0)
表值函数写漏了。。。