Browse by Tags

• Database
• Query
• Reporting
• SQL

• Flattening Out SalesLogix Data To Combine Multiple Rows into a Single String using SQL

  A question came up from a person attending our current Report Writing class about how to flatten out data that exists as multiple rows in the database to a single string in a report. There is a really cool trick you can do in SQL to accomplish this which I previously outlined in a post on my personal blog where I outline a technique that can be used to make a query append each value from the rows in the query to a variable. Without using cursors, you will end up with a variable that has the values appended to it as one single string which can easily be used in reporting. Posted Oct 01 2009, 10:43 AM by Ryan Farley with | with 2 comment(s) Tags: Views, Query, Database, SQL, Reporting