Re: time conversion hiccup

(tatata9999@xxxxxxxxx) writes:

Good News! Problem resolved. Culprit, 'WHEN (datediff(n,start,stop)/
60 > 0)' needs to be
WHEN (datediff(n,start,stop)/60.0 > 0)

Great to hear! Thanks for posting back and telling us. I'm taking the
liberty to not look at your scripts then.

--
Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
.

References:
- Re: time conversion hiccup
  - From: tatata9999
- Re: time conversion hiccup
  - From: Erland Sommarskog
- Re: time conversion hiccup
  - From: tatata9999
- Re: time conversion hiccup
  - From: Ed Murphy
- Re: time conversion hiccup
  - From: tatata9999
- Re: time conversion hiccup
  - From: Erland Sommarskog
- Re: time conversion hiccup
  - From: tatata9999
- Re: time conversion hiccup
  - From: Erland Sommarskog
- Re: time conversion hiccup
  - From: tatata9999

Relevant Pages

RE: Web site - SQL Server 7.0 users and integrated security
... LOGINS found on SQL Server 2000 Books online helps you ... This posting is provided "AS IS" with no warranties, and confers no rights. ...
(microsoft.public.sqlserver.security)
Re: If, Then statement that results in other if, then statements
... I don't know why you were you were unsuccessful with posting your ... question to an Excel newsgroup. ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... Books Online for SQL Server 2005 at ...
(microsoft.public.sqlserver.tools)
Re: SSMS External Tools
... Sorry, I misread your posting, I thought you were asking where the forums are. ... SQL Server Documentation Team ... SQL Server 2008 Books Online: ...
(microsoft.public.sqlserver.tools)
Re: Access to the remote server is denied because the current security context is not trusted. [SQLS
... How about checking the date first before posting? ... Eggheadcafe. ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... Books Online for SQL Server 2005 at ...
(microsoft.public.sqlserver.server)
Re: Problems with remote conexion
... Yeah that one as well! ... Thanks for posting back! ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... Books Online for SQL Server 2005 at ...
(comp.databases.ms-sqlserver)