Good write up Brian. It is good to hear an accurate depiction of the product, from the other end of the table.

Not really, I was horsing around. But mind you that not everyone gets to choose there PC, whether there is a benifit or not.

Full text search search column data in SQL server. This will only search documents if you import documents into SQL server.

I do not know much about dtsearch but based...

Cool, you should be able to use the left function. I didnt want you hitting any speeds bumps, without being aware. 🙂

I agree with Jack. This is not a situation where an odbc driver is optimal. You should use oledb for its native support and performance benifits.

Thats not even fair :crazy:

No, I am really happy for you Robert :unsure:

touche friend. :)That's exactly what I was talking about... you asked why I would use something that I knew was slower... I knew that for the application I wanted,...

Not at all:). I have actually been looking for this piece of code for some time.

One...

I understad the select method is still a good solution and completely backward compatible. I also understand that you probably will not need a string of this magnitude, but...

I agree... the FOR XML PATH solution isn't much faster than the custom aggregate in the presence of an index beneficial to both methods. And things like a million...

You need a zip program because you cannot do this with the windows compressed folders. You then use a foreach loop to loop through the files in a directory....

You can use the same datasource but use a conditional split to grab only the records where company is company1. The you attach the derived column to the conditional split...

You woud have to do something like this:

ALTER TABLE

ALTER COLUMN COLUMNNAME DATATYPE

ALTER TABLE

ALTER COLUMN COLUMNNAME DATATYPE

If you do not want to do ths then you will have to drop the...

Use a dataflow task. Make your table the source table and then use a derived column to replace the value of the company. Then use the same table...

I have never tried what you are attempting to do before. Based on the error message, I would say that you cannot accomplish your task on that particular column.

You...