As said, it depends on what you want to do:

CASE 1: EmpID, BookID -...

Can you script out the table definition and show it to us?

Thanks,

Jeff Moden (11/29/2008)

---

Heh... Great Circle calcs to find closest... doesn't seem to be needed especially in the Temperate zone of latitudes and longitudes limited to only 1/8th the circumference of...

Huhn, the bug happens on my last remaining SQL 2000 server also. MAXDOP has no effect on it.

Let us know how these work out.

Hmm, it occurs to me now, that there is another possibility here, that instead of si.Qty, you really intended to use ip.Quantity, which can vary for every Item Purchase. ...

Getting "only whole numbers" from an equation is almost always a datatype problem, easily fixed, and...

Did you try mine?

Jeff Moden (11/28/2008)

---

Ummm... not if it's a partitioned view...

Yeah, but he's getting dupes, even from the Group By categories, Jeff.

Chris: FWIW, I am not seeing this on my Laptop.

Heh. Now that sounds like the ancient art of Wi-Yi-Yotta.

😛

Jack: You'll probably need a MAX or MIN on your "total_sold" in the columns list.

... And the only reasons that I can think that you would use this are:

1) Minor Security nit: because you do not want the client software to know the names...

I do not believe that it affects SSMS or the query window in any discernible way.

All VIEW_METADATA does is to change how the returned columns are defined to...

Like this:

/* Displays Store Name and Items that were Purchased from that Store that have been in Sales Transactions and the Items Sales percentage */

CREATE VIEW STORE_SALES_ITEMS99

([Store Name], [Store...