If it's two really distinct entities, then, yeah, I agree with everyone else, two tables. From the names you gave, Sponsor & Offer, it sure sounds like two distinct entities....

Alvin Ramard (10/13/2010)

---

Grant Fritchey (10/13/2010)

---

Alvin Ramard (10/13/2010)

---

Change of topic for a second.

Has anyone here tried reading a pdf format ebook on a Kindle3? I'm thinking about getting a Kindle...

Alvin Ramard (10/13/2010)

---

Change of topic for a second.

Has anyone here tried reading a pdf format ebook on a Kindle3? I'm thinking about getting a Kindle and I'm just wondering...

I'll...

The LOOP join is a hint where they're trying to force a choice on the optimizer. In addition to fixing the scan, I'd test taking out that hint to see...

Whoa! Wait a minute....

Although, if you need to insert values into a table that has an identity column, you can make it possible using IDENTITY_INSERT

SET IDENTITY_INSERT myschma.mytable ON

Just remember to set it to...

If you haven't looked at the execution plan, you really need to. When you don't know what's happening with a query, that should be your first stop.

Also, be very, very...

I'm OK with the xxx part. Sorry that was just meant to designate '*' or 'whatever' or 'fillintheblank.' My only exception was with the Hungarian notation on table names.

I don't know how Access is calling this, but the TSQL command has correct syntax and should work. You might want to schema qualify the tables to ensure that you're...

If the function is embedded in other statements you'll probably need to generate the list of places where it's used and then run the server-side trace as Gail suggested, looking...

Oh please no, not tables named TBxxx. That's just so 1992 (not to mention, very, very Access). Surely, at this point in history, we can simply name a table, or...

Over time the characteristics of the data that makes up the indexes could change. This can result in different execution plans. Based on what you're saying, I think this is...

You do have to define refresh. For example, we do a regular "refresh" where in we move the production database down to our QA environment through a backup and restore....

In regards to the question, it does fill books. I'd take a look at the first two chapters of Itzik Ben-Gan's book, Inside T-SQL Querying. It's a good overview of...