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 |
|
clacac
Starting Member
2 Posts |
 Posted - 2012-02-07 : 13:42:39
|
| For each investment account, the Company issues an annual Valuation Statement which displays the unit balance grouped by holding. The statement is sent by mail to the account’s primary holder.Design a query using standard SQL which satisfy the reporting requirement above.can anyone please help |
|
|
X002548
Not Just a Number
15586 Posts |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-02-07 : 13:45:12
|
| ok...nice assignment questionnow you can post what you've come up with for this and what issue you facedPlease dont expect anybody else to do it for you. you wont benefit anything from that------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
clacac
Starting Member
2 Posts |
Posted - 2012-02-07 : 13:51:51
|
i only need some help in how to send the valuation statement via email quote:
Originally posted by visakh16
ok...nice assignment questionnow you can post what you've come up with for this and what issue you facedPlease dont expect anybody else to do it for you. you wont benefit anything from that------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/
|
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-02-07 : 14:04:01
|
quote:
Originally posted by clacac
i only need some help in how to send the valuation statement via email quote:
Originally posted by visakh16
ok...nice assignment questionnow you can post what you've come up with for this and what issue you facedPlease dont expect anybody else to do it for you. you wont benefit anything from that------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/
have a look at sp_send_dbmail system procedure------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
|
|
Management System