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.

 All Forums
 SQL Server 2000 Forums
 Transact-SQL (2000)
 Blind Report

Author  Topic 

mikebird
Aged Yak Warrior

529 Posts

Posted - 2009-09-10 : 11:08:43
Asked to produce a report using views / tables to match the output from given simple parameters of start / end dates.

Can't view the design of it at all. Confidential. Each row has it's own title / meaning. They all come to a final count. I manage to get a report with too low a figure (1500) and too high (3084) with the yardstick about 2500. Variation / granularity between each item matters. Tried using a variation of views / tables, for these differences. If the set output can be obtained, I should be able to get it.

What would you say? I'm worried about the point of doing this if it's already done... I know if I could examine and understand the details, I would have had it done last week. A psycho exercise?
   

- Advertisement -