Hi jim...

i am joining the same view only for the favour of my example-

If i understand you correctly, in any way i will have to create the views at...

As i Mentioned Above

the goal is to create a so called querit generator.

say there is a standard database for an ERP system (of any sort) that installed on varios...

hi jim,

i get the sql staememnt regourding the views itself - check my example :

this is VIEW3 sql scripted ( with script - alter to )

SELECT ...

thank for yout advice,

my question is still hanging,

Can i generate the native code from the nested views - and can it be done using SQL MANAGEMENT studio 2008...

still didnt made any mistake... dont know how 😀

if i undestand correctlly, nesting views is not a good idea performance wise

if so , i still want to experiance with that...

hi and thanks for your reply.

let me try to explain it in this way :

say that view1 and view2 are both views that using standard tables from our...