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 |
|
shakeel2008
Starting Member
5 Posts |
 Posted - 2008-09-11 : 10:53:22
|
| In this report, I had to use two datasets with two stored procedures because I maxed out the stored procedure with the error "Too many table names in query, Max allowable 256".dataset1 - sort caseload for worker by Type 1 (plus other criteria)dateset2 - sort caseload for worker by Type 2 (plus other criteria)When I run the report, I get the following:Worker1 - caseload for Type 1Worker 2 - caseload for Type 1.................................................Worker1 - caseload for Type 2Worker 2 - caseload for Type 2I am looking for something like this:Worker1 - caseload for Type 1Worker1 - caseload for Type 2.................................................Worker2 - caseload for Type 1Worker 2 - caseload for Type 2I will appreciate to find out if it is possible and how? Thanks. |
|
|
dexter.knudson
Constraint Violating Yak Guru
260 Posts |
Posted - 2008-09-11 : 17:16:03
|
| 256 tables in a stored procedure is very unusual. There's proably other ways of designing the process without having to use so many in 1 proc. Can you post part of it here & maybe we can suggest some design changes? |
 |
|
|
|
|
|
Merge the contents of two datasets in a report