case create a problem in sql server

Joginder Banger

11y1.3k

hi every buddy,

plz solve my problem if any buddy understand. when i use case it throw error

set @sql ='select *
from
(
select tsim.OrganisationCode orgcode , (case when tsim.OrganisationName is not null then '+'yes'+' else null end) as orgname,p.RouteofAdministration from tbl_Product p
inner join tbl_ProductMaster as pm on p.fk_ProductMasterId=pm.ProductMasterId
inner join tbl_ProductSiteInpectedBy as ps on ps.fk_ProductMasterID=pm.ProductMasterId
inner join tbl_SiteInspectedBy_Master as tsim on tsim.OrganisationID=ps.fk_OrganisationID
) d
pivot
(
max(orgcode) for orgname in ('+@columns+')
) as t2'

exec(@sql)

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

sudipta sanyal11y ago
set @sql ='select *
from
(
select tsim.OrganisationCode orgcode , (case when tsim.OrganisationName is not null then ''yes'' else null end) as orgname,p.RouteofAdministration from tbl_Product p
inner join tbl_ProductMaster as pm on p.fk_ProductMasterId=pm.ProductMasterId
inner join tbl_ProductSiteInpectedBy as ps on ps.fk_ProductMasterID=pm.ProductMasterId
inner join tbl_SiteInspectedBy_Master as tsim on tsim.OrganisationID=ps.fk_OrganisationID
) d pivot
(
max(orgcode) for orgname in ('+@columns+')
) as t2'

exec(@sql)
Joginder Banger11y ago
not done ....same problem again
Jaimin Soni11y ago
try this set @sql ='select * from ( select tsim.OrganisationCode orgcode , (case when tsim.OrganisationName is not null then yes else null end) as orgname,p.RouteofAdministration from tbl_Product p inner join tbl_ProductMaster as pm on p.fk_ProductMasterId=pm.ProductMasterId inner join tbl_ProductSiteInpectedBy as ps on ps.fk_ProductMasterID=pm.ProductMasterId inner join tbl_SiteInspectedBy_Master as tsim on tsim.OrganisationID=ps.fk_OrganisationID ) d pivot ( max(orgcode) for orgname in ('+@columns+') ) as t2' exec(@sql)