Hi all,I'm getting this error : Incorrect syntax near the word 'where'. execute dbo.RP_RUN_QUERY; 1 @query=32, @list_no=0when I run an output set that uses the query element ticket season. I made sure that element is pointing at our actual tkt hist table. I made sure the where on the element is directed at the right query element parameter. Any other ideas where it might be going awry?
Hi Amanda,
Is "where" actually typed into that field in query element because it shouldn't be.You want to paste the field info?
Ha! I stared at that field for eons, even scrolled to look at other parameterized query elements for comparison, and somehow didn't notice that, yes, "where" was typed into that field, and I totally know it shouldn't be. Thanks Ryan!