34,576
社区成员
发帖
与我相关
我的任务
分享
set @where ='(SELECT dbo.AssayMainB.AssayID, dbo.AssayMainB.MaterialID,
dbo.AssayMainB.MaterialName, dbo.AssayMainB.EnterpriseName,
dbo.AssayMainB.CarNum, dbo.CarInfoB.CarNo, dbo.CarInfoB.CarWeight,
dbo.AssaySubB.AssayName, dbo.AssaySubB.AssayValue
FROM dbo.AssayMainB INNER JOIN
dbo.AssaySubB ON
dbo.AssayMainB.AssayID = dbo.AssaySubB.AssayID INNER JOIN
dbo.CarInfoB ON dbo.AssayMainB.AssayID = dbo.CarInfoB.AssayID
WHERE (dbo.AssayMainB.MaterialID = '''+@materialid+''') AND
(dbo.AssayMainB.AssayDate BETWEEN '''+@begintime+''' AND
'''+@endtime+''') AND (dbo.AssayMainB.WorkState = 2) AND
(dbo.AssayMainB.AuditingState = 1) AND (dbo.AssayMainB.ParkFlag = 0))TEM'
select @s='SELECT AssayID as 化验流水号, MaterialID as 物料编号, MaterialName as 物料名称, enterprisename as 供货商,
carno as 车牌号码,carweight as 净重 ,sum(case Assayname when ''水含量'' then assayvalue else 0.00 end) as 水含量 from ' +@where +
' group by AssayID, MaterialID, MaterialName,EnterpriseName, CarNo, CarWeight ORDER BY ASSAYID'
--是不是你说的意思?
set @where ='(SELECT dbo.AssayMainB.AssayID, dbo.AssayMainB.MaterialID,
select name from syscolumns where id=(select id from sysobjects where name='tb_query') order by colid
select a,b,c,d,e,f
,case when exists(select 1 from INFORMATION_SCHEMA.COLUMNS where table_name ='tbl' and column_name= 'g' )
then f*g else 0 end as h
from tbl
where ...