You sure can.

I'm not sure why we're stuck on using a values clause to do this, but the expressions in a value clause may include sub-queries so long as they...

Apostrophes are also good for accenting sounds which are unpronounceable by human mouths.

Ph'nglui mglw'nafh Cthulhu R'lyeh wgah'nagl fhtagn

Paul: I wasn't aware this was a Speed Phreak challenge. 😀

8kb: If you're willing to change the clustered index structure to the...

In the example below, a CROSS APPLY technique manages to run a hair faster with an execution plan that goes directly from an index scan into a clustered index seek,...

On my laptop, I'm getting subsecond response time using data generated by your script and no additional indexing. But I'm testing by writing to a temp table....

The VALUES clause is one source of data to be inserted, but a SELECT clause can also be a source of data for an INSERT.

See the...

Pardon me, are we talking about something other than T-SQL?

I ask because in T-SQL there is no...

Brit's what? That's what I want to know.

Brit himself is a pretty decent fellow.

No!!

I disappeared!! :w00t:

The CHAR(4) is a datatype, as opposed to INT or VARCHAR or DATETIME, etc. It indicates that the 4 digits of the years are being stored as...

ALZDBA (9/16/2010)

---

A single printout may even...

Avatar? What avatar?

I see you, Jason.

avi-631555 (9/16/2010)

---

To insert a value from a table into a warning statment

my script currently is as

Update table A

Set RptStatement = ' watever you comapnyName @2010'

where (...

WayneS (9/16/2010)

---

But we do appreciate...