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.

 All Forums
 SQL Server 2000 Forums
 Transact-SQL (2000)
 Help me get the idea

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 Order
CAN01 09/10/2006 8
MUI01 09/20/2006 3

I 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”
Go to Top of Page

eyechart
Master Smack Fu Yak Hacker

3575 Posts

Posted - 2006-10-02 : 19:07:36
is this for school?



-ec
Go to Top of Page

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”
Go to Top of Page

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
Go to Top of Page

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”
Go to Top of Page
   

- Advertisement -