I just noticed it was published by Sybex, which is pretty well known so I suppose that speaks for itself, but any input would be appreciated. Thanks!

I was looking at picking up this book as a study aid for the MCITP: DBA 2005 to DBA 2008 upgrade. Anyone have any experience with it or the...

GilaMonster (5/19/2010)

---

There's no upgrade path from MCTS 2005 to MCITP 2008. The upgrade that's available is from MCITP 2005 (either dev...

Alright... I functionified this:

CREATE FUNCTION [dbo].[ConvertUnixDate]

(

@TimeValue int

)

RETURNS datetime

AS

BEGIN

DECLARE @DateTime datetime

DECLARE @GMTOffsetInSeconds int

DECLARE @isDateDST bit

DECLARE @isCurrDateDST bit

SET @GMTOffsetInSeconds...

Ignore code in prior post... here's snippet I've been working with to test conversion:

select datediff(ss,'01/01/1970','03/16/2010')+18000

--***********************************************--

declare @unixdate int

--set @unixdate = 1268544600 --Mar 14, 2010 1:30am

--set @unixdate = 1268548200 --Mar 14, 2010...

Sorry for the necropost, but this is the closest topic to an issue I'm having that I could find.

dateadd(s,@UnixDate,'01/01/1970') works to convert a Unix date to a Julian date, however,...

Still have table scans on TABLE1 and TABLE2. Processing time unchanged.

Lynn Pettis (1/5/2010)

---

lbrigham (1/5/2010)

---

First post, be kind. 🙂

I'm looking for a better way of doing the below as what I'm doing now results in a table scan and I know...