I think both solutions should run on SQL 2005.

kk 93815 (10/2/2012)

---

Thanks laurie and dwain.c.

dwain.c i like your approach as it's bit simple but please can you give some explanation so that it makes more sense to me......

Equivalent should be:

IF ISNULL(@MyNumberReturn, '000000') = '000000' THEN

...

Thanks for giving it a shot Tom.

Looks like you changed your avatar and signature.

DECLARE @Table1 TABLE

(Month2Date VARCHAR(15), Yesterday VARCHAR(15), PrevMonth VARCHAR(15))

INSERT INTO @Table1

SELECT 'Month to Date', 'Yesterday', 'PrevMonth'

SELECT * FROM @Table1

Not trying to be funny here (OK maybe a...

Record 1 is also part of the group defined for 2 and 3 (groupid 50) and you didn't say how you wanted that to be handled (unless ignoring as you...

kapil190588 (10/2/2012)

---

I have a table CityMaster, LocationMaster and Location table from another database. In LocationMaster CityID (int) is stored while in Citymaster (CityID, CityName, StateID) fields are stored, in Location...

Davin21 (10/2/2012)

---

Interesting stuff!

Is there any specific reason when we do the following

DECLARE @Date1 DATETIME SET @Date1= '2012-08-28 11:53:00'

select CAST(cast(@Date1 AS float) AS DATETIME)

That we lose 3 ms in the process...

There are 41147 days between 1900-01-01 and...

You may want to take a look at this article, by our own, beloved Joe Celko: http://www.simple-talk.com/sql/t-sql-programming/contiguous-time-periods/

Looks darn near a tie to me, but if you're buying the beers on our next fishing trip, I'll concede to your snapper.

If you just need hours (from the truncated startdatetime):

DATEDIFF(hour, DATEADD(day, DATEDIFF(day, 0, EndDateTime), 0), EndDateTime)

If you need like HH:MM:SS, that's a bit more challenging but doable.

If you want to get fancy-smancy, you could do it like this:

CREATE TABLE #Users

(UserID VARCHAR(20) NOT NULL

,Created_DT DATETIME DEFAULT (GETDATE())

...

In that case, the startdate just becomes the end date truncated to midnight:

SELECT *

,NewStartDT=DATEADD(day, DATEDIFF(day, 0, EndDateTime), 0)

FROM #sampleData

Ahhh... enlightnment can be a scary thing.