so like

select * from View1

will work fine

but better to but in stored procedure like SP_SelectView1

and run the proc from the app?

thanks

i get your suggestion and thank u for it in the presentation layer or making another field. But I still want to figure how to do this.

ok so using veteran's...

thanks too much!!!

thanks, how do you ut people in dbo arena.

sysadmin role users are only to bi in dbo arena, yes?

2 ez tanx!!!!!!!!!!!!!!!!!!!!!!!!!

thank you all too much for your help ! this was very informative and I am sure has pointed me in the correct troubleshoting direction!  

thanks you all you have been very helpul!

thanks!!!

for further clarification.

is there no relationship to a the mouse pointing device?

it is a different name for a certain kind of row by row manipulation record set?

so what is the...

thanks

why do you need to put it before a command in QA sometmes?

example

DBCC shrink...?

what is a command console. sorry, I could not find dbcc in BOL