Ed Wagner (6/25/2014)

---

Koen Verbeeck (6/25/2014)

---

Ed Wagner (6/25/2014)

---

SQLRNNR (6/25/2014)

---

Koen Verbeeck (6/25/2014)

---

SQLRNNR (6/25/2014)

---

Koen Verbeeck (6/25/2014)

---

ChrisM@Work (6/25/2014)

---

djj (6/25/2014)

---

Just saw a post (on another site) that the person had part of a query list...

And you might want to take a look at your sample data. It will not execute as posted. You are missing ' around all your dates.

itortu (6/25/2014)

---

Hi Sean, I trimmed the number of rows to 500 just to make sure there is enough data to work the 3 methods that calculate the DaysToPay value.

The...

Alan.B (6/25/2014)

---

Gents

First: Dang it Sean - you beet me to it! I had a very similar solution but you posted yours first. That said, I did do a performance test...

Oompa...

eng.sarah.kandil (6/25/2014)

---

Thanks for your reply, but when I try to do this I get an error because of the size of the database it is 50 GB and it allows...

Lowell (6/25/2014)

---

smacking myself in the head!

I didn't think of using FOR XML to handle the concatenation; that, sir, is beautiful and inspired.

You'd think i'd know better, so double kudos...

REM

BOL (Books Online) explains how to do this.

http://msdn.microsoft.com/en-us/library/ms190209.aspx

How or why is this "best practice"? I create joins in the...

Doll

Great job posting ddl and sample data. Any chance you can trim the data to a few dozen rows instead of thousands? Also, what we need to understand is what...

Taking your fine code as a starting point I came up with this. I didn't test against a million rows but I think maybe I will do that now.

CREATE FUNCTION...

luissantos (6/24/2014)

---

Hello Sean

Thanks for your reply, also i solve like this:

DECLARE @meubanco CHAR(10)

SET @meubanco = '1'

SELECT

cast(replace(@meubanco,'',' ')as char(10)) + conta

FROM bl

Maybe, that´s make no sense,...

Implode