Question - doesn't your second method update the table regardless of outcome due to the insert? It seems to me that the two options are not logically equivalent! ...

Please elaborate. Are you sure you mean SS2K and not SS2K5?

Some idea of volumes, processing requirements, type of data storage (RAID / no RAID), etc.

1. One ALWAYS has the option beforehand.

2. What's the business use of capturing this fractionated date?

3. How will the content be retrieved?

Answer those two questions and I...

WOW! I'm thinking that a select top 1, where you order by in the sequence you want to control by - but what if you have more than one...

If you will be writing any CLR, you will want to verify that the correct version of .NET is installed. If your scope is solely within the stored procedure...

NOT a bunch of .... However, your request focuses on the crux of the issue. Being able to state clearly, in simple and direct language, what you are...

no 'MyCmd.ActiveConnection' statement? look at the example code again on page one. other than that, not sure what you could have missed?

Wendy - your backups are no good if you can't restore from them. Have you tested one of your backups by restoring to a test database area? What...

Ryan - I am SOOOO glad I came in after the shooting was over.

Just some reminders about how to make this forum more efficient and effective:

1. Be as specific...

Sounds like what you want to do is translate from Mandarin to Sanskrit (or should it be the other way around?). There are no magic bullets or global procedures...

Shashi -

I find your question analogous to asking why a baker uses brown sugar instead of confectioner's sugar. Without knowing whether the use is in a...

I apologize for the reset question - I reread the thread this morning (after decent sleep this weekend) and realize I missed your statement about 'every morning'. I'm inclined...

What changes in your results if you drop the 'DISTINCT' in your first line?

You stated that 'We attach with one user name and password and the users have full (owner)...

Ninja said: Shrink the file as you see fit, then leave it alone forever... unless you know it's way too small or 10 times way too big for your...

The subtle part of the dialogue above is very simple. Clarify the request before acting. Knowing what they meant by 'clean' is crucial. Since they wanted to...