Well here's another point of view from someone who's not in accounting or financial.

I need to display to customer the current available inventory and the price for their account.

Under no...

george sibbald (5/1/2010)

---

The search criteria on the where clause is used by SQL to determine optimum plan, not the select list.

Post your create table script, sample values and the execution...

Cnu2010 (4/30/2010)

---

For a given County, I am returning the cities in that County

SELECT DISTINCT CITY FROM DEMO WHERE COUNTY = @COUNTY

CITY

-----

EDINA

BLOOMINGTON

EDEN PRAIRIE

SHAKOPEE

How do I display this data in a row...

How the heck will that work with a country like USA or Canada where you have 1000s of cities?

Ya I'd like to know to!

Atif Sheikh (4/29/2010)

---

You can also use Triggers for parallel insertion but it can slow down the Insert / update process. Using Service Broker can be helpful in this regard. Just...

Has nothing to do with truncate or delete... if the user shouldn't have access to the data, then don't grant it.

hedera (4/28/2010)

---

Yes, I understand that I need a PK composed of 2 fields, each of which is an FK for another table. But my question is: in MS...

You don't need 2 pk in the MM table. The PK is both columns at the same time. Then you have 1 fk for each of the table...

This...

Grant Fritchey (4/28/2010)

---

Ninja's_RGR'us (4/28/2010)

---

From instinct here...

Assuming this job has already run succesfully in the past :

1 - Either the permissions changed (NTSF or sql login)

2 - You're out of...

Check out this QOTD, also check out the discussion that follows, all your questions will be answered there :

http://www.sqlservercentral.com/questions/T-SQL/69738/

http://www.sqlservercentral.com/Forums/Topic908285-1198-1.aspx

Are you using a reporting engine for this? Most, if not all of them, will handle that quite easily for you... such as a matrix in Sql Server Reporting...

From instinct here...

Assuming this job has already run succesfully in the past :

1 - Either the permissions changed (NTSF or sql login)

2 - You're out of space on the...

Here'a another way to look at it.

Let's say each row of data contains 24 bytes.

60 000 * 24 / 1024 / 1014 = 1.39 MB... maybe 3 mb if it's...