CREATE TABLE #T (

ID INT IDENTITY

PRIMARY KEY,

[2008] INT,

...

I just edited the original post to make the link fully explicit.

bitbucket-25253 (3/3/2011)

---

GSquared (3/3/2011)

---

If anyone's interested in what I've been working on the last six months or so, last night (late) we launched VisitOrlando.com.

While you won't see my ETL and database...

SQLkiwi (3/3/2011)

---

GSquared (3/3/2011)

---

I've found that if you insert from a remote server into a local table variable, it avoids the DTC overhead, or at least some of it. Huge...

Interesting. The forum must be adding that in, since the link...

It's easy to find local stored procedures, views, et al, that hit those tables, by querying sys.sql_modules and checking the definition column. That'll get you started.

To check for all...

What's "best" will depend on what you're doing with the data.

A common solution is to insert the results into a temp table, and if @@rowcount = 0, then...

Eric M Russell (3/3/2011)

---

When I need to join a resultset from a remote server, like from a linked server connection, neither a View or TVF are beneficial. I'll typically execute...

If anyone's interested in what I've been working on the last six months or so, last night (late) we launched http://www.VisitOrlando.com.

While you won't see my ETL and database work on...

Jeff Moden (3/2/2011)

---

GSquared (3/2/2011)

---

Koen Verbeeck (3/2/2011)

---

GSquared (3/2/2011)

---

Actually, to partially refute my own assertion, I was once told why I wasn't hired. It was because "I was too strong a...

Excel only allows 31 characters for tabs.

Not sure what you're trying to accomplish, but could you simply add a "table of contents" in the first sheet, with the actual e-mails...

Schemas aren't automatically bound to users in SQL Server 2005 and later. They were in SQL 2000, but not any more.

You'll need to associate the user with a default...

Makes sense.

You might want to contact Steve about your posts. He's the one you'll get if you click "Contact Us". Just to be polite.

gk-764578 (3/2/2011)

---

It's a good product that's been in development for over 5 years, and does what you'd need to do. We've followed forum etiquette correctly to attempt to advertise a...

Tracking down row multiplication in complex Outer Join queries requires access to the actual data.

What you're going to need to do is break the query down into smaller parts, and...