SQLRNNR (9/20/2011)

---

SQL Kiwi (9/20/2011)

---

I actually tried running this command before I posted it. :pinch:

I clicked 'cancel' nearly ten minutes...

On the point of Linux "not taking over the world", keep in mind that iOS and Android are both *nix-based systems, as is OS X. So *nix may very...

Just ignore Joe. He hasn't figured out yet that most people post a sample related to their problem instead of posting potentially proprietary code, data that might have legal...

Got it on the bottom half. Now the top part.

SAMPLE CLIENT

229-1953

4221 N.E. 17 TERR.

OAKLAND PARK

FLORIDA

06/18/08

7/10/2008 4:10:27 PM

MURRAY R/B PUSH

CHECK OUT SERVICE *( CUST. NRW PLUG )*

CLEAN FUEL SYSTEM CARB....

Fire up a search (Boogle, Ging, whatever) for "query active directory in sql server". There are a bunch of good articles available on the subject.

Define "first".

I don't see a column in there that indicates which one is first. Unless this is a text file or Excel spreadsheet or something like that. In...

A "stack dump" isn't a specific error. It's what Windows does when it's logging certain errors. There isn't an "error code" or "error number" for a stack dump.

GilaMonster (9/20/2011)

---

GSquared (9/20/2011)

---

L' Eomot Inversé (9/20/2011)

---

WayneS (9/20/2011)

---

GSquared (9/20/2011)

---

Of course, I'm also one of the few people I know who tries to terminate every T-SQL statement with a semicolon. Not...

It's probably AD credential information. If so, it's hashed for security reasons.

You can reverse-engineer the hashes easily enough, or pull in the AD data and query against that. ...

L' Eomot Inversé (9/20/2011)

---

WayneS (9/20/2011)

---

GSquared (9/20/2011)

---

Of course, I'm also one of the few people I know who tries to terminate every T-SQL statement with a semicolon. Not needed, but...

WayneS (9/20/2011)

---

Normally, I'd agree that it's pretty weird. But then again, I know you... 😀

I just have to ask......

Gianluca Sartori (9/20/2011)

---

GSquared (9/20/2011)

---

Depending on your ANSI NULLs setting, it might try.

SET ANSI_NULLS OFF;

CREATE TABLE #T (

ID INT PRIMARY KEY);

INSERT INTO #T (ID)

VALUES (1),(2),(3);

SELECT * FROM #T;

MERGE #T AS A

USING...

Gianluca Sartori (9/20/2011)

---

L' Eomot Inversé (9/20/2011)

---

Gianluca Sartori (9/20/2011)

---

SQL Kiwi (9/20/2011)

---

Ninja's_RGR'us (9/20/2011)

---

Try doing ;with () Without any select after the with and you'll see if the engine thinks the statement...

Ian Scarlett (9/20/2011)

---

All of this just reiterates the need to make job candidates answer real technical questions and/or sit a relevant test as part of an interview.

You have to take...

GilaMonster (9/20/2011)

---

Brandie Tarvin (9/20/2011)

---

GilaMonster (9/20/2011)

---

<pedantic>

CTEs don't start with a ';', no more than an...