That's an interesting technique. With VMWare/Virtual PC, you could easily set one of these up. Hmmm, I think I see an editorial here.

Moved to the 2000 forum.

What I'd do is insert all the records into a staging table. Then insert rows into the real table that are good, whatever that means.

You have...

Points awarded back and both 1 and 2 marked as correct.

I think the answer is correct, but I have added a warning to the explanation so that people that might not read the discussion will see it.

Closing thread. Please post here: http://www.sqlservercentral.com/Forums/Topic703170-338-1.aspx

What do you want to get? What are you trying for?

Give some sample data, show what you want the output to be, include and error messages, etc.

I edited the code.

If you have a question, the title / description is not the place to put it.You also need to describe what issue you are having and what...

Good luck, Bob!

you can have my slot. I submitted one, but perhaps should have skipped it given all the submissions there are. I was thinking there might be less with...

Chris,

Sounds like you're in a good place and managing your career well. Good for you!

Interesting responses.

My wife says Dragon is great, but with ambient noise, and enough mistakes, it isn't good enough. There's also the fatigue factor, and it doesn't go nearly as...

If you reindex in a maintenance plan, which I think is a default for Sat night, it uses a lot of log space to rebuild the index. That is a...

Is the server overloaded when it times out? The disk I/O perhaps?

I'm not an SSAS person, but guessing here. I'd bet there is some other event on the server you...

You want, I think, to look at the CASE statement. Something like

select

case when rundate > runlog then myitem

else 'something else'

Or is rundate in Access?

If it is,...

If you look at this again, please be sure that you test, and test well, the impact. The advice from Microsoft is not to do it, unless they give you...

http://msdn.microsoft.com/en-us/library/ms173778.aspx