select stpScreenWidth, websiteId, portal_name, portal_ownerId, portal_ownerType, '' clientDisplayName, '' stpScreenWidth from fsenablers..tbl_CUS_Websites with (nolock) where portal_ownerId > 0 select * from qmd_portals where clientDisplayName <> '' order by clientDisplayName

Preview Only - no changes made

#htmleditformat( clientDisplayName )# (#portal_ownerType##portal_ownerId#)

#htmleditformat( clientDisplayName )# #htmleditformat( qmd_portal.graphicsDirectory )# #qmd_portal.newScreenWidth#

select clientDisplayName, stpScreenWidth from qmd_portals