title: I want to script a link in a column of my view based on the pKey column of the table
body: <p>I have an online program that holds records based on their ID number (the pKey). I have to provide a file to an external source where they would like the last column of the dataset to reference each individual records url in the online program. How can I write my view to put each row's ID number into the url?</p>
  
  <p>whole url = Example\webprorgam\List\item='IDnumber'</p>
  
  <p>ex: Row1IDnumber....Data....Url+'Row1IDnumber'</p>
  
  <p>I thought I might be able to do it with a CASE statement but I am not sure how to get the 'THEN' portion to reference the ID number within the CASE</p>
  
  <p>I need to do this in SQL Server; any thoughts?</p>