Sorry, this function is from this article[/url] by Jeff...

One to make you smile if you have 2012:-)

DECLARE @smiley varchar(20) = 'Dont Worry Be Happy';

WITH Params AS (

SELECT MAX(CASE WHEN ItemNumber = 1 THEN Val END) OFFSET,

MAX(CASE WHEN ItemNumber...

J Livingston SQL (6/16/2014)

---

my effort...too much time on my hands 😀

DECLARE @Question VARCHAR(100) =

'The Answer to the Ultimate Question of Life, the Universe, and Everything'

DECLARE @Source VARCHAR(100) =

'The Hitchhikers...

Promise this will be my last one:Whistling:

DECLARE @Question VARCHAR(50) = 'Year that England last beat Italy?'

SELECT CAST(

POWER(LEN(Italy),ItalyLastScore) *

POWER(LEN(England),EnglandLastScore) *

(LEN(@Question) / (ItalyLastScore + EnglandLastScore))

- (ItalyTotalWins - EnglandTotalWins)

- (TotalDraws /...

Without wanting to pick on any nation in particular;-)

SELECT TeamName + ': '+ CAST(Score AS VARCHAR(2))

FROM (VALUES ('England'), ('All Blacks')) team (TeamName)

CROSS APPLY (

...

To stick with a theme 🙂

DECLARE @Team1 VARCHAR(10) = 'Italy'

DECLARE @Team2 VARCHAR(10) = 'England'

SELECT @Team1 + ': ' + CAST(LEN(@Team1) % 3 AS VARCHAR(2)),

@Team2 + ': ' + CAST(LEN(@Team2) %...

Must read question properly before answering. Missed the pick 3 😀 .... again. Time for coffee.

Good question Andy

I avoid that create/design view window myself. It has a tendency to get itself mucked up and I don't particularly like the way it formats things. Though I...

Good to hear you worked it out 🙂 Another option is to build a physical Tally[/url] table or use a construct like the following

WITH base10 (N) AS (

...

Also good question, thanks Andy

+1 on the missed 1:-D

Hi All

I've generally found the STContains is no better performing than STIntersects and in some cases worse as it needs to verify that an object in completely enclosed.

I have also...

Are you able to post up some...

The trick...

Hi

I've had a look at a few options and for the data the I'm testing on, this appears to be the best solution (for SQL 2012 +). It is...