ggraber (6/26/2008)

---

The example I gave is a modified example of what we are doing.

I thought the actual example would take too long to explain.

Does anyone have any suggestions of how...

Here is a vesion without any Cursors:

create proc spVB_Make_Class as

--from Lambert Antonio, 26-jun-2008

Set NoCount ON

declare @field table (id int identity primary key clustered, fieldname varchar(50), fieldtype varchar(50))

declare @table_name varchar(50)

set @table_name...

Make a common library that you can call both from your SQLCLR wrapper and from VB.net.

Why would you want to do it this way? Why not just write records into one table?

Sorry, I missed that there were two columns returned...

As for why it is faster, this is an Inline Table-Valued-Function. They are special in that they do not have procedural...

This server is still pegged, just not as badly as before. If you look at the charts you will see that it swings from being CPU-saturated, to being Disk-saturated...

smunson (6/26/2008)

---

How about the following?

BEGIN TO COMMIT

WHEN RECEIVE DUMP

THEN END CONVERSATION

Kind of silly, but I got a laugh out of it...

especially when I considered how RELATIONAL it is :w00t::D:P:hehe:

Steve

(aka...

Could...

Gail is probably too polite to point it out, but I think that you meant to say "Ms. Gail Shaw".

Try replacing your function with this one, in the query:

CREATE FUNCTION [dbo].[FN_SplitCommaInClause_N]

(

@ItemList NVARCHAR(4000),

@delimiter CHAR(1))

Returns TABLE

AS

...

This query looks like it is part of a larger procedure...

thanks. no clues there, unfortunately. I suspect that it has something to do with the function; can you post its listing?

Also, if you select directly from your paramaters...

Can you attach the different query plans, in xml format?

What is the format of the file to load? If you control that, then you make it compatible with BULK INSERT and its easy. Otherwise, it is probably...

Well, I am not that familiar with SyBase, but are you getting any error messages?