They are.

Cool biz.

Was a response to Gift's implicit "nolo contendre". Nothing that...

You need to select a Join between the current and previous data, not separate inserts.

Something like:

select *

from #Current

full outer join #Previous

on #Current.InvoiceDate = #Previous.InvoiceDate;

So far as I know, you can't add buttons to reports. Reports are just data presentation. Would a link do what you need?

Or do you mean on the...

You don't select directly from the index. You select from the table.

If the index is appropriate, SQL Server will use it when you do that.

To really "get" indexing, you...

Gianluca Sartori (4/8/2010)

---

Lynn Pettis (4/8/2010)

---

You know how at work one aw s**t wipes out a thousand atta boys? In parenting it's one atta boy wipes out a thousand aw...

Good article.

It's always a good thing to open yourself up to more viewpoints.

That wouldn't be it. At least not directly. I'm running SSRS 2008 on Win 7 on my desktop right now, and it works there.

I had to handle something...

Gianluca Sartori (4/8/2010)

---

WayneS (4/7/2010)

---

As a parent, you always need to be ready to follow through on any threat that you make. And the sooner you do it, the sooner the...

Edit: Removed by popular demand.

Shouldn't your screen name be "PPilate" if you're going to be asking that kind of question? 🙂

CirquedeSQLeil (4/7/2010)

---

GSquared (4/7/2010)

---

Alvin Ramard (4/6/2010)

---

GSquared (4/6/2010)

---

Since I'm closing in on...

This will break up the days/month string:

DECLARE @Days CHAR(24);

SELECT @Days = '252020251920242019251919';

;WITH Numbers (Number) AS

(SELECT TOP 12 ROW_NUMBER() OVER (ORDER BY OBJECT_ID) * 2

FROM sys.columns AS C)

SELECT SUBSTRING(@Days, Number-1, 2)

FROM...

Gift Peddie (4/7/2010)

---

Lynn,

When I say a product comes with limitations I know the current internals of the product...