Isn't that just a LEFT JOIN?

SELECT a.Col1, a.Col2, a.Col3, a.Col4

FROM #TableA a

LEFT JOIN #TableB b

ON a.Col1 = b.Col1 AND a.Col2 = b.Col2 AND

...

Here's another way that eliminates the need for the outer query:

SELECT TeamID, AssignedTask

,r=RANK() OVER (ORDER BY AssignedTask) +

...

Let's start by correcting your DDL and sample data so that it will run in MS SQL (converted to temp tables to reduce clutter in my sandbox):

CREATE TABLE #TABLE_1

(

Field1...

wolfkillj (7/23/2013)

---

Brandie Tarvin (7/23/2013)

---

I don't know why you're making this reference in regards...

Brandie Tarvin (7/23/2013)

---

As a writer and editor (outside of SQL Server), I believe it's incumbent upon the author to set reader expectations at the outset. That being said, if an...

As this is a MS SQL forum, I couldn't help but make the assumption that your db is MS SQL.

I can't imagine there'd be much syntactical...

I'm as big an advocate of DelimitedSplit8K in the SQLverse as you're gonna find, but in this case I'd say there's a simpler way:

;WITH SampleData (ID,PartNumber)

AS

...

Oracle765 (7/22/2013)

---

I have a query in one of my procedures which causes an error.

select substring(expirydate,1,(charindex(' ',expirydate) -1)) as expirydate

from newtable

this query looks through my expiry date field and looks...

SQLRNNR (4/15/2010)

---

Here is another excellent article on...

Matt,

Since you're new here, I'm going to help you out and show you how to post a question so as to get a decent answer. Articles abound throughout the...

rackerland (7/22/2013)

---

If I understand what you're asking for correctly, this should do it:

SELECT C.Name, SUM(P.Total), SUM(O.Total)

FROM Customer AS C

LEFT OUTER JOIN [Order] AS O

ON O.CustomerID = C.CustomerID

...

L' Eomot Inversé (7/22/2013)

---

Just as described, but if I'd realised who wrote it I would have made the...

HanShi (7/19/2013)

---

If you are able to specify on which column you are searching, then below is a simple solution:

create procedure search_row

(

@skills nvarchar(100) = null

, @position nvarchar(40) = null

, @location nvarchar(50)...

You'll probably want to use a dynamic catch-all query[/url].

jace.bennett (7/18/2013)

---

Yup that just about does it I think. Thanks so much for that.

Particulars of the projection aside, my original question was about how this style query plays with views....