Yes, as long as you don't have to deal with ntext fields..

Here you go. There's also LTRIM. Drop it if you don't need it...

Becareful and use the PRINT option first...

You are absolutely correct.

You must use 3 part naming convention (Server.DB.Object) or even 4 part (Server.DB.Schema.Object) in order to get away with it.

If your solution refers to 10 objects than...

And what about some virtualization?

You could consider using VMWare or Miscrosoft Virtual server / PC to play around with SQL....

1. Should the parameters (@db + @server) act as constants/config values, where setup once / use many is applicable per each server or that per each query you need...

Have a look at Microsofts' LogParser.

It works like charm.

One line of code will generate a text file with CMD extension, composed of DEL lines with file names

The other will execute...

Sadly - as Bob stated - it's a bit difficult to help that way.

However, please try using CHECKSUM(*) or BINARY_CHECKSUM(*) to allow for single key comparison.

Note that there's a slight...

Please note that microsoft office automation on servers is prohibited by MS EULA As stated in http://support.microsoft.com/kb/257757/en-us

...

Besides the technical problems, you must also consider licensing issues. Current licensing guidelines prevent...

Mind that you're calling the job by its name while management tools refer to the job by its GUID....

One way to overcome this difference is:

1. Run a profiler on MSDB...

Maybe you noticed many people stepped into this thread but didn't answer you...

I think it might help if you post some sample code (create temp tables, populate demo data) so...

Hi

It really depends... Do you need to do this once or on a regular basis?

are there any naming conflicts between any of the objects?

The simplest way would be to...

HI

MSDB is the database where all this info is saved in.

you may use sp_help_job to see job info or use similar procedures, or you can stroll through the different tables...

I know the SQL way to achieve this.... however, this is a 10 seconds solution for people who know their way around data pumps, like me and you.

I referred to...

Simply cast all the CASE fields as varbinary. This way, both numeric, date and strings will fit correctly to the CASE statement...

Also, in order to reverse, just use -1*value to...

Your 15 second solution is not SQL related at all:

download microsoft logparser and run it on your data.

if, for example, your data is in CSV file, you can run the...

OK, this is going to be along post and not sure it will solve your problem...

What you are trying to achieve is divided into 2 categories:

1. Finding similarity between your...