Browse by Tags

• General
• Query
• Reporting
• SalesLogix
• SQL
• Views

• 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

• Fixing the Orphaned SYSDBA SQL User

  Ok, I see in my logs constantly google searches for “ fixing the sysdba user “ that lead to this blog. This is a common thing I find in my logs, but strangely enough, I've never posted anything about fixing the sysdba user. So, drumroll... sp_change_users_login... Posted Oct 14 2004, 08:43 PM by Ryan Farley with | with 2 comment(s) Tags: General, SalesLogix, Database