Viewing 15 posts - 16 through 30 (of 185 total)
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...
June 18, 2009 at 9:32 am
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...
May 14, 2009 at 6:46 am
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%'
May 1, 2009 at 1:02 pm
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,...
January 12, 2009 at 11:53 am
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. ...
January 8, 2009 at 7:51 am
Thanks so much. This is exactly the discussion I was looking for.
January 5, 2009 at 11:24 am
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...
January 5, 2009 at 10:33 am
Not that I had tried that, but no. It would be nice to get something like MyServer.MyDomain.OurSystem, but I'd settle for 220.127.116.11. We're trying to build a dynamic...
January 5, 2009 at 9:36 am
Thanks. Will that runtime work within SQL Server Management Studio, or do we need to keep pieces of SS2K around?
January 5, 2009 at 9:30 am
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...
December 17, 2008 at 11:24 am
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.
August 28, 2008 at 7:30 am
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...
August 14, 2008 at 10:25 am
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...
August 14, 2008 at 8:06 am
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...
July 8, 2008 at 10:57 am
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...
July 8, 2008 at 6:10 am