While I agree that the DelimitedSplit8K function is likely to be of help here I want to point out that the datatype containing the csv data is varchar(max) which does...

Tallboy (6/13/2014)

---

I think it should be something like

SELECT PersNo, 4WeekEnd, TotalWorkedHours, TotalContractHours

From

WITH TblWorkedHours @WeekEnd

(Select

PersNo,

Max(WeekEnding) As 4 WeekEnd,

Sum(WorkedHours) As...

julian.fletcher (6/13/2014)

---

Sorry, I should have said. Yes, each is a header - detail type of arrangement. In my example of "parent = an organisation, child = a contract held with...

Again...using the sample data from pietlinden what is the expected output? Not a written explanation but the actual values as you want to see them.

jasona.work (6/13/2014)

---

Ed Wagner (6/13/2014)

---

Jack Corbett (6/13/2014)

---

GilaMonster (6/13/2014)

---

Thought process of last 10 minutes.

- Tune a proc quick, then go home

- Wait, it's got user defined functions

-...

Ed Wagner (6/13/2014)

---

Jack Corbett (6/13/2014)

---

GilaMonster (6/13/2014)

---

Thought process of last 10 minutes.

- Tune a proc quick, then go home

- Wait, it's got user defined functions

- Wait,...

To add to Luis' comment about ordering. You would need some sort of column like an identity but when you select the data you need to add an ORDER BY...

And much appreciated by anybody...

Bacon!!

Let's use the excellent sample data and ddl that pietlinden posted. That is how you should post stuff in the future.

What should be the output from the sample data? The...

Koen Verbeeck (6/13/2014)

---

Sean Lange (6/12/2014)

---

below86 (6/12/2014)

---

Sean Lange (6/12/2014)

---

below86 (6/12/2014)

---

I'm just looking at our 'new' datawarehouse design, a former DBA helped start. All the table names start with 'tbl'. :w00t:...

breakfast

Tallboy (6/12/2014)

---

Hi,

This is a problem I have been working on for some time, but Im still unsure how to proceed.

I have a simple table with the following columns

Tabel Name -...

cbrammer1219 (6/12/2014)

---

Ok, that ran, but it is terribly slow, The function from Jeff returned the data fast, although within characters it put the counts in one row, and would like...

cbrammer1219 (6/12/2014)

---

Ok, that ran, but it is terribly slow, The function from Jeff returned the data fast, although within characters it put the counts in one row, and would like...