That's a good technique, but it's easiest to use set rowcount on deletes (because you don't have to adjust the SQL statement - just run it repeatedly in a loop...

This is an internal extended system stored procedure that gets called to prepare and execute an ODBC batch in one round trip to the server.  There is a detailed thread about this in...

I don't have what you're looking for, but another approach would be to drive this from a batch file.  You could CD to the directory, and then do something like...

I think that using a loop (especially to iterate through a cursor) might be a good idea here, so I'd agree with mom ... BUT ... you don't want to...

When you mention "namespaces" in Oracle, do you mean tablespaces?  If so, you can put objects into specific filegroups in SQL Server and use that as a means of identifying...

Isn't that part of CA's Arcserve?

Cheers,

Chris

PS.  By the way, you posted this in the Administration section for Notification Services - I'm guessing that you probably meant to post in the...

Hi bbdpres,

Your idea of having a multi-person team look over the questions before publication is a good one, but it would require a level of daily commitment from a team...

OK, but be sure to post an update if you get cornered.  I do wonder (now that I'm home and a little more reflective about things) ... where are the...

Once I worked with a Web guy that needed to create database logins and users from his Web applications.  We wouldn't let him (of course!), but we worked out a...

> If table has more then 1 row, value may be unexpected.

Yes, that's true, especially since there's no ORDER BY clause (which would make the result predictable).  But in...

This isn't an answer to your question, but ... is this SQL 7?  I'm asking because I thought the DBO_ONLY option had been replaced by RESTRICTED_USER.

Chris

Of course there's a performance "hit" because you are storing, processing, and retrieving data.  But when used correctly, FTS can definitely be a net gain in performance.  Your question might...

If gross days are 2, then I don't understand how holidays could be 5, so maybe you could define your terms a little more in your next post.  If gross...

And here is my reply.  Do I get extra psycho points for responding to my own post?

Dear xxxxx,

Just looking at your sample, without understanding exactly what business or logic problem...

I may be missing something obvious here, but don't you just mean the following?

flex days = gross days - holidays - weekend days

In your example, this yields an answer...