tudorn (1/6/2013)

---

Hi Sean,

Sorry I did not replied to you earlier.

The two posts/links that you recommended were very good and helped me a lot to create the reports I needed.

Thank you...

Assuming you want to have forms like you are used to with Access you...

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...