Home Forums Data Warehousing Analysis Services Like we have If Not Exists in T-SQL, Is there any alternative in MDX ? RE: Like we have If Not Exists in T-SQL, Is there any alternative in MDX ?

  • Hi PB_BI,

    Thanks for the reply, but i am using the following query,

    SELECT top 1 lock_object_id

    FROM $System.DISCOVER_LOCKS

    WHERE Lock_type = 4

    I googled but i found out that i cannot use, Iff in the above query.

    Do you know some other alternative to do so, could you please share if doing the above is possible.