Without sample data, we can only guess at the outcome.

Try this for your OT calculation

CASE WHEN ( [friday] = 1 and [day] = 'Friday' )

...

Since this is SQL 2012, you could also use TRY_PARSE

SELECT

TRY_PARSE('13.2' AS DECIMAL(18,2) USING 'en-US')

, TRY_PARSE('13,2' AS DECIMAL(18,2) USING 'de-DE')

Are you able to get the source data as quoted values

SELECT ID, txt, REPLACE(val, ',', '.') AS val

FROM (

VALUES (1, '1 Value', '18,2'),

...

Eirikur's solution groups by PaymentComfirmDate.

In order to group by Year/Month, you will need to use something like this, which groups by the 1st of every month.

-- ...

MonthYear = DATEADD(mm, DATEDIFF(mm,...

Jay@Work (10/30/2016)

---

I'm getting variable (read bad!) results for what should be something simple.

I have a table that has 2 columns that are relevant to this query.

Amount and PaymentDate.

I want to...

Briceston (10/29/2016)

---

Thanks for the response. I'm still a bit confused. I'm trying to employ your CTE example, but I'm getting constant errors, mainly in the case statement. I know this...

I just realised that you are using SQL 2008, so you will need to look at the old solution that only uses ROW_NUMBER()

This blog post[/url] explains the solution.

Something like this

--CREATE...

OK, so move the entire case...

hoseam (10/28/2016)

---

I have two tables

and

CREATE TABLE [dbo].[Status](

[AccountID] [varchar](20) NOT NULL primary...

If I understand your requirements correctly,

you can try changing this

sum((dutyhours)-(minutes /60.0)) as OT

to

case when ( [friday] = 1 and [Day] = 'Friday' )

or...

Use this as a starting point

WITH cteReAdmission AS (

SELECT ReportingYear, RegArea

, isReAdmission = CASE WHEN DATEDIFF(DAY,

...

Take a look at New Solution to the Packing Intervals Problem.

Hint: You may want to add an index on (customer, startdatetime, enddatetime, rownumber) (prefereably clustered)

Jeff Moden (10/27/2016)

---

Consider what you may find in the following two articles... especially the second one...

[font="Arial Black"]Hierarchies on Steroids #1: Convert an Adjacency List to Nested Sets[/font][/url]

[font="Arial Black"]Hierarchies on Steroids...

drew.allen (10/27/2016)

---

Actually, XML uses Unix-style line terminators (LF) rather than Windows-style (CR/LF), so it's not necessary to test for CHAR(13) unless the XML document specifically contains the character encoding for...

Hope this makes sense. I understand bitmaps, but I have difficulty in explaining them. (So do I really understand it)

If you have 2 lamps, which condition means that they...