Bleh.  I have been thinking about this for a couple of hours now.  And I probably shouldn't have done <g>.  (I keep waiting for somebody whose field this is to...

OK, KC, what about the other question I asked you in that message?  Are you sure you executed the command against the right object?  I can't understand how you could...

>>It complained the stored procedure expecting a @Start parameter.

That's funny, I do it this way and it works fine. Are you sure you used the connection.Execute() method? 

Remember, we're not...

Did you try what I suggested, about removing the command object from the picture, while still executing your stored procedure?

Note: this is different from confirming that the parameters return the...

Wouldn't this be handled more by the "Concurrent user" thing?

IOW, what is the max number of users who are on-line at any given time?

>L<

If I'm reading your question right, this is a classic "percentage of total in the detail band" problem. The classic answer is that you need to preprocess your data to...

Yeah, I was afraid it was too weird a thought <g>.  Thanks.

>L<

>>

select CASE DatePart(month,Date_occur)

   WHEN 1 THEN 'Jan'

>>I don't see how the object is close.

The problem may be that you did this, paradoxical as it may seem:

Set rst = cmd.Execute
rst.Open cmd ' <-- this line...

>>. An organization has a web application that its employees use (authenticating, not anonymously) from all over the place.

If it's over the web, is the SQL Server box sitting behind...

>>The problem is how does one script the if/then into it?

Maybe we're talking about two different things, or maybe I'm missing something...

If I create a new job, and then...

There is a good chance that this has *nothing* to do with any differences between SQL Server editions, but JIC I'm working from a SQL Express instance here...

So, under my...

>> again it's the IF/THEN code which i have trouble with

I'm sorry, I thought you got that code earlier in the thread:

[Lezza]

>>

The 2005 view is

SELECT...

Sounds like it might be a rights problem.

When you create the copy of the template, who is the owner/creator of the original template?  Who is the owner/creator of the copy?

When...

Are you starting with an integer number of hours, a DATEDIFF, the DaysInterval property, or what? 

IAC if you can't do this on the SQL side, as others have explained,...