The challange I have is that a Stored procedure cannot be called from within a select statement in SQL server. obviously I get an error "Invalid Object " Any alternative options for resolving this?

Thanks for the resposne and the example Cole. I am trying to implement this and will let you know .

Hi Cole, Have you created a derived table that accepts Looker Parameters that passes them in as appropriate arguments to the stored procedures? if so, can you share your example please?