Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
ronnyr
Starting Member
21 Posts |
Posted - 2006-10-02 : 15:47:16
|
Hi All,I would like to produce a report which will show clients who did not order in particular period, but have ordered within the past 3 months.Client ID Last Inv. Date Total OrderCAN01 09/10/2006 8MUI01 09/20/2006 3I don't know the best way for doing this. Please help me with the idea of doing this?Thanks in advance.Ron.“Know where to find the information and how to use it - That's the secret of success” |
|
ronnyr
Starting Member
21 Posts |
Posted - 2006-10-02 : 17:50:09
|
Anyone please help me with an idea...Ron.“Know where to find the information and how to use it - That's the secret of success” |
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2006-10-02 : 19:07:36
|
is this for school?-ec |
|
|
ronnyr
Starting Member
21 Posts |
Posted - 2006-10-02 : 19:09:41
|
No, I am working as a Web Developer and I am new to Microsoft Reporting Services and Microsoft T-SQL.Ron.“Know where to find the information and how to use it - That's the secret of success” |
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2006-10-02 : 19:34:56
|
why don't you post what you have. Also please post DDL of the underlying tables.-ec |
|
|
ronnyr
Starting Member
21 Posts |
Posted - 2006-10-03 : 13:17:34
|
Thanks guys, I got the idea now. I just think too complicated.Ron.“Know where to find the information and how to use it - That's the secret of success” |
|
|
|
|
|