The truncated content of the variable from Watch Window : ---------------------------------------------------------- select TMM.MENUEID as [MENUEID], TTR.MODID as [MODID], TTR.TYP_ID as [TYP_ID], TTR.NAME as [NAME], TTR.BESCHREIBUNG as [BESCHREIBUNG], TMM.EBENE1 + case when isnull(TMM.MANDANT,'')='' then '' else '(' + TM.NAME + ')' end as [EBENE1], TMM.EBENE2 as [EBENE2], TMM.EBENE3 as [EBENE3], TMM.PARAMS as [PARAMS], null as [DBRIGHT], TMM.MANDANT as [MANDANT] \n from osparchiv_aktuell..BP_MODULMENU TMM left outer join osparchiv_aktuell..BP_UM_TYP_RECHTE TTR on TTR.MODID = TMM.MODID \n left outer join osparchiv_aktuell..BP_MANDANT TM on TM.ID = TMM.MANDANT \n WHERE TMM.MENUEID>0 union all select TMM.MENUEID, TMM.MODID, TTRM.TYP_ID, TTRM.INFO + ' (' + CONVERT(varchar, TTRM.TYP_ID) + ')', TTRM.BESCHREIBUNG, TMM.EBENE1 + case when isnull(TMM.MANDANT,'')='' then '' else '(' + TM.NAME + ')' end, TMM.EBENE2, TMM.EBENE3, TMM.PARAMS, TTRM.DBRIGHT, TMM.MANDANT as [MANDANT] \n from osparchiv_aktuell..BP_MODULMENU TMM left outer join osparchiv_aktuell..BP_UM_TYP_RECHTE_MENUE TTRM on TTRM.MENUEID The complete content of the variable would be: ---------------------------------------------- select TMM.MENUEID as [MENUEID], TTR.MODID as [MODID], TTR.TYP_ID as [TYP_ID], TTR.NAME as [NAME], TTR.BESCHREIBUNG as [BESCHREIBUNG], TMM.EBENE1 + case when isnull(TMM.MANDANT,'')='' then '' else '(' + TM.NAME + ')' end as [EBENE1], TMM.EBENE2 as [EBENE2], TMM.EBENE3 as [EBENE3], TMM.PARAMS as [PARAMS], null as [DBRIGHT], TMM.MANDANT as [MANDANT] from osparchiv_aktuell..BP_MODULMENU TMM left outer join osparchiv_aktuell..BP_UM_TYP_RECHTE TTR on TTR.MODID = TMM.MODID left outer join osparchiv_aktuell..BP_MANDANT TM on TM.ID = TMM.MANDANT WHERE TMM.MENUEID>0 union all select TMM.MENUEID, TMM.MODID, TTRM.TYP_ID, TTRM.INFO + ' (' + CONVERT(varchar, TTRM.TYP_ID) + ')', TTRM.BESCHREIBUNG, TMM.EBENE1 + case when isnull(TMM.MANDANT,'')='' then '' else '(' + TM.NAME + ')' end, TMM.EBENE2, TMM.EBENE3, TMM.PARAMS, TTRM.DBRIGHT, TMM.MANDANT as [MANDANT] from osparchiv_aktuell..BP_MODULMENU TMM left outer join osparchiv_aktuell..BP_UM_TYP_RECHTE_MENUE TTRM on TTRM.MENUEID = TMM.MENUEID left outer join osparchiv_aktuell..BP_MANDANT TM on TM.ID = TMM.MANDANT WHERE TMM.MENUEID>0 and TTRM.DbRight is not null order by EBENE1, EBENE2, EBENE3, TYP_ID