Advertisement

07.21.2008 at 07:02PM PDT, ID: 23583958 | Points: 500
[x]
Attachment Details

Using Stored Procedure types TSQL and CLR together

Asked by christopher_perry in SQL Server 2005, MS SQL Server, Visual Basic Programming

Tags: SQL, Visual Basic

I am working on some SQL data maninpulation using stored procedures.  I have a table with the following fields:
FullName
LastName
FirstName
MiddleName
SuffixName

I have created a CLR procedure that can programatically split the FullName field into the individual name pieces.  I started at first using datasets, but the amount of data being formatted is extremely large (more than 100,000 at a time).  So, is there a way for me to create a TSQL stored procedure, and have it pass specific fields to my CLR procedure to split and update the other name fields?  I've read about cursors in stored procedures, but I've never used them.Start Free Trial
[+][-]07.21.2008 at 08:41PM PDT, ID: 22056302

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]07.21.2008 at 08:47PM PDT, ID: 22056319

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]07.21.2008 at 08:52PM PDT, ID: 22056334

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
 
Loading Advertisement...
20080716-EE-VQP-32 / EE_QW_2_20070628