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 |
|
Christech82
Starting Member
20 Posts |
 Posted - 2013-04-11 : 16:52:51
|
| Blank |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2013-04-11 : 21:59:24
|
So that we may better help you, please show us- Table structure including data types
- A few sample rows of data
- Expected output
|
 |
|
|
Christech82
Starting Member
20 Posts |
Posted - 2013-04-12 : 16:06:37
|
quote:
Originally posted by russell
So that we may better help you, please show us- Table structure including data types
- A few sample rows of data
- Expected output
I should show a result as the tenant can get the total cost( the total cost includes the 50% discount if the tenant stay at house for a year or over plus the damage cost if there is one ! |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-04-13 : 02:09:17
|
quote:
Originally posted by Christech82
quote:
Originally posted by russell
So that we may better help you, please show us- Table structure including data types
- A few sample rows of data
- Expected output
I should show a result as the tenant can get the total cost( the total cost includes the 50% discount if the tenant stay at house for a year or over plus the damage cost if there is one !
the request was to post the sample data and required output in below formathttp://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
|
|
|
|
|
|
COMPLICATED QUERY