And BTW, the Function worked like a CHAMP.

If condition = N then the data is retrieved in 5 seconds else it take about 5 minutes, and that's exactly what I...

You guys are THE BEST

THANKS!

wow Barry, thanks a million!!!! your help is highly appreciated. I will try it and get back to you. Now, how do I call a function from a view,...

how do I create one based on what I want to do?

sorry, have no idea of where/how to do it or to start.

Can a table-value function be included in a view?

If so, how do I proceed? Have no idea of how to create it.

Can you help me with it?

There is no relation at all, I just want to select all from one table or the other upon condition on the dimstatus table (aka flagsta).

The below sql, does...

This is what I need:

if(select failed from dimstatus) = 'N'

(select * from dim_region_mgr)

else

(select * from vw_dim_region_mgr)

I need to be able to choose one table or the other,...

The failed field is on the flagsta table,

SELECT

case when failed = 'N' then

(select * from dim_concept)

else

(select * from vw_dim_concept)

end

FROM

flagsta

neither dim_concept or vw_dim_concept have...

This is the original SQL

SELECT

case when failed = 'N' then

(select * from dim_concept)

else

(select * from vw_dim_concept)

end

FROM

flagsta

and those the errors when i execute it

Server:...

Because I need to be able to retrieve data from one table or the other from inside a view that will be later used.

Sorry, first time here.

It has to be one table or the other and unfortnately I need it to create a view that I wll later use.

both tables are the same, same number of...

Why to I get an error when I execute the view mentioned?

Im missing something, it says about an Exist but I can figure out how to combine it, sorry, silly...