Add ALL to LOV

building semantic layer
1

Hi,

i have tried below one:
SELECT DISTINCT
VALTDW.dbo.V_LT_PRD_GRP_DIM.PRD_GRP_DESC
FROM
VALTDW.dbo.V_LT_PRD_GRP_DIM
ORDER BY
1
union
select “all” from

Back end : SQL SERVER

in showing error is connection or SQL sentence error.

Please help on above issue.

With warm regards,
Udaya

udayabsl (BOB member since 2010-03-16)

2

You probably need to move the Order By to the end

Also single quotes only (for SQL Server no from is required):


union
select 'ALL'

Ottoman :uk: (BOB member since 2002-10-04)