I've heard it called BKAC (Between Keyboard and Chair), and ID-Ten-T (ID10T). 🙂

You might also want to look at these e-books available here:

SQL Server Maintenance Plans by Brad McGehee[/url]

Mastering SQL Server Profiler by Brad McGehee

SQL Server Execution Plans by Grant Fritchey

Utsab Chattopadhyay (4/15/2010)

---

Also as a side note, you should be able to use your 2005 and all other older instances using 2008 client tools. So may be you want to...

gregory.anderson (4/15/2010)

---

What is the purpose of this select, is this just to create the temp table since it will never work (because 1 does not equal 2)?

SELECT

...

Thanks Toby.

Thanks Tom! Nothing like a little pressure for any future articles......

See if this gets what you need.

-- start off with the test data

-- See how you start off by actually creating a table and then

-- inserting the data into...

duplicate post. Please direct all replies to the other thread at http://www.sqlservercentral.com/Forums/Topic903697-149-1.aspx

You know, the people that help out here are all un-paid volunteers. Providing the DDL scripts (CREATE TABLE, CREATE INDEX, etc.) for the tables affected, and INSERT statements to put...

Based on this sample data, what do you want the output to look like? I'm just not understanding what it is that you are wanting to get out of this.

I'd vote for this being the top 1 weird business spec :w00t:

I utilized the...

Happens to all of us at some point. I initially thought it might be because the TM symbol might need to be specified as unicode.... but it turned out to...

mranganwa (4/14/2010)

---

Hi

works nicely but when I encounter a string like this one

INSERT #Test VALUES('TBM907 - 16/03: provided a new ,of TBM908 - 02/03: TBM908 has TBM908')--- I want to extract...

GSquared (4/14/2010)

---

I clicked Lynn's name, opened "All User's Posts" and opened the discussion for the first one that mentioned DDL. Didn't need to know it involved a CTE. ...