madhavsinghk (1/4/2013)

---

Hi,

Thanks for response, here is what i have so far:

If I set the monthly span to -10 (last 10 months), i only get records for last 8 months. No...

steve.pantazis (1/4/2013)

---

I read over the article on running totals. However, I'm not looking to produce a running total on a set of transactions. I'm trying to sum child rows into...

I like the MySQL convention of using double zeroes for months and years, That is 'yyyy-mm-00' for a month within a year and 'yyyy-00-00' for the whole year. The advantage...

From your description it sounds like you want to do running totals? Take a look at this article that explains how to do this quite easily.

http://www.sqlservercentral.com/articles/T-SQL/68467/%5B/url%5D

There isn't a way to do exactly what you are asking. Have you looked at CDC? It would be far less overhead than what you are proposing here.

How big are the numbers? You may have to increase the varchar size as Dwain suggested.

I thought of you as I was...

(Bob Brown) (1/4/2013)

---

Toreador (1/4/2013)

---

Victor Abkin (1/4/2013)

---

I disagree with the list of correct answers: this list should contain 5 answers, not 4.

Asking to choose 4 answers makes it...

suchang (1/4/2013)

---

Error Comes out

Executed SQL Statement: SELECT oi.ItemCode + ' X ' + CAST(oi.Quantity AS VARCHAR(5)) AS Expr1, oi.ItemCode, oi.ItemDescription, oi.Quantity, oi.UnitWeight, os.Ref1....

Error Source: .Net SqlClient Data Provider

Error...

I would also ask that you notice how I posted ddl and sample data in an easily consumable format. You should do something like that on future posts. It makes...

This is a rather bizarre requirement to say the least. I do not condone doing this sort of thing to make searching easier. The ease of writing an easy search...

Agreed. Your best option is to use datetime. I would strongly urge you not to do something you will regret like using a varchar for datetime. If you don't want...

+1

I...

At the very least the WWW consortium does not agree that there is no such thing.

‘ is left single quote

’ is right single quote

--EDIT--

Proof...I typed in the html escape...

I am totally lost now...are you saying that it changed your inner joins to left and right joins?? You have me stumped.