Maybe if the function is only there to cope with null dates being stored as an origin point like 1st January 1900 or 1st January 1753, then he could replace...

Experts might tell you to look at the actual execution plan to see where the costly parts of the query are, but it might just confuse you as a beginner...

If you are looking in the Object Explorer in SSMS you will need to expand the "System Tables" folder within the "Tables" folder (and possibly right click and Refresh), then...

Are there...

If you really cannot move the ORDER BY to the outer query that uses the view, then you could use the TOP 2147483647 (or a smaller number if that is...

The topic was teaching beginners how to move things into a CROSS APPLY from other parts of the query, so they can be reused instead of repeating their definition. The...

It's worth being aware that CROSS APPLY works kind of like an inner join, but OUTER APPLY works kind of like an outer join, so if your APPLY statement is...

I have noticed sometimes that when I run a package interactively in BIDS (or SSDT or whatever its called now), it will hang for ages without doing anything at all,...

For very simple calculations like your example, it's normally fine to simply do the whole calculation in the SELECT part of the query, accepting that there is a little bit...

I sometimes use OUTER APPLY to avoid repeating a formula instead of using a CTE, but I'm not sure which method is more efficient. For example:

SELECT

Column_1,

Column_2,

Column_3,

10*Column_1 AS Column_4,

OA.Column_5,

Column_1*OA.Column_5 As Column_6

FROM...

I've aware that when you concatenate strings, the data type of the entire concatenated string will be set according to the implicit data type of the first item, which can...

In my version of VS2010 , File > New >Project > Installed Templates > Business Intelligence > Analysis Services, then choose "Import from Server (Multidimensional and Data Mining)" or "Import...

I was looking for a function like that a while ago to help me identify UK car registrations that were issued consecutively (our company buys vehicles in bulk and sometimes...

Heh, heh, sounds like a Yoda quote. "Do or do not, there is no y". Perhaps in the original poster's system, field [comm_url] is always either null or 'Automatically...

Eirikur Eiriksson (10/19/2014)

---

On the contrary, it is very useful as it respects the left outer join, which in essence return all records from the right hand side and only those...