Home Forums SQL Server 7,2000 T-SQL How to store result of SELECT in local var. RE: How to store result of SELECT in local var.

  • Thanks Frank, this works fine. I've been browsing BOL, but didn't really find what I was looking for (didn't see your solution either).

    Now the last thing that won't work properly, is the CASE statement: whatever the value of the BIV field, I always get 'A' filled in. Anyone an idea how come?

    Thanks,

    Bart