https://www.infopathdev.com:443/forums/131.aspxqRules adds support to your InfoPath forms. With qRules, you can add features to your form that require code, but without having to write it. enCommunityServer 2007 SP3 (Build: 31118.962)https://www.infopathdev.com:443/forums/thread/105480.aspxThu, 11 Feb 2016 20:41:48 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:105480Mfranco0https://www.infopathdev.com:443/forums/thread/105480.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=131&PostID=105480My Dear.. I am already implementing that exact scenario. Rethought my process. I believe I have it nailed on this front. Working on the SSIS package now. Thanks again!https://www.infopathdev.com:443/forums/thread/105479.aspxThu, 11 Feb 2016 20:24:18 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:105479Hilary Stoupa0https://www.infopathdev.com:443/forums/thread/105479.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=131&PostID=105479Yeah, anything but IE doesn't seem to work too well with the forum. Sorry about that. I think instead of using ModifySqlQuery, you should use ExecuteSqlQuery, and I think you should create a stored procedure and use ExecuteSqlQuery to pass your parameters into that. Set implicit_transactions to off in your stored proc.https://www.infopathdev.com:443/forums/thread/105477.aspxThu, 11 Feb 2016 18:40:07 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:105477Mfranco0https://www.infopathdev.com:443/forums/thread/105477.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=131&PostID=105477I tried to separate my code above from my actual comments. But none of the options for formatting are available and it's removing my hard returns, tabs and spaces.https://www.infopathdev.com:443/forums/thread/105476.aspxThu, 11 Feb 2016 18:35:13 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:105476Mfranco0https://www.infopathdev.com:443/forums/thread/105476.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=131&PostID=105476DECLARE @emps AS TABLE (evc_code varchar(max)) INSERT INTO @emps (evc_code) SELECT DISTINCT evc_code FROM prj_detail WHERE (fiscal_year = @year) AND (evc_type_code = 'E') AND (rev_type_code = '01') DECLARE @names AS TABLE (emp_code varchar(max), emp_name varchar(max)) INSERT INTO @names (emp_code, emp_name) SELECT emp_info.emp_code, emp_info.emp_name FROM emp_info INNER JOIN emp_group_map ON emp_info.emp_code = emp_group_map.emp_code INNER JOIN emp_group_code ON emp_group_map.rsrc_group_code = emp_group_code.emp_group_code WHERE (emp_group_code.emp_group_name = @BU) SELECT a.* FROM @names a INNER JOIN @emps b ON b.evc_code = a.emp_code The above is my query. I need to supply the @year and @BU for my where clauses. These values will be passed from an SSRS report. I've used this command before with a single parameter in a Single WHERE clause. But how do I go about using it for 2 separate values in 2 separate WHERE clauses in the same Query. I'm on the latest version of qRules.