HowardW (1/24/2014)

---

No, but I've heard plenty...

phingers (1/24/2014)

---

Thanks dwain.c - I used xsevensinzx because it is a one off operation. Yes it is slow but scheduled overnight it hadn't got in the way of...

xsevensinzx (1/23/2014)

---

...

The problem with Unit Testing is that it can be very time consuming for the developer or engineer. Some down prioritize or only unit test in fragments. Where a...

phingers (1/23/2014)

---

I have the following query which produces a running total.

WITH CTE_rownr

AS (

SELECT extractdate

, dwPalletId

, szPalletNumber

, dwFormsetIdFK

, SUM(quantity) as quantity

, ROW_NUMBER() OVER (

PARTITION BY dwPalletId ORDER BY dwPalletId

, extractdate

) AS...

aberndt (1/23/2014)

---

Thank you...I'm going to have to review my data further and do some testing to see if row id will work. I hope so. I'll post back...

You might want to take a look at the following article:

How to Design, Build and Test a Dynamic Search Stored Procedure [/url]

Part of the process described therein is how I...

xsevensinzx (1/23/2014)

---

I just added this to my ETL system for reporting as I was looking to add a new one when you wrote the article. I had a basic one...

You might...

Please don't cross-post. It only confuses people and fragments your answers.

No replies to this thread please. Post your replies here:

http://www.sqlservercentral.com/Forums/Topic1533586-392-1.aspx

If Keith's solution won't work for you, this looks like something I covered in my first SSC article:

Financial Rounding of Allocations [/url]

below86 (1/22/2014)

---

Misha_SQL (1/22/2014)

---

Thank you very much for the article! I found it very useful. I do have a comment though. With the approach presented, we have to incorporate...

Try this:

UPDATE s

SET ClosePrice = ClosePrice * ISNULL(EXP(so) / EXP(si), 1)

FROM @StockPrice s

CROSS APPLY

(

SELECT SUM(LOG(ShareIn)), SUM(LOG(ShareOut))

...

Wendy,

I think what you want to do is something like this.

-- Create the type for your db

CREATE TYPE dbo.avar AS TABLE

(

avar VARCHAR(3)

);

GO

-- Locally, you can...

So, I fixed the issue with the in-line Tally tables generating different row counts (they all now return 101 rows) and each of the following 5 queries returns the exact...

dwain.c (1/21/2014)

---

Ooops! I didn't see the second page of posts! Guess I got too into the fun problem.

Here's how to use LAG to get the Beginning Balance (from...