The SQL Sharp library is (I'm pretty sure) a CLR.

ericjorg (2/20/2014)

---

... I truly need a regex solution because the format of the text is not known ahead of time. The customers will be providing regular experessions to match the...

irobertson (2/20/2014)

---

Interesting this. Intuitively, my head says that pre-calculating the max value should be more efficient when compared with using a correlated subquery:

declare @MaxId int

select @MaxId = max(col4) from #TableB

insert...

🙂

That brought a...

Well Z, as far as I can tell you've changed your requirements (again) so now I don't know whether you want a running total or just the hours split on...

SQLRNNR (2/19/2014)

---

Yeah but...

Hearty congratulations on this accomplishment!

I'm struggling to get to 4000 posts because of all the inane questions being asked lately. 😛

zulfansari (2/19/2014)

---

Hi Dwaine,

You are amazing, how do you come with such codes? 🙂

When cumulative Double total is less than 9 then you are right hours stay as they are.

Can I...

OK Z, here's the deal. I started getting the impression that you were walking us through the solution in the way that you thought it should be solved, leading...

Jeff Moden (2/18/2014)

---

zulfansari (2/18/2014)

---

Hi Guys,

I'm sorry about the confusion, I guess I should take it step by step, first I need to add a total column as the last column...

Not sure if this will work for your general case but it works for your sample data (I think):

WITH SampleData (PERSON, [DATE], [HOURS], PAYCODE, TOTAL) AS

(

SELECT...

Sigh. Now your desired result doesn't contain the row that says Triple.

You'd probably be better off directly answering the questions I asked, rather than reiterating what you already posted.

kwoznica (2/18/2014)

---

Thanks Dwain. Very Nicely Done! This won't be the first time you've helped me. Perhaps one day I can repay you.

Also I checked the real table definition and...

zulfansari (2/18/2014)

---

Hi Dwain,

From the sample data I need to check if the Double Paycode has reached 9 hours, once it has, I use that date as the effective date with...

Jeff Moden (2/18/2014)

---

tonyabrhm (2/18/2014)

---

Hi

I am trying to create a query which shows data from the past 1, 2, 3 4 and 5 years in seperate columns. I beleive I have...