i think that was more or less the idea behind MSOFT's integration of SQL 2005 and .NET platform, at least when it comes to SQL Server enhansments/improvements.

the job for SQL Server is :

1. to keep the data in relational DB datastructure

2. to process/modify the data by using native T-SQL capabilities

3. to happily delegate some processing steps [like...

I need SQL license b/c I need to process SQL tables before they go get uploaded to a database on our site (http://www.knovel.com) And b/c the original data i'm...

sorry for the typo. I wanted to say:

*250k records in 15 sec*

when i was referring to the speed of the processing

Sergiy,

to my defense :=) I can say that I was referring to a different situation, when a lot more than simple search by a predefined sting is going...

test

Jeff if u can spare a minute, please explain in a few words what did u mean by

***Remi... remember my response when you asked about DTS??? This is a...

hi Jeff, hope u r doing fine.

I just run a search in a table of 250k recs  on a varchar(4000) fld for a regex pattern of medium complexity using...

correction to my prev post:

regex needs t be enhanced to take care of the situation when there are only 8 words, and one needs to get them all:

^(\b\w+(\x20+|$)){10}|^(\b\w+(\x20+|$)){8}

select InputString, dbo.ShowMatch(InputString,

'^(\b\w+(\x20+|$)){10}|^(\b\w+(\x20+|$)){8}')...

for 2005 Server

create a CLR function as [C#] using .NET Regex Class

using System;

using System.Data;

using System.Data.SqlClient;

using System.Data.SqlTypes;

using Microsoft.SqlServer.Server;

using System.Text.RegularExpressions;

public partial class UserDefinedFunctions

{

    [Microsoft.SqlServer.Server.SqlFunction]

    public static String ShowMatch(String s, String match_pattern)

   ...

in 3 yrs I never saw this method fail on integer IDs.

Can u offer an alternative?

--try

select fld1, fld2, identity(int, 1,1) as RowNumber

into dbo.Tbl_Result

from dbo.Tbl_Source

order by fld3 --or some other criteria for ordering or other means of getting the result data set

yes u can, and here is an example:

select top 100 *

from strings_sort_06 S left...

b/c ther'es no standard function for this, u'd have to write your own function according to a well-known algorhithm. I'm sure it'll be elegant enough

sorry for misprints:

C# code for the function:

public striing CleanString()

  { //declare an input string of text

   string InputString = @"1233%%%456XYZYZY";

   //replace everything other than \d with an empty string 

string ResultString =  Regex.Replace(InputString, @"[^\d]",...