How to retrieve data between two dates

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Amit Asawa - 03 Dec 2004 06:12 GMT

For e.g

I want the amount of a customer between 2nd March 2004 and 2nd October
2004.

Basically How to filter this as i cannot put it in a where clause.i.e
customer name in rows amount in columns.

Reply to this Message

Adam Machanic - 03 Dec 2004 14:10 GMT

Is this in SQL Server or AS?

If the former, please post DDL, sample data, and sample output.

http://www.aspfaq.com/etiquette.asp?id=5006

If the latter, I will let someone else handle this question :)

Signature

Adam Machanic
SQL Server MVP
http://www.sqljunkies.com/weblog/amachanic
--

> For e.g
>
[quoted text clipped - 3 lines]
> Basically How to filter this as i cannot put it in a where clause.i.e
> customer name in rows amount in columns.

Reply to this Message

mailketna@yahoo.com - 15 Dec 2004 07:33 GMT

If u have got solution to this problem can u please forward it to me at mailketna@yahoo.com.

I have same problem in asp.net in crystal reports.

Thankyou

Reply to this Message

Adam Machanic - 15 Dec 2004 14:13 GMT

Can you post DDL, sample data, and sample output? I'll help you out, but
not via e-mail. Let's keep this public so that others can benefit from the
discussion as well.

Signature

Adam Machanic
SQL Server MVP
http://www.sqljunkies.com/weblog/amachanic
--

> If u have got solution to this problem can u please forward it to me at mailketna@yahoo.com.
>
[quoted text clipped - 5 lines]
> Sent via Fuzzy Software @ http://www.fuzzysoftware.com/
> Comprehensive, categorised, searchable collection of links to ASP & ASP.NET resources...

Reply to this Message