thanks, that worked!

I contacted the vendor to inquire on how the app is converting the seconds to datetime and his response is.....

The app doesnt recognize if it is daylight savings or not,...

I am a visual person. Would you mind showing me examples of how I would incorporate this into the script above?

Jeff Moden (6/25/2008)

---

Then what in the application is giving you the offset of either 5 or 6 hours? Could it be that all the times are assumed to be...

If you mean do we store the time zone in a table then I would have to say no (unless its...

Carl Federl (6/24/2008)

---

Looks like a POSIX time that is adjusted for a time zone of negative 6 hours (India?) - POSIX or UNIX time is the number of seconds since...

anyone?

I was able to figure out how to do #1 by adding a table to that cell. Anyone know if #2 is possible?

Ok, I was able to do a workaround by totaling up the rows in SQL instead of SRS, however, now I have 2 more issues. The attachment is part...

noeld (6/11/2008)

---

I would also vote for the use of a calendar table but just for the fun of it:

declare @mindate datetime, @maxdate datetime

select @mindate = left(convert(char(10),dateadd(m,-2,getdate()),112),6) + '01'

select @maxdate...

Thanks Matt!

One more thing, if either reg_hrs or reg_ern is NULL, I want to display zero. I used ISNULL but it still output NULL. How can I accomplish this?

SELECT...

That worked! Thanks everyone!

Jason Selburg (5/14/2008)

---

Under Properties > Options for the database. But if it's SQL 2000, the CTE will not work.

Try this instead.

SELECT

a.name

,reg_hrs

...

Matt Miller (5/14/2008)

---

is250sp (5/14/2008)

---

The db is on 2000, but I am using Management Studio 2005 to query. Where do...