PDA

View Full Version : Passing Parameters To SQL


Chamark
05-15-2006, 10:02 PM
I am a newbie so please have patience. I created a View (SQL query) to get the sums of various fields. I then created another View that performs calculations using the sums from the first View. The Views obviously reside on the SQL Server.

In DW 8 when creating a Record set is there a way to pass a parameter to the View from the Web page? Or can I over ride a hard coded field in where statement in the View at the Record Set level?

Thanks in advance for any help on this.