using CLR that returns table
in [Programming SQL]
|
Prev: Select Query Problem
Next: Time data type
From: TheSQLGuru on 30 Nov 2009 15:15 There is a massive and incredibly informative thread on SQLServerCentral.com's forums on just such a topic. Quite amazing how many ways there are to split strings! -- Kevin G. Boles Indicium Resources, Inc. SQL Server MVP kgboles a earthlink dt net "Roy Goldhammer" <roy(a)top.com> wrote in message news:%23ZRkJTQcKHA.4724(a)TK2MSFTNGP05.phx.gbl... >I have procedure who runs approx 10 times in one second, getting huge sting >with many words, > > I need to convert the list of these words to table where there are more > then one delimiter like space, ',', ';', enter, NL and more. > > for example: "one two,three > four > five" should be 5 words. > > on sql server i need to go one by one and it cause me alot. ON clr there > is split option which do it very fast. But as i explain it saves the data > into temp table on tempdb, which cause me to work very slow. > > and this is what i want to bypass. > > can you help me on it? > > "TheSQLGuru" <kgboles(a)earthlink.net> wrote in message > news:JO-dnQw0UqJaFI_WnZ2dnUVZ_uadnZ2d(a)earthlink.com... >> Not a CLR guru here but I thought when you streamed data back to sql >> server as a clr 'table' it was directly consumed by the query plan. >> >> What are you actually going to do with these 10 files converted to inline >> tables per second queries?? >> >> -- >> Kevin G. Boles >> Indicium Resources, Inc. >> SQL Server MVP >> kgboles a earthlink dt net >> >> >> "Roy Goldhammer" <roy(a)top.com> wrote in message >> news:ueI7mxPcKHA.808(a)TK2MSFTNGP02.phx.gbl... >>> Hello there. >>> >>> I need to build CLR which gets text and converting it to table. >>> >>> this CLR should run 10 times in one second. >>> >>> By default(as far as i know) the retuned table of CLR is saved to temp >>> db like any other table valued function. >>> >>> This can cause to system to work mutch slower then it is. >>> >>> Is there a way to bypass this problem? >>> >>> any help would be useful >>> >> >> > > |