andrexcobar (3/14/2014)

---

Sean Lange (3/14/2014)

---

First of all I want to confirm that you are actually using sql 2000.

I can't use CTE, TEMP Tables or SPs, I have to resolve this in the SELECT query (I can use subqueries).

This is a rather strange requirement. If you are truly using sql 2000 then I understand the restriction on cte since they didn't exist yet. No temp table or SP sounds like an artificial restriction that is often found in homework assignments.

Hi Sean,

First all all: thanks for your quick reply.

The problem is that I have to place the SQL query in the report interface of Business Object. That's why I can't use SPs, CTE or Temp Tables.

In SSRS, You can work with CTEs and Temp Tables. But in Business Objects you can only run one query. You can use subqueries and the UNION operator, and you can build a huge SQL query that will run, but you can't create multiple queries that will feed one last query.

I'm working with SQL Server 2005. And also, I don't have permissions to modify the DB. I can only run SELECT queries. The DBA can do all the operations.