GilaMonster (9/5/2012)

---

Brandie Tarvin (9/5/2012)

---

jcrawf02 (9/5/2012)

---

bitbucket-25253 (9/5/2012)

---

Time for me to toot my own horn ... braging HECK yes.

My 73rd QOD has been scheduled for 06 Sep 2012 - 07 Sep 2012

Should...

ScottPletcher (9/5/2012)

---

Since the table already contains the previous year's YTD totals, would a simple LEFT JOIN suffice to get the prior year's YTD total?

SELECT

t1curr.cod, t1curr.[year], t1curr.[month],...

Looks fine to me, Tom. Thanks for the feedback.

Here's a version which corrects for aTime being more recent than bTime, and...

This might be better than the CASE:

With MyCTE (aTime, bTime)

AS

(

SELECT convert(datetime2,'1900-01-01 00:08:00.0000001'), convert(datetime2,'1900-01-01 00:09:18.361')

UNION ALL SELECT '1900-01-01 00:08:00.0000001', '1900-01-01 00:13:50.705'

UNION ALL SELECT '1900-01-01 00:09:18.361', '1900-01-01 03:13:50.7050001'

...

vinay.varaala (9/5/2012)

---

select dateadd(mm, datediff(mm, 0, @ThisDate) - 1, 0) -- Beginning of previous month

getdate()-- current date

my question I want the records from beginning of previous month to today ..wats...

This is far too vague. What are you...

"Deferred execution" - the next best thing to "Let off the hook" 😀

Thanks for an excellent read, Paul.

Tricky but not impossible: this is just a proof of concept.

With MyCTE (TheTime)

AS

(

SELECT convert(datetime2,'1900-01-01 0:08:00.0000001') UNION ALL

SELECT '1900-01-01 0:09:18.361' UNION ALL

SELECT '1900-01-01 0:13:50.705'

)

SELECT

*,

CAST(f.q AS...

It's probably the missing batch separator "GO" after the...

woody_rd (9/5/2012)

---

Sorry for the confusion, guys. Let's see if this explains it better. I have come across an issue where a table logs conditions with

a timestamp, eventid...

Same here. I wonder what the secret...

After correcting [val].

Koen's nailed all the good reasons for not persisting this information. It's easy enough to calculate on the fly:

-- This running total uses a triangular join.

-- The performance of TJ's...

ChrisM@Work (9/4/2012)

---

Of course - but you will get a solution much quicker if you can set up DDL and DML for some sample...