You also don't have any sales for acct's 5/6 in June.

How does this work for you?

SELECT c.ACCT_NO, c.L_NAME, sum(IsNull(p.SALE_PRICE,0))

FROM Creditor c

LEFT...

Clustering <> load balancing. A SQL Instance installed on a cluster can only be active on ONE node of the cluster at a time. This geographically disbursed cluster is designed...

reported as spam

Does this work for you?

;WITH CTE AS

(

select DISTINCT DocNo, CreatedAt, Notetitle

from dbo.test

)

SELECT *,

stuff((SELECT ',' + NoteText

...

:hehe:

Which begs the question... how would you have been...

GilaMonster (10/13/2010)

---

http://sankarreddy.com/2010/10/invitation-to-participate-in-t-sql-tuesday-11-misconceptions-in-sql-server/

Start reading....

They're all linked in the comments of that...

Nick123-481228 (10/13/2010)

---

Sorry about that,

This is equity price table and it contains many combination and it would be very hard to give all cases.

You can imagine that we are storing 100,00...

Your specification is now changed. In http://www.sqlservercentral.com/Forums/FindPost1003800.aspx, you say it should be one value, now you're saying a different thing. Please give detailed specification of what you need.

mark - is respect to what Craig said earlier:

Craig Farrell (10/13/2010)

---

Quirky update is probably the cleanest way out of this, but it's not going to be pretty. I'd like...

Does this do it for you?

if OBJECT_ID('tempdb..#CardHistory') IS NOT NULL DROP TABLE #CardHistory;

Create Table #CardHistory

(

SerialNo INT IDENTITY(1,1) PRIMARY KEY CLUSTERED, -- a CLUSTERED INDEX is REQUIRED!

ModificationDatetime DATETIME DEFAULT GETDATE(),

OldCardNo...

Tom.Thomson (10/13/2010)

---

It would...

Please post sample data, in the...

Check out the link in my signature for common date/time routines. You'll also need to use a case statement to handle whether the current month is January for which routine...

But of course... superior ways to achieve expected...

You need to look at the MIN, MAX and COUNT functions, as well as the GROUP BY clause of the SELECT statement.