Hi Gail,

Your article discusses exactly the kind of question I'd be likely to post, and I'd love to follow your suggestions. And being brand new to a post-2000 SQL...

Obviously there's not a lot of enthusiasm for writing competing SSIS training books. Thanks for these suggestions. I'll just have to remember that I wasn't born knowing DTS...

This question reminded me of something that I've never understood. You would get the same answer to the question if the where statement looked like this:

where lastname like 'Smith%'

and...

Hi Gift Peddie,

Thanks to you and everyone else who responded. The decision has been made (like that passive tense?) to go with C#, mostly for the reasons listed here,...

Chris,

Thanks for that suggestion. It's actually similar to what we're doing now, but here's the problem with that. We have a test instance and a production instance. ...

Greg,

Thanks so much. This is exactly the discussion I was looking for.

Mattie

Chris,

Thanks for responding. We have a test instance on one server, and a prod instance on another. We want the file produced on the prod instance to be...

Steve,

Not that I had tried that, but no. It would be nice to get something like MyServer.MyDomain.OurSystem, but I'd settle for 181.50.144.3. We're trying to build a dynamic...

Steve,

Thanks. Will that runtime work within SQL Server Management Studio, or do we need to keep pieces of SS2K around?

Mattie

Thanks to everyone who's responded so far, and by no means let these comments end the discussion. As to the comment 'the poster didn't ask what you'd prefer', it...

Where's your Prius MPG update? I should think your summer mileage would be terrific, unless it's being driven down by driving into all that wind.

Mattie

Barry,

Thanks for responding. I have looked at that sp a dozen times, there's nothing in there. I even dropped and recreated it. I've attached the code for...

Adam,

Thanks for responding. No triggers anywhere; not in SpotsWarrants, not in SpotsWarrantsErrors. I've posted the create statements for both tables below. And my first thought was 'I...

I've figured it out. The table I was retrieving the value from has the InvalidCharacter field defined as char(5), because of other uses of the table. Apparently moving...

Thanks for the responses, but I don't think they address the problem I'm trying to solve. I don't want to update a table, I want to modify a string...