Browse by Tags

• Development
• How-To
• SQL
• User Defined Functions

• SQL Function for parsing name values

  In a recent project, I had to create a SQL Server Integration Services package to basically copy contact information (which was being stored in the Account.Account field) from the Account table into the Contact table. Since the Contact name was being stored in it's entirety within the account field, I needed a way to parse the Contact information to populate the individual contact name fields in the contact table. Posted May 25 2010, 10:13 AM by Jason Buss with | with 1 comment(s) Tags: How-To, SQL, Parsing Data

• 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. Posted Mar 08 2010, 03:40 AM by Jason Buss with | with 2 comment(s) Tags: Development, How-To, SQL, Parsing Data, User Defined Functions