dcsimg
Results 1 to 4 of 4

Thread: Parameters restricted from use in views

  1. #1
    Join Date
    Aug 2011
    Posts
    13

    Parameters restricted from use in views

    Hello,

    In a stored procedure, I have a view as my data source. Unfortunately, views restrict the use of parameters. In my case, I need to get a value into the view from which to filter the data. This needs to happen inside of the view as this process needs to be isolated. What are my options? What about a nested stored procedure? Thanks in advance for any assistance.

  2. #2
    Join Date
    Sep 2002
    Posts
    5,938
    Tried with function instead?

  3. #3
    Join Date
    Aug 2011
    Posts
    13
    Thanks for your response! Do you mean a user-defined function? Meanwhile, I just discovered table-valued functions that might replace that view (since I am currently dealing with a table represented as a view). What are your thoughts on that?

  4. #4
    Join Date
    Sep 2002
    Posts
    5,938
    UDF includes table-valued function.

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •