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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-05-14 : 10:48:02
|
| Satya writes "I need to create a query on a database consisting of 3 columns namely payment amount, bill date and payment date. Objective is to retrieve the payments made in the last six months. The number of records increases once in a month, if payment is made full. Partial payments can also be made and in that scenario, number of records will increase as many times payments are made.Can any one help me to create a query" |
|
|
Page47
Master Smack Fu Yak Hacker
2878 Posts |
Posted - 2002-05-14 : 11:46:43
|
| Post DDL (data definition language - these would be the create table statements) . . . post sample data . . . post desired resultset . . .<O> |
 |
|
|
|
|
|
Help to control number of rows to display