Maybe. Maybe not. Depends on various items (e.g. business process, table size, hardware, numberof calls etc.).

What are the pros...

Gianluca Sartori (6/8/2011)

---

That's not...

The easiest way to verify it would be to add a AFTER UPDATE trigger to a test table and insert the results of the internal DELETED and INSERTED tables into...

As long as you're referencing within the same instance (as you mentioned) Edit: [and the user has the permission to access this object], you could use the three-part name to...

It's a weird process to import duplicates on purpose and try to figure out there are duplicates afterwards... Why not add those rows to a separate table holding just the...

Duplicate post.

Already answered here.

Please re-read my previous post regarding some test data and help us help you.

It should return MAX(Balance) per Customer.FName and Customer.Address. So I would expect one row per customer. If...

The syntax is correct. It returns data. So it IS working.

The fact you're expecting other results implies you're looking for a different query then. 😉

Since we don't know your data...

Something like

SELECT MAX(Balance) AS BalanceMax, Customer.FName, Customer.Address

FROM Accounts INNER JOIN

Account_mm_Customer ON Accounts.AccountID = Account_mm_Customer.AccountID INNER JOIN

Customer ON Account_mm_Customer.CustomerID = Customer.CustomerID

GROUP BY Customer.FName, Customer.Address --, Balance

Please explain what you'retrying to achieve (not in terms of SQL code but in terms of the related business case).

As per now to me the concept looks weird... There are...

Learn_something_new_everyday (6/2/2011)

---

Also you could buy/rent hosted a VM from amazon and use 120 eval edition of SQL. Once the 120 days is up just add a new VM and start...

You might want to search this site for "calendar table" or you could have a look at the tally table article referenced in my signature (at the end there's an...

Either

SELECT model, COUNT(model) AS Qty_model

FROM PRODUCT

GROUP BY MODEL

HAVING COUNT(MODEL)>=3

AND TYPE = 'PC'

or

SELECT model, COUNT(model) AS Qty_model, TYPE

FROM PRODUCT

GROUP BY MODEL, TYPE

HAVING COUNT(MODEL)>=3

AND TYPE = 'PC'

SQLRNNR (6/2/2011)

---

LutzM (6/2/2011)

---

To quote from a thread I've been involved:

Also, I will start to participate on the site more often. It has always been useful and seems to be very...

To quote from a thread I've been involved:

Also, I will start to participate on the site more often. It has always been useful and seems to be very helpful and...