看看这个字符串的问题在哪？我是怎么也调不通了！谢谢
use pubs
declare @chvSource sysname, --数据源
@chvCol sysname, --字段名
@intLen int, --字符串的宽度
@chrRetuCode varchar(20),
@chvExec nvarchar(2000)

set @chvSource = 'sales'
set @intLen = 4
set @chvCol = 'stor_id'

Select @chvExec = 'Select @chrRetuCode =
(CASE When Exists(Select * From ['+@chvSource+'] A Where A.['+@chvCol+'] = '''+REPLICATE('0',@intLen - 1) + '1'')
Then '''+REPLICATE('0',@intLen-LEN(Convert(varchar(20),Convert(int,MIN('['+@chvCol+']')) + 1))) + Convert(varchar(20),Convert(int,MIN('['+@chvCol+']')) + 1)+'''
Else '''+REPLICATE('0',@intLen - 1) + '1''
END)
From ['+@chvSource+']
Where Not ['+@chvCol+'] IN (Select REPLICATE(''0'',@intLen-LEN(Convert(varchar(20),Convert(bigint,B.['+@chvCol+']) - 1)))
From ['+@chvSource+'] B)'


--我想最后得到这样的效果，下面的可以运行
use pubs
declare @chvSource sysname, --数据源
@chvCol sysname, --字段名
@intLen int, --字符串的宽度
@chrRetuCode varchar(20),
@chvExec nvarchar(2000)

set @chvSource = 'sales'
set @intLen = 4
set @chvCol = 'stor_id'

Select (CASE When Exists(Select * From sales A Where A.stor_id = REPLICATE('0',@intLen - 1) + '1')
Then REPLICATE('0',@intLen-LEN(Convert(varchar(20),Convert(int,MIN(stor_id)) + 1))) + Convert(varchar(20),Convert(int,MIN(stor_id)) + 1)
Else REPLICATE('0',@intLen - 1) + '1'
END)
From sales
Where Not stor_id IN (Select REPLICATE('0',@intLen-LEN(Convert(varchar(20),Convert(int,B.stor_id) - 1)))
From sales B)

主要是这个地方有问题
Then '''+REPLICATE('0',@intLen-LEN(Convert(varchar(20),Convert(int,MIN('['+@chvCol+']')) + 1))) + Convert(varchar(20),Convert(int,MIN('['+@chvCol+']')) + 1)+'''

use pubs
declare @chvSource sysname, --数据源
@chvCol sysname, --字段名
@intLen int, --字符串的宽度
@chrRetuCode varchar(20),
@chvExec nvarchar(2000)

set @chvSource = 'sales'
set @intLen = 4
set @chvCol = 'stor_id'

Select (CASE When Exists(Select * From sales A Where A.stor_id = REPLICATE('0',@intLen - 1) + '1')
Then REPLICATE('0',@intLen-LEN(Convert(varchar(20),Convert(int,MIN(stor_id)) + 1))) + Convert(varchar(20),Convert(int,MIN(stor_id)) + 1)
Else REPLICATE('0',@intLen - 1) + '1'
END)
From sales
Where Not stor_id IN (Select REPLICATE('0',@intLen-LEN(Convert(varchar(20),Convert(int,B.stor_id) - 1)))
From sales B)
这段是没得问题的，结果0001

这个字符串已经调好了,没想到从一个不到两千条的表中查询就要花费快3秒钟!
大家先看看这个串,看还有什么高招啊...
Select @chvExec = 'Select @chrRetuCode =
(CASE When Exists(Select * From ['+@chvSource+'] A Where A.['+@chvCol+'] = '''+REPLICATE('0',@intLen - 1) + '1'')
Then REPLICATE(''0'',@intLen-LEN(Convert(varchar(20),Convert(int,MIN(['+@chvCol+'])) + 1))) + Convert(varchar(20),Convert(int,MIN(['+@chvCol+'])) + 1)
Else '''+REPLICATE('0',@intLen - 1) + '1''
END)
From ['+@chvSource+']
Where Not ['+@chvCol+'] IN (Select REPLICATE(''0'',@intLen - LEN(Convert(varchar(20),Convert(bigint,B.['+@chvCol+']) - 1))) + Convert(varchar(20),Convert(bigint,B.['+@chvCol+']) - 1)
From ['+@chvSource+'] B)'


主要就是慢在Where 条件用 IN 子查询啦 !