all things Sitecore related

TSQL

Converting .mrt reports from OMS to DMS

By on November 15, 2011 in Analytics, DMS, Sitecore, SQL Server, TSQL, Tutorials with 0 Comments
Converting .mrt reports from OMS to DMS

In this article I’m going to explain how to convert .mrt reports from the Sitecore Online Marketing Suite (Sitecore 6.4) to the Sitecore Digital Marketing System (Sitecore 6.5). Report related changes between OMS and DMS Both the OMS and the DMS use .mrt reports for Analitics reporting. There are two mayor changes between the OMS […]

Continue Reading »

TSQL: Nested Select with multiple results to one (comma separated) string

By on August 25, 2009 in TSQL with 0 Comments

For this example I will use the default asp.net Membership tables. Let say: I need to return all users with their roles (comma separated) in one query. After a long time Googling I found the following solution. select   UserName,   (select roles.RoleName + ', '     FROM aspnet_Roles roles     join aspnet_UsersInRoles usersInRole on roles.RoleId = […]

Continue Reading »

TSQL: Use common table expression

By on August 23, 2009 in TSQL with 0 Comments

With common table expressions you can save the results to a temporary result set and use this results set for other queries. WITH temporaryNamedResultSet AS (   select UserName from aspnet_Users ) select * from temporaryNamedResultSet

Continue Reading »

Top