Setting ANSI_NULLS off would give you the expected results. But I won't recommend on doing that other than general testing for additional knowledge.

:exclamation:Important

In a future version of SQL Server, ANSI_NULLS...

g.britton (10/29/2015)

---

SQL uses three-value logic. So anything = NULL evaluates to False and anything <> NULL also evaluates to FALSE. Also, NULL = NULL is FALSE as is...

ChrisM@Work (10/29/2015)

---

Ed Wagner (10/29/2015)

---

yb751 (10/29/2015)

---

I was on my last eye twitch yesterday (so to speak) so I put together this image. (attached)

I was thinking about unleashing it but then I...

dbman (10/29/2015)

---

Hello,

I have actually got the data importing into APP1 table, however im struggling to see how APP2 and other APP lines can be split to begin a new import...

Try querying:

sys.views

sys.sql_modules

sys.columns

What specific metadata do you need?

Just so you know, a well written cursor or while loop can be better than a recursive CTE. I made a test some time ago and it's published in here:...

This is how I would do it if there's no option to correct the data to save the date as a real date and not part of the string.

CREATE...

Unless otherwise specified, the default settings are used, which include...

My guess is that Steve selected the wrong answer as correct answer, as the explanation says all the rows are returned.

He's at PASS Summit, so he might not be able...

Yes, it's needed to...

Jessica

This looks very similar to a running total problem (except that there's no total). This can be managed by the quirky update, a cursor or a triangular join. Here's a...

You can either download the last version of SQL Server Management Studio which is "standalone". https://msdn.microsoft.com/en-us/library/mt238290.aspx

Or you can download an express version of SQL Server which includes it (be sure...

You can use cross tabs to convert rows into columns. You can fine more information in these articles:

http://www.sqlservercentral.com/articles/T-SQL/63681/

http://www.sqlservercentral.com/articles/Crosstab/65048/

Here's an example based on your sample data.

SELECT MAX( CASE WHEN id =...

Brandie Tarvin (10/27/2015)

---

Lovely.

We have the URLDefense ProofPoint software to prevent bad URL links. But when the site goes down, so does our ability to navigate to the sites in the...