mluszczynski (10/16/2014)

---

Good point 😉 but that won't fix your stats. I would prefer...

I get 2 rows as you can see in this link:

It's a bad week for QOTD 🙂

Because ID is not a reserved word as column. If you want to use SELECT column...

jaimepc199 (10/15/2014)

---

Hello everybody

My apologize for this "mistake" over the QOTD, i really don't know what happened since the original query was:

CREATE PROCEDURE my_sp AS

SELECT columns FROM my_table

My intention was...

paul.knibbs (10/15/2014)

---

Maybe the author chose the column name deliberately to catch out people who just run the SQL rather than thinking about their answer? I mean, the error about incorrect...

By the way, no error if you use this syntax:

CREATE PROCEDURE my_sp AS

SELECT [column] FROM my_table

Same error: Msg 156, Level 15, State 1, Procedure my_sp, Line 2

Incorrect syntax near the keyword 'FROM'.

I do, in fact, understand the MERGE statement, but for some reason checked the wrong box when I was picking the answer. The question and answer are on different tabs...

I see I'm not the only one who checked Sales as valid answer. Now I feel better 🙂

Hi SQL Lover,

my mistake, not user but developers. Let me try to explain how it works. We have RFCs and developers solve them providing us with queries...

Hi,

thanks for your answer. This is just for a QA environment and it won't run in Live. What I'm trying to do is just save that information,...

I've used VMWare Player (now Player Plus) and VirtualBox. Both are good, unfortunately it's not so easy to change from one to another (I've tried this week).

With a PC...

Thanks Chris, it worked fine. 🙂

This is a definition for a field in a very nice view I've designed to solve a problem:

(SELECT INTERNETID

...

Thanks Jeff, I will review the article, it looks exactly what I need.