如果填充参数，则使用过滤器选择ROW_NUMBER（）？

I have the following SQL Server 2008 query. I would like to augment it so that when the @Filter parameter is populated then pass that value to each field (across columns). Without the filter the query works perfectly. I am not sure if the filters should go where I have them. Any help would be much appreciated:I have the following SQL Server 2008 query. I w