All samples are created using two stored procedures:

create procedure {databaseOwner}[{objectQualifier}mdo_xslt_modules] @PortalID int as
begin
   select * from {databaseOwner}[{objectQualifier}Users;
   select count(*) as [count] from {databaseOwner}[{objectQualifier}Users;
end;
create procedure {databaseOwner}[{objectQualifier}mdo_xslt_users] @PortalID int as
begin
   select * from {databaseOwner}[{objectQualifier}UserPortals] up
   join {databaseOwner}[{objectQualifier}Users] u on u.UserID = up.UserID
   where up.PortalID = @PortalID;
end;
You can craete these procedures via Host/SQL or via MS SQL Mamagement Studio. In the last case you must manually change tags {databaseOwner} and {objectQualifier}.

Last edited Nov 12, 2009 at 5:10 PM by findy, version 3

Comments

No comments yet.