帮忙看看我这存储过程有什么问题?谢谢!

[freegoal]

存储过程为:
CREATE PROCEDURE [dbo].[pr_getParentLots]
@var1 nvarchar(4000),
@var2 int
AS

SELECT LotNumber,COUNT(SerialNumber) FROM tbSerialNumber WHERE SerialNumber IN (@var1) GROUP BY LotNumber

GO

以下是调用这个存储过程(但是没有正确结果返回):
DECLARE @RC int
DECLARE @var1 nvarchar(4000)
DECLARE @var2 int
SELECT @var1 = N'''0544F1507'',''0544F1455'',''0544F1448'',''0544F1361'',''0544F1348'',''0544F1260'''
SELECT @var2 = 6
EXEC @RC = [eplist].[dbo].[pr_getParentLots] @var1, @var2
DECLARE @PrnLine nvarchar(4000)
PRINT 'Stored Procedure: eplist.dbo.pr_getParentLots'
SELECT @PrnLine = ' Return Code = ' + CONVERT(nvarchar, @RC)
PRINT @PrnLine
不知道为什么没有返回结果?

如果我直接执行以下SQL语句，它是有结果返回的：
SELECT LotNumber, COUNT(SerialNumber) AS Expr1
FROM dbo.tbSerialNumber
WHERE (SerialNumber IN ('0544F1507', '0544F1455', '0544F1448', '0544F1361',
'0544F1348', '0544F1260'))
GROUP BY LotNumber


哪位能够帮我看看哪里出了问题？谢谢！

[lw1a2]

你那个@var2是干吗的，要返回多少行不是这么做的

[winternet]

SELECT LotNumber,COUNT(SerialNumber) FROM tbSerialNumber WHERE SerialNumber IN (@var1) GROUP BY LotNumber

----->
exec ('SELECT LotNumber,COUNT(SerialNumber) FROM tbSerialNumber WHERE SerialNumber IN ('+@var1+') GROUP BY LotNumber')

[freegoal]

to winternet(冬天):
我实际上是向将查询结果插入到一个表变量中，如下：
declare @LotList table(LotNumber nvarchar(50),sncount int)
insert into @LotList
SELECT LotNumber,COUNT(SerialNumber) FROM tbSerialNumber WHERE SerialNumber IN (@var1) GROUP BY LotNumber

如果用exec就不能直接插入表变量中啦，有什么好办法吗？
另外，我上面的语句在语法检查时没有出错，为什么就不起作用呢？谢谢！

[pbsql]

CREATE PROCEDURE [dbo].[pr_getParentLots]
@var1 nvarchar(4000),
@var2 int
AS
exec ('SELECT LotNumber,COUNT(SerialNumber) FROM tbSerialNumber WHERE SerialNumber IN ('+@var1+') GROUP BY LotNumber')
GO
--调用：
create table #LotList(LotNumber nvarchar(50),sncount int)
insert into #LotList
exec pr_getParentLots N'''0544F1507'',''0544F1455'',''0544F1448'',''0544F1361'',''0544F1348'',''0544F1260''',6
declare @LotList table(LotNumber nvarchar(50),sncount int)
insert into @LotList select * from #LotList
select * from @LotList
drop table #LotList

[浩方软件HFWMS]

有点乱

[ljian_mail]

应该用动态sql

[zsyp]

你用insert 临时表 exec 存储过程
这样的语句试试

[新鲜鱼排]

DECLARE @var1 nvarchar(4000)
set @var1 = N'''0544F1507'',''0544F1455'',''0544F1448'',''0544F1361'',''0544F1348'',''0544F1260'''
exec ('SELECT LotNumber,COUNT(SerialNumber) FROM tbSerialNumber WHERE SerialNumber IN ('+@var1+') GROUP BY LotNumber')