Jeff Moden (2/19/2008)

---

I'd be real interested in knowing...

Christopher Ford (2/19/2008)

---

BTW, on a production test.

I had to run Jeff's running total update because I had 80 million rows to group by 1,928,672 different accounts over a 7 year...

Thanks 🙂

OT bis

Is there an "common CLR pittfals" link somewhere ?

Christopher Ford (2/19/2008)...

pipe.SendResultsStart(row);

...

(0 row(s) affected) :laugh:

Is it a public link ? :Whistling:

TheSQLGuru: From what I've been told - didn't have time yet to play

with CLR that...

As you have noticed, SSIS can break at ## of places :crying:

And the wizard isn't as intuitive as the one for dts (sql7/sql2000)

You can enable ssispackage logging.

IMO SSIS is something...

the downside for the patterns is that you have to know them at front.

The downside for soundex is that it is language dependent !

(i.e. English)

btw just like DIFFERENCE(T1.LName, T2.LName)

SELECT...

If you want exact result, you need to specify exact predicates.

For similarity , you may want to experiment with soundex,...

There are examples at the SSC forums.

Read BOL for information on...

So the databases reside at the same server instance ?

Did you use DRI (Foreign keys) ?

For the first time only ! you could use this :

If yes :

- Did you...

I've created this little clr sproc.

You can easily profile it, but you need to select the storedprocedure

SP:Stmt... trace options to see what it is doing.

Kind of logical 😉

If you want...

As Adam stated, the missing end statement with your case

statement is actualy the only thing I can find that would break your code.

I used SQL Refactor to parse it....

Maybe this script can help you a bit...

http://www.sqlservercentral.com/scripts/Miscellaneous/31808/

Just keep in mind to have your first aid kit available. 😀

Also there are # of articles/forumQ regarding CLR at ssc.

Very nice demo indeed ! 😎

Keep in mind CLR is a double edged knife.

You can easily cut your finger with it.

Well it certainly started with a great article, handling a fairly common issue 😎

And it resulted in a solution that worked a lightning speed and performed

the actual update in a...