Create a dynamic cross-table in a function

[TheBestOfMe]

Hi

I want to create a cross table with dynamic column. This is quite easy in a stored procedure, but I need to make a inner join on it with another table. The only way was to put this in a function. But a function cannot exec a string or another stored procedure. I tried different syntax and I never succed. Can someone tell me if is it possible and how or simply that and cannot do this.

Thanks.

 

[gcole]

Why don't you publish some code? I'm not sure what you are trying to do.

 

[TheBestOfMe]

I've done it with a dynamic table instead of a function and it works perfectly.