BusinessObjects Board

Dual table in Sql Server 2005

Hi All,

I want to add ‘ALL’ in some objects.

I created union statement
like

Select ‘ALL’ from dual
Union all
SELECT DISTINCT
Agent.Name
FROM
Agent

I am getting error when i create a dual table in sql server 2005.

Select 'ALL' from dual.

Please help me how do i crete a dual table?

Thanks
Sharma


sharma03 :india: (BOB member since 2006-03-25)

“dual” is a special reference in the Oracle world.

Rather than trying to solve how to “create” a dual table in SQL Server – the real question is how one achieves this sort of functionality for SQL Server.

If you look at the Designer FAQ in this very forum, you’ll find that the entry that discusses this very subject tells you how to do it for SQL Server.


Anita Craig :us: (BOB member since 2002-06-17)

Thanks Anita.

Sharma


sharma03 :india: (BOB member since 2006-03-25)

Oracle requires a FROM clause, hence the existence of SYS.DUAL as a “dummy” table. SQL Server does not have such a requirement. Just leave off the FROM clause completely.


Dwayne Hoffpauir :us: (BOB member since 2002-09-19)