There are solutions using a nested select, but I think this should be simpler:

SELECT

matters.clientID as Client_Code,

Number,

description as Matter_Description,

matters.representative as Rep,

matters.mattertype as Matter_type,

chargetyperef as Charge_Type,

UFN,...

Michael Valentine Jones (9/21/2012)

---

kingdonshel (9/21/2012)

---

I have server Admin password, however even when I choose the AdventureWorks Database from the dropdown and run the below query I get an errror...

There's a cautionary note in the CREATE SCHEMA section of BOL;

"Beginning with SQL Server 2005, the behavior of schemas changed. As a result, code that assumes that schemas are equivalent...

Can you post the CREATE INDEX script?

If you're updating the whole table, then nonclustered indexes won't help performance and will impede performance if they too require updating.

Batching the update could...

Big hammer;

DECLARE @asd VARCHAR(20)

SET @asd = 'asdaaaadffa'

SELECT

Letter,

Occurrences = COUNT(*)

FROM (

SELECT Letter = SUBSTRING(@asd,n,1)

FROM (SELECT TOP(LEN(@asd)) n = ROW_NUMBER() OVER (ORDER BY (SELECT NULL))

FROM sys.all_columns) tally

) d

GROUP BY Letter

ORDER...

UPDATE StoreProducts SET Stock = Stock + 2

UPDATE ProdutStorages SET Stock = Stock + 2

How many tables are you updating?

dwain.c (9/21/2012)

---

egerencher (9/21/2012)

---

Once again. It worked. GENIUS. OK. Here comes a curve ball. Instead of sum of transamt > 1000 in 2 days, how about...

Hey Markus, no problem - it's always good to have...

hoseam (9/21/2012)

---

Please to resolve this issue.

I have this query

SELECT

(select REB_TAX_RATE from PR_REB_TAX_RATE

where EFF_DATE = (select MAX(EFF_DATE)

...

Gah! I hate it when that happens. Here's a new, completely different version;

;WITH

MyTrans AS (

SELECT TransID,...

Haha! I had no idea that this query would be any faster when I...

Note that the date arithmetic is still messed up - but I'm bored with making corrections to it because you keep throwing them away. The date arithmetic I posted was...

chinye2020 (9/20/2012)

---

ChrisM@Work (9/20/2012)

---

Use ISNULL or COALESCE in the...

laurie-789651 (9/20/2012)

---

ChrisM@Work (9/19/2012)

---

Easy - but first, we need to sort out your dates. You do yourself no favours by changing the date arithmetic back to the original each time I...

Simpler, quicker, same results:

SELECT

t.TransID,

c.SSN,

t.TransDate,

t.Amount

FROM #Customer c

INNER JOIN #TransDtl t

ON t.CustKey = c.CustKey

CROSS APPLY (

SELECT Amount = SUM(ti.Amount)

FROM #TransDtl ti

WHERE t.CustKey = c.CustKey

AND ti.TransDate BETWEEN t.TransDate-1 AND...