how to add additional column in query

You are Welcome!

0

thanx arun its simple and its working..my query is same but i dont use case

select bc.* ,bgc.name as parentname from BlogCategory as bc

inner join BlogCategory as bgc on bc.ParentID = bgc.ID

0

Please find below the updated Query, I hope it should help!

----------------------------------------------------------------------------------

SELECT BC.*,

CASE WHEN(BC.ParentID > 0) THEN PBC.Name ELSE '' END AS ParentName

FROM dbo.BlogCategory BC

LEFT JOIN dbo.BlogCategory PBC ON PBC.ID = BC.ParentID

0

if u have any idea than please do this..

0

Use IIf() in query.

0