Another method -

DECLARE @startdate DATETIME

SET @startdate = '2011-11-18'

SELECT TOP 1 DATEADD(dd, Num, DATEDIFF(dd, 0, @startdate))

FROM (SELECT 1 AS Num UNION ALL SELECT 2 UNION ALL SELECT 3) AS a

WHERE (DATEDIFF(dd,...

There's probably a way to do this with just a DATEADD statement, but off the top of my head I can't think of one.

Anyway, this should work: -

DECLARE @startdate DATETIME

SET...

L' Eomot Inversé (11/30/2011)

---

I replied too quickly before, didn't cover all bases before getting it wrong. I knew there wasn't a typo in the question, and didn't consider the...

L' Eomot Inversé (11/30/2011)

---

wloong (11/29/2011)

---

I agreed!

From the programming logic, "v2 = v3"...

Got it wrong because I believe it should say "v3 = v2" not "v2 = v3"

This is a bit of a wild stab in the dark, so probably not quite what you're looking for.

BEGIN TRAN

--Standard TestEnvironment of 1,000,000 rows of random-ish data

IF object_id('tempdb..#testEnvironment') IS NOT...

Hello and welcome to SSC!

Unfortunately, it seems that your readily consumable sample data and DDL scripts have fallen off your post. Or perhaps you were unaware of the benefits...

Dev (11/29/2011)

---

I was about to share Wikipedia URL here (but you already did 🙂 ).

You are right. The terms they are using have wide scope (and pretty much...

Dev (11/29/2011)

---

Thanks for sharing your thoughts but I am kind of confuse why it should / should not affect SSC.

I don't live in US and kind of curious...

No.

That's not to say I support it, since it will affect several other sites that I frequent, but it won't affect SSC.

Here's a few different methods.

BEGIN TRAN

SET NOCOUNT ON

IF object_id('tempdb..#testEnvironment') IS NOT NULL

BEGIN

DROP TABLE #testEnvironment

END

--1,000,000 Random rows of data

SELECT TOP 1000000 IDENTITY(INT,1,1) AS ID,

varcharDateTime

INTO #testEnvironment

FROM (SELECT TOP 999999

...

No problem. I'm not sure I know...

Ask your DBA for permissions.

Sorry for the wait, something came up.

OK, first I fixed your sample data.

SET NOCOUNT ON

CREATE TABLE #temp (RowNum INT, PostCodeDistrict CHAR(3), Latitude DECIMAL(18, 3), Longitude DECIMAL(18, 3))

INSERT INTO #temp (RowNum,...

I'd take a look, but without readily consumable sample data and ddl scripts I'm unwilling to. I don't want to spend my whole lunch hour setting up a test environment...