Because temporary tables always end up in tempdb - so the temporary table reference would try to resolve from the local server. You might be able to use server.tempdb..##tablename though,...

That's not actually correct. They disappear when the following...

That's a mixture of a new style JOIN and an old style JOIN

I could do

SELECT * FROM table1, table2 WHERE table1.col = table2.col

That's an old-style join

What has been done...

Nope - your browser is fine.

Top job Lynn.

It's this sort of article that really keeps me on my toes with respect to the SQL I write - there's almost always a better way, and this...

If you're saying you have a load of DOCX documents in BLOBs then I would advise you to export them, use a batch converter, and import them back in.

Trying to...

Another

WITH HighestYears AS (

SELECT *, ROW_NUMBER() OVER (PARTITION BY [LRSN] ORDER BY [EFF_YEAR] DESC) __rn

FROM dbo.VALUATION)

SELECT *...

I know this is the 2k5 forum - but if you have the opportunity to use 2k8, you might want to look at MERGE.

Well it is called SQL Server Standard 😀

Are you sure? Reason I...

David Portas (9/19/2009)

---

Fair points Matt. So to extend the psychological convenience argument, if I find it convenient NOT to have a primary key because in some particular case I don't...

David Portas (9/19/2009)

---

Of course I agree that candidate keys and foreign keys are important in database design. The practice of designating one candidate key to be "primary" however is essentially...

David Portas (9/19/2009)

---

The important question is not "what should be the primary key?" but "what are the business rules?". That's why I deplore the primary key concept, which I'd like...

...in fact - do we even know that that index...

Ian Scarlett (9/18/2009)

---

There's a good chance that this

(empcode between '99201' and '99205' or empcode between '99211' and '99215' or

empcode between '99241' and '99245' or empcode between '99354' and '99355'...