SourceCode/PROMS/SQL/FindROTables.sql

3 lines
193 B
SQL

select * from grids gg
Join Contents CC ON GG.ContentID = CC.ContentID where cc.contentid in (select contentID from rousages)
And cast(Data as varchar(max)) like '%<IsRoTable>True</IsRoTable>%'