Jeff Moden (8/28/2015)

---

Mike Dougherty-384281 (8/28/2015)

---

Why are we still emailing tables of data?

Can't we have whatever triggering event send a link for a full-featured data explorer to our preferred communication provider...

I think everyone has had that combination at one time or another.

For this reason and others, I always specify a column list when performing an insert. The exception to that rule is when I do a SELECT INTO.

Andy Warren (8/28/2015)

---

Mickey, I try to put stuff like that on a list, helps me feel a little more in control, and sometimes when I need a break I'll grab...

Steak

GilaMonster (8/28/2015)

---

They're not. They are named subqueries.

If you consider them temporary views, you're going to keep running into situations...

Scott, I agree with you that the point is to run a business. You raise a good point about perspective. It may be that cutting off all access...

Luis Cazares (8/28/2015)

---

mar.ko (8/28/2015)

---

I want the EXEC right after the CTE.....no can do.

I put a semicolon after the last paren of the CTE and that throws a syntax error.

Something strange...

White Potatoes

Hugo Kornelis (8/28/2015)

---

When I want to make sure that my query...

Grill

Sean Lange (8/27/2015)

---

Ed Wagner (8/27/2015)

---

I'm glad I'm not the only one who notices the sp_ prefix to the procedure name and knew what it meant. 😛

It will slow you down...

Lynn Pettis (8/27/2015)

---

Silver spoon, you post a question and then remove it? Why?

Reported the "post" deleted by OP, suggested removing the post entirely. Why leave a non question...

The synonyms reference database objects, so if you use the two-part naming conventions as Scott suggested, then that's what they'll resolve to when the code runs.

ZZartin (8/27/2015)

---

whereisSQL? (8/27/2015)

---

Ed Wagner (8/27/2015)

---

whereisSQL? (8/27/2015)

---

Ed Wagner (8/27/2015)

---

Revenant (8/27/2015)

---

Ed Wagner (8/27/2015)

---

Onion...