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...

Avoid providing sysadmin rights to non sqlserver applications !

Unless off course it is for a central configuration management system that

really needs to set sqlserver instance properties.

There are several other...

If DBCC opentran shows open transactions, these will be rolled back if you kill the connections !!!!

In that case you will loose data.

OT

As you will have noticed, readability is always an issue :doze:

Start using table_aliases in your queries !

e.g.

select you_know_a_schema_name_can_be_very_long_indeed.wel_you_know_an_object_name_can_be_very_long_too .mycolumn

from you_know_a_schema_name_can_be_very_long_indeed.wel_you_know_an_object_name_can_be_very_long_too

inner join the_other_schema.the_other_object_name

on you_know_a_schema_name_can_be_very_long_indeed.wel_you_know_an_object_name_can_be_very_long_too .PK = the_other_schema.the_other_object_name.theFKcol

...

will become

select...