mpdillon (2/12/2013)

---

ChrisM and DwainC,

Thank you for the reference. I had actually seen that before. I used it as best I could. But since it didn't use the lookup table, I...

Something like this then:

;WITH Trans (ID, TransactionAmt) AS (

SELECT '1',20000 UNION ALL

SELECT '1',30000 UNION ALL

SELECT '2',40000 UNION ALL

SELECT '2',20000 UNION ALL

SELECT '2',20000 UNION ALL

SELECT...

Note that I posted the query plan in my previous post in case someone wants to take a shot at that analysis.

I would love...

Apparently changing the language from english to spanish changes the @@DATEFIRST value from 7 to 1.

I didn't realize that side-effect. Interesting...

It also accounts for why I didn't see it...

ChrisM@Work (2/11/2013)

---

Something like this?

DROP TABLE #mytable

CREATE TABLE #mytable

(P_KEY INT IDENTITY(1,1) PRIMARY KEY CLUSTERED,

LAST_DAY_OF_MONTH...

Another shot in the dark. Maybe the OP wants the minimum amount from unique transactions for each ID?

;WITH Trans (ID, TransactionAmt) AS (

SELECT '1',20000 UNION ALL

SELECT '1',30000...

Lynn Pettis (2/11/2013)

---

UPDATE [tblTransactions] SET [AllocatedDate] =...

p.ramchander (2/11/2013)

---

;WITH Punches AS (

SELECT *

...

Sean Lange (2/11/2013)

---

ahpitre (2/11/2013)

---

How can I use this function to search for more than 1 character? I have data that is delimited by either a comma or semicolon (,;). Need...

Michael Valentine Jones (2/11/2013)

---

dwain.c (2/11/2013)

---

If you don't like magic numbers, I think you can do it this way too:

select

a.DT,

LastDayofMonth = dateadd(mm,datediff(mm,-1,a.DT),-1),

LastSundayofMonth =

dateadd(dd,(datediff(dd,'17530107',dateadd(mm,datediff(mm,-1,a.DT),-1))/7)*7,'17530107'),

DwainsWay =

...

No idea because I don't know what Day 01, Day 02, etc. are supposed to represent.

MAX(day_value)-DATEDIFF(minute,MIN(punchTime), MAX(punchTime))/60.

p.ramchander (2/11/2013)

---

I agree with you vinu. Dwain's logic is very nice and simple. Thanks Dwain for your time and help. I replaced the logic with your's.

Now, I created a table...

kevin 20860 (2/11/2013)

---

thank you. I had something similar to that so was heading in the right direction but as they say the devil is in the details.

I'll check it...