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 |
|
Fletch
Starting Member
29 Posts |
 Posted - 2005-08-08 : 06:27:30
|
| I have three very similar sets of data on one page, hence I want to use one dataset and a slightly different filter on each table.I have managed (after much trial and error) to filter on payment_type by making it nvarchar.I have not been able to filter on payment_amount though. It's type is money. Any ideas welcomed.Steve. |
|
|
Fletch
Starting Member
29 Posts |
Posted - 2005-08-08 : 06:54:15
|
| Found a solution!! (if anyone else is interested).I also select 0 in the stored procedure and cast it as money, then I can compare payment_amount < zero (taking both fields from the procedure). |
 |
|
|
|
|
|
Table Filters