Forum Replies Created

Viewing 15 posts - 16 through 30 (of 59 total)

  • RE: Dynamic Queries - Can this be done

    Thanks David. Was so simple...


    What I hear I forget, what I see I remember, what I do I understand

  • RE: Table variables (Am I overdoing it)?

    First of all this would be a platform independent implementation hence to keep it generic we have to have our own representation of security model.

    Secondly "Flexibility" is very important here....


    What I hear I forget, what I see I remember, what I do I understand

  • RE: Dynamic Queries - Can this be done

    My apologies for posting what I am about to post on here, though it is not a solution to the original post never the less it is along the lines...


    What I hear I forget, what I see I remember, what I do I understand

  • RE: Diff b/w Srored Procedure & Functions

    Another difference.

    I think one cannot use SP_executesql frm within a function. The last time i tried to use it, i hit a brick wall.


    What I hear I forget, what I see I remember, what I do I understand

  • RE: Creating a heirarchy

    FOR XML EXPLICIT allowes you to return your results in a structure specifically defined by you.  It is much more powerful and richer than FOR XML AUTO and


    What I hear I forget, what I see I remember, what I do I understand

  • RE: Views (performance)

    If I do that, I get a variance of 5 secs. That is, if i select all the fields from t1t3 and if i select only 4 fields. But thats...


    What I hear I forget, what I see I remember, what I do I understand

  • Viewing 15 posts - 16 through 30 (of 59 total)