Hallo again,

I have tryed your exampel, but it's an large SP I use, so I havn't got it to work. But I'm trying.

An other thing,

Why can't I do this

DECLARE @TabelName...

Hi, thanks for your answer.

If I understand the dynamic SQL correct, is it that you write the SQL code into an string and send this to the SQL server. If this...

Hallo again,

I have found a solution, by using IF insted of CASE, this works.

Thomas Vanting

Hi Arif

Yes, this was also the options I found. So I have made an SP to do the job. And this works correct.

Thanks for all answers

Thomas Vanting

Hi Razvan

Thanks,

Thomas

Okay, thanks

Thomas Vanting