34,590
社区成员
发帖
与我相关
我的任务
分享
declare @License_Num int --用户数
declare @User_No int --用户编号
declare @User_No_TMP int --用户编号TMP
declare @License_No varchar(128) --License序列号
declare @Entp_ID varchar(50)
declare @UName varchar(50)
declare @License_Count int
set @License_Num=12
set @UName= 'yanxr '
set @Entp_ID= '10000000001 '
declare @str varchar(8000)
set @str='SELECT '+ @User_No_TMP+'=User_No FROM Tab_UserInfor WHERE User_No='+@UName
select @str=@str+' AND User_No IN(SELECT TOP '+ @License_Num+' User_No FROM Tab_UserInfor WHERE Entp_ID='+@Entp_ID+')'
exec(@str)
SELECT @User_No_TMP=User_No FROM Tab_UserInfor WHERE User_No=@UName AND User_No IN(SELECT TOP @License_Num User_No FROM Tab_UserInfor WHERE Entp_ID=@Entp_ID)
declare @sql varchar(200)
set @sql='SELECT @User_No_TMP=User_No FROM Tab_UserInfor WHERE User_Name='''+@UName+''' AND User_No
IN(SELECT TOP '+ltrim(@License_Num)+' User_No FROM Tab_UserInfor WHERE Entp_ID='''+@Entp_ID+''''
exec sp_executesql @sql,'@User_No_Tmp int output',@User_No_Tmp output