ScottPletcher (10/9/2015)

---

A subquery can refer to a column in the outer/main query. Thus, SQL is comparing the column to itself. You need to prefix the column with the...

lshanahan (9/15/2015)

---

You're asking the wrong question.

The question of "What makes a good developer" is highly dependent upon your industry, your work environment, methodologies and a hundred or more other factors,...

Just went through something similar. Accepted the counter offer and now waiting for the new opportunity to come kiss me. The wait is difficult one to deal with and sometimes...

+1.

Easy point. 🙂 Thanks for sharing.

Here are a few other approaches and there impacts:

-- Recursive CTE approach (Hidden R-BAR optimal for thousands to few hundred thousand rows.)

WITH cte_Split_String

AS

(...

-- Tally Table approach (No R-BAR optimal for millions of rows.)

CREATE FUNCTION udf_splitString

(

@STR NVARCHAR(MAX),

@sep NCHAR(1)

)

RETURNS TABLE ...

Great utility! I am working on implementing a similar solution. Will post an update if I can fine tune it.

Alan.B (9/16/2015)

---

You need PERCENT_RANK which is not available In SQL 2012.

To get the Percent Rank Pre-2012:

If rk is the RANK for the specified partition

AND rc is the row count...

Nice question. Learned a different approach today.

Great question. Thanks. Makes me want to go back and change some code.

You can start with this:

http://blog.sqlauthority.com/2007/12/26/sql-server-truncate-cant-be-rolled-back-using-log-files-after-transaction-session-is-closed/

http://www.sqlservercentral.com/Forums/Topic1488704-391-1.aspx

If you are a beginner then you need to understand how DELETE, DROP and TRUNCATE work instead of...

JeeTee (11/21/2014)

---

As I'm thinking about this more (with the somewhat limited amount of information I have) two things come to mind.

The first is to build a calendar table; basically an...

Kev T (11/25/2014)

---

It'd be good if the explanation included the reason for such a seemingly random year of 1753. 🙂

For those that may not know, it is because of the...

Easy one. Thank you for the question.

+1