case create a problem in sql server

Question

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 orgnamep.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)

sudipta sanyal · Answer

set @sql ='select * from ( select tsim.OrganisationCode orgcode  (case when tsim.OrganisationName is not null then ''yes'' else null end) as orgnamep.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 Banger · Answer

not done ....same problem again

Jaimin Soni · Answer

try this set @sql ='select * from ( select tsim.OrganisationCode orgcode  (case when tsim.OrganisationName is not null then yes else null end) as orgnamep.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)