Hey checkai, thanks for the response.

This is quicker cause it's not doing a whole table scan. It is still doing an index scan but it's quicker than what I...

I'm a moron do you know that!

Of course the reason I was returning N when using Varchar is becuase I never specified how many characters I wanted back

Thanks for your...

Hey,

For example, for todays date, I'd like:

Nov 2009

Cheers Steve, I looked at BOL, however I didn't notice 113.

🙂

Thanks for anyone who looks at this, however, I found the answer

select replace(convert(char(11),getdate(),113),' ','-')

Cheers

Thanks, I checked BOL but at first didn't understand the explanation. I've went into Job alert and looked at properties and this shows the GUI set up

Cheers

Thanks for responding. So, just to clarify, that's every 15 minutes all day?

Thanks

Hi folks,

Similar to what Greg posted, here is another method. Both have advantages and disadvantages, but together they should give you a good idea of how to use a tally...

First of all, I'd like to thank everyone for the input to my thread, without this sort of help, i'd be lost, so one day I'd like to help as...

Thanks both for responding.

Lynn, yeah, I noticed the mistake I made, I actually meant that the year ends on the last Saturday and starts on the last Sunday of March....

Thanks again

Hi Gail,

Thanks again for responding to my threads; you've been very helpful.

I wasn't sure if it worked on 2000 so just wanted to be sure. At the moment I'm...

Hi there,

I've not read the article yet, and yes, I agree that I should provide code and samples. it's a little tricky with this one cause there's so many...

Hi, thanks for the response. I managerd to sort my problem out by using a view instead. The code's a bit convoluted so I think it's best if...

Thanks Drew for your help. I'm working on the code just now and will let you know how I get on.

Cheers

Paul