TSQL
3 posts in this category
- Converting .mrt reports from OMS to DMSIn 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…Nov 15, 20115 min read
- TSQL: Nested Select with multiple results to one (comma separated) stringFor 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…Aug 25, 20091 min read
- TSQL: Use common table expressionWith common table expressions you can save the results to a temporary result set and use this results set for other queries.Aug 23, 20091 min read