Re: time conversion hiccup

On Oct 7, 9:36 am, Erland Sommarskog <esq...@xxxxxxxxxxxxx> wrote:
(tatata9...@xxxxxxxxx) writes:
Interesting idea, Erland, but it did not seem to work for me, maybe I
didn't do it right? Only two variations.

We have only seen fragments and pieces of what you have been doing. It
would help if you posted a create table statement for your table, insert
statements with sample data, and the desired result given the sample.
That makes it easy to develop tested query. Without that, we are mainly
guessing.

--
Erland Sommarskog, SQL Server MVP, esq...@xxxxxxxxxxxxx

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

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

Many thanks.

.

Relevant Pages

  • Re: Problem With SQL UPDATE
    ... INSERT statements with sample data. ... With the first three it's to copy and paste into a query editor to ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... Books Online for SQL Server 2005 at ...
    (comp.databases.ms-sqlserver)
  • Re: SQL question
    ... JOIN tbl b ON a.UserID = b.UserID ... INSERT statements with sample data. ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... Books Online for SQL Server 2005 at ...
    (comp.databases.ms-sqlserver)
  • Re: time conversion hiccup
    ... We have only seen fragments and pieces of what you have been doing. ... statements with sample data, and the desired result given the sample. ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... Books Online for SQL Server 2005 at ...
    (comp.databases.ms-sqlserver)
  • Re: Many to one Select
    ... It still possible to define a query that has maximum of columns needed, ... INSERT statements with sample data. ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... Books Online for SQL Server 2005 at ...
    (comp.databases.ms-sqlserver)
  • Re: Breaking down Total Hours worked into Day and Evening hours
    ... INSERT statements with sample data. ... Essentially a calendar is a table with one row for each day, ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... Books Online for SQL Server 2005 at ...
    (comp.databases.ms-sqlserver)