• Saravanan_tvr (9/3/2010)


    Hi In veiw the sq server wont allow to use the declarations,

    Ok, so you've got a function that gives you a delimited list of columns.

    And you want a view defined to dynamically use that list?

    Why would you want to do this??? I think you're going to have to back up and explain to us what you're trying to accomplish and why because you can't do what you're trying to do, but there is almost certainly another way of accomplishing it (e.g. not using a function, not using a view, or using both but having the view contain all columns and using dynamic sql when selecting from the view)