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 2005 Forums  Analysis Server and Reporting Services (2005)  Query to show part of a table in a report

Author  Topic  whhs Starting Member 14 Posts Posted - 2009-11-04 : 06:14:33 The following situation occurs. I would like to have a report based on one table with a difference. I have a main project, e.g. 1234 and this project has child projects, namely 1234.001; 1234.002 etc In my report I would like to list: first section; main project (6 positions before the '.') second section, copy of the main project, than the .xxx My questions are (and which queries are needed): - how can I derive the first 6 postions of a table; basically the characters/numbers BEFORE the dot? - how can I copy (in the subsection) these 6 positions, with the followup of .xxx? - how can I best create such a report; by means of two tables in one report, or one table with split possiibilities, or another option?