This should work, I think..:

DELETE D FROM Table1 AS D

INNER JOIN StoreGroupMember A

ON A.Store_ID = D.Store_ID

WHERE A.StoreNumber = 9833

I think I got the tables right, but it's a bit unclear....

WayneS (9/15/2010)

---

FelixG (9/15/2010)

---

I need to...

I suppose you could just create a dynamic sql statement to create the database with the company name as a variable, and execute that.

Sorry, misunderstood...try this. Will pull the two highest dates for each product, and print their corresponding order number.

;WITH CTE AS (

SELECT ProductCode,

ROW_NUMBER() OVER (PARTITION BY ProductCode ORDER BY OrderDate DESC)...

WITH CTE AS (

SELECT ProductCode, MAX(OrderDate) as OrderDate, MAX(OrderNumber) as OrderNumber

FROM Orders

GROUP BY ProductCode

)

SELECT O.ProductCode, cte.OrderDate as [MaxOrderDate], cte.OrderNumber as [MaxOrderNumber]

FROM Orders O

INNER JOIN CTE on CTE.ProductCode = O.ProductCode

I wasn't...

edit: there are a few syntax issues with your script, such as cartesian products when you select multiple tables without any join criteria.

Here is a script I've been using for...

SELECT distinct MA.Account

, M.DisplayName

, MUA.UserName

, CC.EmailTo

, aspnet_Roles1.RoleName

FROM AfsDepositGateway.dbo.MerchantAccounts MA

INNER JOIN Merchants M ON

M.MerchantId = MA.MerchantId

INNER JOIN MerchantUserAccounts MUA ON

MUA.MerchantId = M.MerchantID

INNER JOIN CustomerContacts CC ON

CC.CustomerContactId = M.CustomerContactId

INNER...

Ah crap, I did. Didn't even notice that. Hard to follow the logic of this query..working on it.

Unfortunately I'm writing this blind with no real way to quickly check syntax..if you could post table definitions, it would help a bunch.

As Mike said, if you create an alias for a table, you need to use that alias for every mention of the table. You can't mix and match. Also, I...

Yes, each instance needs its own IP address on a cluster.

Also Yes, having the data files and log files on separate spindles is absolutely the best way to go.

Whoops - you're doing a cartesian join on your subqueries. It should be an inner join on those 3 fields. Haven't had my coffee yet...will update with a new query...

Just out of curiosity..have you run a dbcc dbreindex() or alter index rebuild? Also make sure you update statistics with fullscan after creating/dropping/modifying indexes.

You're missing a comma after the first subquery:

and test_id = kc.test_id),

district_average_percent = (SELECT district_average_percent

If that doesn't resolve it, then you're probably getting more than 1 result from one of the...

Because there aren't many...