You are viewing limited content. For full access, please sign in.

Question

Question

Custom Query limit

Workflow
Updated November 10, 2016
asked on November 10, 2016

I have a rather large stored procedure that I would like to use in Workflow.  However, I cannot paste all of the syntax into the Custom Query activity.  It cuts off after a certain number of rows.

Is there a limit of some kind?  If so, why or is there a way to use my SQL syntax in Workflow?

 

Thanks

0 0

Answer

SELECTED ANSWER
replied on November 10, 2016

Hi Chris ,

Do you try to call your store procedure on a custom query?


Like this :  


I thing there is not such limit just be sure to have your time out to the maximun allowed

3 0
replied on November 10, 2016

Ok, I can do it that way.  I guess I have always just pasted the SQL query syntax into the custom query box and not used the EXEC call.  

Thanks David

1 0

Replies

replied on November 10, 2016

The limit is 7000 characters.

2 0
replied on November 10, 2016

Any way you can simplify the syntax more with a different stored procedure? If your syntax has a huge amount of TSQL that it is executing while calling the stored procedure I would think that would be better to BE a seperate stored procedure. 

 

Usually with an effective stored procedure all you are do is pass in your parameters and then all of the code to display/organize/join/etc is inside the procedure. 

 

0 0
You are not allowed to follow up in this post.

Sign in to reply to this post.

Details
Related Posts
Loading ...