If he creates the views and has access to the views, what's the problem?

This is one of the reasons to avoid using separate columns for dates. You should use date data types. Not only will you be able to handle dates more efficiently,...

You also seem not to be using this part:

LEFT JOIN

(

SELECT RI.ResNumber,

...

The columns used in the filter don't need to be in the SELECT column list.

However, the results of a query could change if you remove a column from the column...

Quinn

That's not fair. Where were you a couple of months ago? 😛

Kutang Pan (8/5/2015)

---

Hi Luis,

Thanks for that. I've started preparing a list of some Q/A but i can't find a nice one about dynamic sql writing. I would like check the...

I was expecting that there should be a PRINT statement missing inside the loop. Eventhough I decided to go with the correct answer, apparently for the intended reasons (PRINT outside...

WayneS (8/5/2015)

---

Luis Cazares (8/4/2015)

---

Lynn Pettis (8/4/2015)

---

SQLRNNR (8/4/2015)

---

Lynn Pettis (8/4/2015)

---

SQLRNNR (8/4/2015)

---

Steve Jones - SSC Editor (8/4/2015)

---

Since we're all piling on the behavior of others, I was wondering.

Is there value in getting...

You could check these articles:

http://blog.waynesheffield.com/wayne/archive/2012/06/interview-questions/

http://www.scarydba.com/2009/04/30/database-screening-questions/

Grant Fritchey (8/5/2015)

---

Well, Luis is right. It won't run and therefore will return zero rows. But that question is an extremely poor demonstration of SQL Server knowledge. However, the provided...

Eirikur Eiriksson (8/5/2015)

---

c'est...

I was going to suggest something like using FETCH LAST and BREAK to control your WHILE loops.

However, I wanted to get a little bit further and suggest a set-based option.

This...

fnndala2 (8/5/2015)

---

I have the following SQL-Query:

CREATE FUNCTION fn_SelectTopEmployees ()

RETURNS TABLE

AS

RETURN

(

SELECT TOP(10) EmployeeID

FROM Employees

);

When I run the query, how many times between 1 and 10...

Lynn Pettis (8/4/2015)

---

SQLRNNR (8/4/2015)

---

Lynn Pettis (8/4/2015)

---

SQLRNNR (8/4/2015)

---

Steve Jones - SSC Editor (8/4/2015)

---

Since we're all piling on the behavior of others, I was wondering.

Is there value in getting the questions/knowledge that...