Do you have a new_RelatedProjectId column in your new_projecttasksBase table?

That's the error, not really a syntax error on the joins, probably a misspelled column name.

Thank you, that's actually addressed...

You're probably right. I'm not sure what prevents MS to include...

Just as an FYI for the others, Khanacademy doesn't use SQL Server. Entering to the site, I found this:

That's why the...

Kim Crosser (9/30/2015)

---

OK OK - I give!!!

I hereby take the No-UDF pledge.

From now on, I will never use a UDF. Instead, I will only write Select statements that include...

Kim Crosser (9/30/2015)

---

In addition to Try_Parse, there is a new function Try_Convert, which does what IsNumeric should always have done.

set <output_value> = Try_Convert(<type>, <source_value>);

Try_Convert returns the source_value converted to the...

Some templates can be inserted by using:

Ctrl+K, Ctrl+X or Ctrl+K, Ctrl+S

Depending on what you have configured in the Code Snippets Manager (in the Tools Menu or Ctrl+K, Ctrl+B).

I know is...

Peddi Praveen kumar (9/30/2015)

---

Hi Luis,

Another Approach for "Like" Search is to Use "DataLength" And "Replace" together, as shown below:

Begin

declare @lv_search_string varchar(100);

select @lv_search_string ='Parker'

SELECT * FROM dbo.LIKETest WHERE DATALENGTH(Name) <>...

I assumed that PremID was a row identifier, which would handle that when we include it in the partition of the row_number() functions. If it's not, add the TaxYear column...

ChrisM@Work (9/30/2015)

---

Brandie Tarvin (9/30/2015)

---

ChrisM@Work (9/30/2015)

---

An unsolicited email has just dropped into my Hotmail inbox from a recruitment agency touting a permy dev DBA role in Soho (London) paying £50k to...

I believe HADR is HARD. 😀

That's what I call keeping your computer safe. Where can I get one of those security devices? 😀

It might be easier to just add 3 months. 🙂

SELECT PremID,

PolicyID,

DATEADD( MM, 3, CAST(...

What are you trying to accomplish with the condition WHERE Value LIKE '%' + Value + '%'?

Unless NULL values are involved, that should always evaluate to true.

The first one fails because you're trying to use the alias as a table. That's not how alias work, you can use them to qualify columns, but not in place...