Except if you combine both

-ABS(value)

would always give you a negative result...

The problem you will have with FTS is that it will ignore the braces and end up with a word list of

Bill

Esquire

Smith

Smitty

Will

William

Willy

so you could end up with incorrect output...

After meeting you, don't know why but it conjures up an image of you in a pinny...

whoa! too much information...

Meh! Moderator's perogative 😉

On 2008R2 Dev Edition it produces NULL even when following the actionss in the question and yes I had to restart SQL server when changing security.

Whilst this does not detract...

Jeff Moden (7/21/2011)[hrGood idea but the dual 11,000 row Tally Table has 30 years of "capability"... doing it directly as you have limits the functionality to 299.16666666667 days. 🙂 ...

How about a simpler approach

SELECT DATEADD(minute, (t.N - 1) * 30, @DateStart)

FROM dbo.Tally t

WHERE t.N BETWEEN 1 AND (DATEDIFF(day, @DateStart, @DateEnd) + 1) * 48

ORDER BY t.N...

Yes he is.

Lynn Pettis (7/19/2011)

---

And yes, I remember well the "Bankers Rounding". I seem to remember that my solution turned out to meet David Burrows requirements, or did he have to...

Jeff Moden (7/19/2011)

---

Zowie! I think I've known you even before I knew Lynn and Gail! Now that I think about it, I believe Remi fits in that same...

Jeff Moden (7/19/2011)

---

Good golly, Miss Molly! I just looked back at how many posts there are about my nomination. Thanks, Gianluca, for bringing it up. I'm at...

Also check that you are using my latest query (repeated below)

Also check the WHERE clause as this could drop lines giving a false impression that the query is not working

SELECT...

ringovski (7/12/2011)

---

Many thanks for your help :-D, but it is still not what I need.

I have uploaded a spreadsheet that shows the difference. Invoice ID 135393 only has one...

ringovski (7/10/2011)

---

And you got gets an error when I compile it;

Msg 4145, Level 15, State 1, Line 22

An expression of non-boolean type specified in a context where a condition is...

All being well, will...