Yes.

How about sample data including your current query as requested before?

Sounds like homework.

If not, please provide sample data, expected result and what you've tried so far as described in the first link in my signature.

The only place I can think of would be the transaction log file.

Other than that: AFAIK there is no hidden date recorded.

Gagne (1/28/2010)

---

Lutz thanks for the reply. I've learned about Tally tables here in the forum and I already have a few but the "Cross Apply" is new to me....

@Lynn: you might want to prepare your tent to hold a bunch of people arriving shortly... 😉

Can we just stop by or do we need to show an invitation?

You'd need a CROSS APPLY against a table holding some numbers (aka Tally table - please see the related link in my signature).

Based on a tally table the code would...

You've crossed the line of professionalism twice already in this thread.

I strongly recommend to step back from the keyboard for a moment, take a deep breath and think...

sol.nt (1/28/2010)

---

I don't understand the business case / concept....

Would you...

Maybe you can replace some views with CTEs / subqueries instead of having a view for each calculation.

For unit testing you could use the OUTPUT clause and store the results...

ColdPolarBear (1/27/2010)

---

Thanks for response - However, I am looking for a dynamic solution. Your suggestion creates a new table based only the data that I provided as sample data. I...

It's more an issue of CrossTabs or even DynamicCrossTabs.

I gues it can be done in CrystalReports, but I'm not sure (never worked with it...).

You might want to have a look...

The result you get is exactly what you've been asking SQL Server to do:

select -- print the output

8 -- output is supposed to be the number "8". If you'd like...

Glad it worked. 😀

Btw: Did you notice how I "translated" your "descriptive sample data" into ready to use SQL code?

If you provide data in such a format you'll increase the...

Lynn Pettis (1/27/2010)

---

Okay, I'm lost on how you are lost. Please, what did you miss? It was...

Seems like I totally missed the point. Sorry about that... :blush: