Viewing 15 posts - 3,301 through 3,315 (of 14,953 total)
SQLRNNR (9/20/2011)
SQL Kiwi (9/20/2011)
GilaMonster (9/20/2011)
SQL Kiwi (9/20/2011)
Amateurs.
SELECT REPLICATE(CONVERT(VARCHAR(MAX), CHAR(39)), 9223372036854775807)Apostrophes all gone :laugh:
Memory too. :crash:
I actually tried running this command before I posted it. :pinch:
I clicked 'cancel' nearly ten minutes...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
September 21, 2011 at 6:55 am
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...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
September 21, 2011 at 6:51 am
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...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
September 21, 2011 at 6:39 am
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....
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
September 21, 2011 at 6:26 am
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.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
September 20, 2011 at 1:06 pm
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...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
September 20, 2011 at 12:51 pm
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.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
September 20, 2011 at 12:48 pm
GilaMonster (9/20/2011)
GSquared (9/20/2011)
L' Eomot Inversé (9/20/2011)
WayneS (9/20/2011)
GSquared (9/20/2011)
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
September 20, 2011 at 12:46 pm
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. ...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
September 20, 2011 at 12:43 pm
L' Eomot Inversé (9/20/2011)
WayneS (9/20/2011)
GSquared (9/20/2011)
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
September 20, 2011 at 12:38 pm
WayneS (9/20/2011)
GSquared (9/20/2011)
Actually, I've had my resume plagiarized. How weird is that?
Normally, I'd agree that it's pretty weird. But then again, I know you... 😀
I just have to ask......
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
September 20, 2011 at 12:32 pm
Gianluca Sartori (9/20/2011)
GSquared (9/20/2011)
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...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
September 20, 2011 at 10:41 am
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)
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
September 20, 2011 at 9:26 am
Ian Scarlett (9/20/2011)
You have to take...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
September 20, 2011 at 6:49 am
GilaMonster (9/20/2011)
Brandie Tarvin (9/20/2011)
GilaMonster (9/20/2011)
Brandie Tarvin (9/20/2011)
CTEs (i.e. ;WIth () ... SELECT ) are single statements in this context, yes?
<pedantic>
CTEs don't start with a ';', no more than an...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
September 20, 2011 at 6:45 am
Viewing 15 posts - 3,301 through 3,315 (of 14,953 total)