>>

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,...

There are two ways to do this that I can see:

1) run a "prefix" job scheduled either before all the one ones or on a frequent schedule.  (How frequent depends...

There are basically two ways to do what you want to do:

1) control the position of the temporary file (use System.IO.Path.GetTempPath() or whatever to find someplace you can expect...

Well, you seemed to have found your own answer here -- and you definitely know more about OpenXML than I do <g> --

But, FWIW and for future reference for...

Hi Todd,

There are several reasons why somebody might ask you to do this. Some are technical, some are not. Some are good (I don't mean to equate "good" with "technical" btw). Some...

You absolutely can convert dates and integers, but it's important to know how the system from which you are converting treats its date of origin.  For SQL Server, that's in...

>>

Thank you for your help. It is not a big deal for me either, is just that I want to group the columns together according to its content, as you said...

To be honest, Kim, I have no idea whether the mistakes are yours or the book's.  I don't have the book (or any other book on this subject, FWIW!). 

But...