带变量的存储过程

[明珠佩佩]

可否帮我检查下原因，为什么这样写不行呢？

declare @sql varchar(8000)
declare @sqlCondition varchar(8000)

set @sqlCondition = 'ProjectTypeCode=''03'' and '

set @sql = 'select a.DrawingName, a.DrawingNum '
select @sql = @sql + ', max(case b.ProjectName when ''' + ProjectName + ''' then PlanSendDate end) [' + ProjectName + '计划下发]'
+ ', max(case b.ProjectName when ''' + ProjectName + ''' then InfactSendDate end) [' + ProjectName + '实际下发]'
from (select ProjectName from BM_Project where @sqlCondition LogoutFlag='0') as t
set @sql = @sql + ' from VIEW_BM_DrawingContentToPlanTrack a , BM_Project b '
set @sql = @sql + ' where a.ProjectTypeCode=''03'' and a.ShipOwnerCode=''05'' and a.ProjectCode=''01'' and a.ProjectTypeCode=b.ProjectTypeCode and a.ProjectCode = b.ProjectCode group by a.DrawingName, a.DrawingNum'
print(@sql)

变量代入后没有什么反映啊，也不报错

[chuifengde]

declare @sql varchar(8000) 
declare @sqlCondition varchar(8000) 

CREATE TABLE #(ProjectName varchar(100))

set @sqlCondition = 'ProjectTypeCode=''03'' and ' 

INSERT # exec('select ProjectName from BM_Project where '+@sqlCondition+' LogoutFlag=''0''')

set @sql = 'select a.DrawingName, a.DrawingNum ' 
select @sql = @sql + ', max(case b.ProjectName when ''' + ProjectName + ''' then PlanSendDate end) [' + ProjectName + '计划下发]' 
                  + ', max(case b.ProjectName when ''' + ProjectName + ''' then InfactSendDate end) [' + ProjectName + '实际下发]' 
from # as t 
set @sql = @sql + ' from VIEW_BM_DrawingContentToPlanTrack a , BM_Project b ' 
set @sql = @sql + ' where a.ProjectTypeCode=''03'' and a.ShipOwnerCode=''05'' and a.ProjectCode=''01'' and a.ProjectTypeCode=b.ProjectTypeCode and a.ProjectCode = b.ProjectCode group by a.DrawingName, a.DrawingNum' 
print(@sql) 

DROP TABLE #

[明珠佩佩]

如果我需要在结果中增加一列自增字段呢，应该怎么改啊

[chuifengde]

set @sql = @sql + ' ,自增字段=identity(int,1,1) into 临时表 from VIEW_BM_DrawingContentToPlanTrack a , BM_Project b '
set @sql = @sql + ' where a.ProjectTypeCode=''03'' and a.ShipOwnerCode=''05'' and a.ProjectCode=''01'' and a.ProjectTypeCode=b.ProjectTypeCode and a.ProjectCode = b.ProjectCode group by a.DrawingName, a.DrawingNum'
print(@sql)

select * from 临时表

drop table 临时表