fahey.jonathan (1/24/2012)

---

I misread the original post. I thought the goal was to...

Jonathan,

Nearly but not quite, that just gets next thursday. Not the next first thursday of the month.

Here's another version loosely...

Matt,

There is however a difference I'd not spotted initially :blush: between the solutions for the 1 Feb 2012

The original solutions result is: 2 Feb 2012

Yours is: 1 Mar 2012 :w00t:

Nice one matt, I thought the original looked well overcomplicated when I saw it.

thanks

derek.colley (1/17/2012)

---

The problem is resolved now, whatever it was. I ran them in the right order so not sure why it borked. There isn't a complete script -...

I see from your error message that the error is on Line 54, maybe there's something causing the issue in the other 40+ lines of your script? Can you post...

And it looks he's succeeded! No sign of the OP :crying:

Hugo Kornelis (1/4/2012)

---

Thanks for the question, Stuart!

The dollar and pound sign are valid in conversion from string to money or smallmoney (normally followed by the actual amount); the dot is...

A situation where the on-the-fly may be useful is when you don't know in advance what range of dates you might need, and don't want 40000+ rows (representing 1-1-1900 to...

I use a table valued function which takes two parameters, a start and end date.

It returns 1 row per day starting on the specified start date up to, but *not*...

Another option without using recursion at all:

;with Dates as (

SELECT TOP (DATEDIFF(dd,'20100101','20110101'))

CalendarDate = DATEADD(dd,ROW_NUMBER() OVER(ORDER BY (SELECT NULL))-1,'20100101')

FROM sys.columns A, sys.columns B

)

SELECT

...

There's no need to use a while loop, it's unnecessary!

You can find non-matches in a string in one line...

Aha! I found where you hid it eventually 😀

There's no need for a loop! What's wrong with PATINDEX for this sort of thing?

SELECT PATINDEX('%[^A-Za-z0-9 ]%', 'ABC 123')

SELECT PATINDEX('%[^A-Za-z0-9 ]%', 'ABC*123')

But it's still not there Jon ! :w00t:

Ha, excellent! 😛

Do you have a power...