ChrisM@Work,

Just curious, but I've never seen anyone use an ON clause together with CROSS APPLY. Given that it's an ON 1=1, it would seem to be completely unnecessary,...

Well, they probably aren't blocking causes, but just taking a look at the query itself, I see some things that jump out as odd. For example, there are...

The original article on which this discussion is based was not intended to be...

Divine Flame (1/28/2015)

---

True, but then again most people who actually wait for & want to read an interesting article from SSC, will be disappointed after seeing this kind of information...

John Corkett MBCS (1/26/2015)

---

Hi,

I was wondering, would you say that this is the same as using a view in a query? The view is in effect a subquery. If you...

C64DBA (1/26/2015)

---

They do have use. For some complex queries, the engine sometimes needs help. Adding a derived table in just the right part of the query can make it easier...

srajpx (1/26/2015)

---

I believe that for each row of the first subquery, the second subquery is executed. Say, the first sub query returns 100 rows, for each of this row the...

Purely from...

Not sure if anyone is aware, but for this particular article, a sub-query isn't even necessary. All that is needed is a column perspective instead of a row...

What are you going to do when there's a holiday on a business day? Just looking to create the equivalent in an SSRS expression isn't going to solve...

Yeah, don't EVEN get me started down THAT road... 'Tis a slippery road, and many a folk out there who see the road as half ice instead of...

Please note that you have yet to say exactly what error you are receiving and at what point in time. Any ideas I've had so far have been...

Thanks fpr the info. Interesting that someone coined the term "DAS", because while SATA or e-SATA would qualify under that umbrella, so would a USB attached drive, as...

I'm not sure that CTE's are available in SQL 2000 either. I can't remember. You can check Books Online, or maybe just Google it. ...

Okay, then perhaps its the setup of the subscription itself, as I suspect that you may have that field that was removed in use within it, and if you haven't...