hi @Raj
I couldn't understand the meaning of "Dynamic and Static" but if you try to send dynamic query to single SQL server, you can use Dynamic Input tool.
First prepare template SQL query like this(in this case, I will modify where clause x value )
This case, by using x column value, where clause is replaced with "x=1", "x=2"...and get output.
As the above workflow only works at my computer, so sorry for not attaching as a sample.
