Lynn Pettis (4/29/2016)

---

Alan.B (4/28/2016)

---

Something like this would not work:

CREATE TABLE LovelyTable(

Join varchar(50)

)

SQL Server is generally very good at dealing with reserved keywords as column names but its a terrible practice....

Sergiy (4/28/2016)

---

Jeff Moden (4/28/2016)

---

A lot of people incorrectly consider CROSS APPLY to be RBAR because it behaves like a correlated subquery when single row returns are produced by CROSS APPLY....

I believe so.

Yet Another DBA (4/27/2016)

---

jeff.mason (4/26/2016)

---

Microsoft has made SQL Server so big that even "generalists" are usually "specialists". I know of few people who are experts in the DB engine,...

To clarify, the Microsoft Certified Solutions Expert cert has two paths: Data and BI.

If you're using the default port number then you don't need to include it in your connection string. If your DNS server resolves the server name without the fqdn then...

What do those values mean? Where are they coming from? How did they get there?...

Those ORDER BY clauses in your SELECT INTO queries aren't doing you any favors.

I was thinking

PRINT '2016 Total: 700'

Try

="MSC000000002"&"C00303582"&"MSC000005747"&"MSC000006211"&"MSC000000067"&"C01938137"&"MSC000000061"

There's one out there that I've seen since SQL Server 6.5. It reads something like:

The one that drives me...

DUPLICATE POST, direct replies here.

There's no performance benefit to using/not using reserved words...

Something like this perhaps...

"MSC000000002" & "C00303582" &"MSC000005747" &....

Something like this would not work:

CREATE TABLE LovelyTable(

Join varchar(50)

)

SQL Server is generally very good at dealing with reserved keywords as column names but its a terrible practice. Column names like...