sounds like homework...

There are three choices:

a triangular self join,

a recursive CTE, or

a "quirky update" approach.

If it's homework, go for the first. If it's performance critical and there are people...

What's the data type of StartTime?

Gagne (12/22/2010)

---

...

Lutz, that sounds like you're saying that generally speaking, virtualizing a SQL Server will impact performance and that it's all a question of whether it will slow it down...

Here's my approach:

; WITH cte AS

(

SELECT dt,id,MAX(statusdate) AS max_statusdate

FROM ReportDate rd

LEFT OUTER JOIN CustomerInfo ci ON ci.statusdate<=rd.dt

GROUP BY dt,id

)

SELECT

dt AS [Report DATE] ,

SUM(CASE...

I, personally, find Brent Ozar's blog[/url] very informative ,especially including the comments and the follow-up article. Those two articles combined give a neutral (if possible at all) point of view...

Paul,

it seems like you're not really interested in helping us help you.

Instead of providing the information we asked for multiple times you decide to open new threads with the...

Instead of using SELECT * you'd need to specify each column and use alias column names for the duplicates (like a.ACCOUNT, b.ACCOUNT, a.COD, c.CODE and maybe some more columns).

The reason...

Something like the following code? (assuming all...

Here's a version that will provide the structure as requested based on Waynes sample data and sample code (Thank you, Wayne!!).

However, due to the DTD declaration you won't be able...

May the Holidays be silent and without any release changes you need to take care of!

My plan for the Holidays (with my kids):

We have slightly more snow than...

I'll have a look at it within the next hour. Promise.

Here's a short SQL puzzle for you:

SELECT @answer = result FROM...

Please read and follow the instructions given in the first article referenced in my signature,...

sotn (12/22/2010)

---

Hi Lutz,

thanks for the reply.

I am a little confused as my previous post shows that my tables have completely different field names and number of fields so I cannot...

Yes (concept as mentioned before).

For a coded version please provide ready to use sample data as described in the first link in my...