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 |
|
bassist695
Starting Member
9 Posts |
 Posted - 2005-03-22 : 14:00:08
|
| Is there any better way to debug a query encased in IIF statements than to find bugs at runtime? I have an especially ugly CommandText for one of my datasets, and debugging it when there is an error is nearly impossible. I realize that it's much cleaner when you have straight SQL, but otherwise the tool doesn't seem to be very user-friendly.Thanks,Mike |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-03-22 : 14:36:53
|
| Debugging is dreadful in Reporting Services. I've had to copy my IIF statements into an editor and spend quite a bit of time on paper to figure out where it is failing.Tara |
 |
|
|
bassist695
Starting Member
9 Posts |
Posted - 2005-03-22 : 14:51:35
|
| That's what I feared. My boss was shocked at how difficult debugging is.Thanks |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-03-22 : 14:54:04
|
| The 2005 version is supposed to include debugging options. We are planning on moving to it as soon as possible after it RTMs as there are quite a few issues with the 2000 version. 2000 version was purchased from another company apparently, and 2005 MS completely rewrote it.Tara |
|
|
|
bassist695
Starting Member
9 Posts |
Posted - 2005-03-22 : 15:55:10
|
| I know how to comment SQL code, but how can I comment the "other" code in :=IIF(Parameters!acctg_prd.Value <> 1,"SELECT amt FROM T_SCORE","SELECT amt2 FROM T_SCORE")? |
|
|
|
|
|
|
Dataset Query Debugging