This seems like it me be getting you towards the path you are looking for??

SELECT *

FROM EMP_Facts f JOIN Survey_EMP s ON

f.Survey_Key = s.Survey_Key

WHERE (s.Question = 'Q1')

AND

exists (SELECT...

You can go to tools -> options -> Environment -> fonts and change the colors for keywords. Their is not an option for "dangerous" words. The list would go on...

You realize your question is sort of the same thing as "Why is my computer is running slow sometimes"? There could be any of about a zillion reasons this is...

This sounds like a process change rather than create mountains of duplicate data. How are you going to even know which copy belongs to the original? This just sounds like...

Ed Zachary

Guess I need to pick my head up off my pillow...that happens after lunch sometimes. 😛

This was actually the topic of yesterday's QOTD.

Here is a link to the ensuing discussion.

David.Poole (11/11/2010)

---

This is on my list of "stupid things no-one in their right mind would try" and I apologise to any DBA for revealing how you do this.

EXEC sp_addlinkedserver 'ExcelSource',

...

It is still handled through VBA. If you familair with VB6 this will not be a big stretch. I have done tons of this stuff but it has been several...

They can come in pretty handy if you have the same datatype stored in multiple locations that are either enterprise or business specific. For example you might create a datatype...

This should fix that method Gail, although I suspect a convert would yield better performance.

SELECT Left(Col1 + SPACE(32), 32)

I thought maybe they stood for no chance this person is qualified for the "DB_Developer" position and should therefore keep looking for the entry level position. 😛 You will not...

I don't really get what you are trying to do but..

select top 1 (SUBSTRING(@ADDRESSLINE, nullif(patindex('% '+a.format+' %', ' ' + @addressline + ' '), 0), len(a.pattern)))

FROM tableA a

WHERE f.Country =...

So you are storing a calculated field that could just as easily be calculated when you need it? Then once a year you update the calculated field with a new...

And that is why I wrote a simple gui for looking at the top 20 rows of a table. Has few other odds and ends too. I can post it...