March 2010 - Posts

• Recombining Parsed data in SQL

  A couple of weeks ago, I posted about using User Defined functions and Cross Apply to parse data in SQL server. The second part of the import I was working on required me to take that parsed data, perform some manipulations, and then recombine that data. Surprisingly, I found that putting that data together was much more difficult then pulling it apart in the first place. After much experimentation, this is what I came up with... Read more Posted Mar 30 2010, 08:10 AM by Jason Buss with no comments Tags: How-To, SQL, SQL Functions

• Updating table IDs in SageCRM using SQL

  I just finished work on an import project into SageCRM, using SQL Server Integration services to move data from a couple of Excel Spreadsheets into the database. One of the items I had to figure out was how to populate tableIDs for the imported records. Read more Posted Mar 18 2010, 07:15 AM by Jason Buss with no comments Tags: Development, How-To, Imports, Sage CRM

• Using SQL User defined functions and Cross Apply to parse SQL data

  Recently, I worked on an import where I spent a considerable amount of time working out how to effectively parse data from a SQL table, for insertion into another table. Read more Posted Mar 08 2010, 03:40 AM by Jason Buss with 2 comment(s) Tags: Development, How-To, Parsing Data, SQL, User Defined Functions