Ray K (9/29/2010)

---

Chris Morris-439714 (9/29/2010)

---

Ray K (9/29/2010)

---

tosscrosby (9/29/2010)

---

Ray K (9/29/2010)

---

Cat

(as in missing -- he didn't come home last night, which is not like him. Mommy and Daddy...

Ray K (9/29/2010)

---

tosscrosby (9/29/2010)

---

Did you do...

Here's another way, less cluttered. As always, check performance before deciding which solution to use.

; WITH PartitionedData AS (

SELECT ElementCount = COUNT(*) OVER(PARTITION BY column1, column2, column3),

* --...

Here's the other thread we were all thinking of:

http://www.sqlservercentral.com/Forums/FindPost931414.aspx

ColdCoffee (9/29/2010)

---

...And Chris, your solution actually numbers sequentially each row in a group, resetting the counter and starting from 1 for the next... That's not specifically what i am after...

Have you tried using CTE's and ROW_NUMBER() for this?

;WITH PartitionedData AS

(SELECT secid, marketCap, tradeDate,

RowID = ROW_NUMBER() OVER(PARTITION BY secid ORDER BY tradeDate DESC)

FROM SecMarketCap

)

SELECT a.secid,

a.tradeDate,

a.marketCap/b.marketCap - 1

FROM PartitionedData...

Hi ColdCoffee

Funny - I've had to do this recently in a production system but I couldn't find the code or even remember the method. Age sucks.

Here's something which works...

Baked Alaska

Tom.Thomson (9/28/2010)

---

...I would say that as a general rule, letting a "business analyst" anywhere near anything you seriosly want to happen is a big mistake. A person who can...

Alter this to match your object names, then run it.

If you are experiencing the same problem then it's probably a SP settings issue, check datatype of Col1.

UPDATE dbo.XXX

SET Has_Errors =...

You what????

Sounds like this to me:

;WITH MyStructuredData AS (

SELECT RowID = ROW_NUMBER() OVER(PARTITION BY PolicyKey, PaymentAmountOriginalCurrency

ORDER BY PolicyKey, PaymentAmountOriginalCurrency, accountspaymentkey),

PolicyKey, PaymentAmountOriginalCurrency, accountspaymentkey

FROM MyTable

)

SELECT

pos.PolicyKey,

pos.accountspaymentkey,

neg.accountspaymentkey,

pos.PaymentAmountOriginalCurrency,

neg.PaymentAmountOriginalCurrency

FROM...

Paris Hilton

byrdmom2 (9/28/2010)

---

You're right! No need for the table variables. Your query works fine and I will replace mine. Is there a way to change the color when I replace the...

--***get the information from both tables and concatenate date and city

select

t1.eForm53_GUID,

t1.fullname,

convert(varchar(10), b, 101) as RecCreatedDate,

(select convert(varchar(10), b, 101) + ' ' + c as 'data()'

--from...