As requested...Sorry about the lousy format...

Anton

-- Original Data

CREATE TABLE #Table_Orig (PartNumber int, FILEVERSION varchar(100), VALUE varchar(100))

INSERT INTO #Table_Orig VALUES (1234, 'CURRENT', 'A B')

INSERT INTO #Table_Orig VALUES (1234,...

One thing to note is that the color doesn't show up when doing an action that doesn't have a status bar (Edit Top 200 Rows, Design, Add Table).

Too...

Thanks for the tip. Learned two items today. Registration of servers and how to set colors.

Has anyone tried the SSMS Tools pack add-in? Any stability...

Good QotD...As usual, it seems the best way to learn new items is to take a little quiz on them. I learned a couple of new things today..just not...

tom.w.brannon (8/14/2013)

---

I use numbers in my order by statements every day for short queries. It is faster than typing out long names and is especially nice when the column...

Great question (I like that you included explanations of the build in function).

However, I cannot see the use/value of the "NULLIF" construct. In what situations would you use...

Koen Verbeeck (8/9/2013)

---

Another one of those A-HA moments, was when I discovered you could select a block of text in SSMS while holding ALT (which is also possible in other...

All,

OK, add the "EXCEPT" and "INTERSECT" clauses to my list. I was asked to compare a file used to load our master parts data from last week's file...

Very good question...We use FREETEXTTABLE instead of CONTAINSTABLE in our FTS table searches. Thought for sure that the 3 was characters and not words apart.

I always...

Non Tech Side: Our "New Horizons" band is getting back together this fall. Getting the trombone out again.

Tech Side (SQL): Doing C# at work for the last...

A couple of more suggestions to have your voice heard..

There is a link on the SQLServerCentral home page for a user survey. The survey has a "what can we...

tom.w.brannon (5/3/2013)

---

I've learned to read the discussions about all the questions because I learn things there as well. Did not know about adding a number to GO to get...

The new format is not a step in the right direction. Too much scrolling...Hopefully we don't have to wait 8 months for the dot one release of the fixes.

Otherwise...

Tom,

Sorry, I should have been more clear. For example...Oaks returns O200.

Anton

At least here in Michigan the result of a Soundex of your last name is the same as (or close to) the first 4 characters of your driver's license number....