Ok it took a while , but I finaly got the picture.
case when convert(binary(2),freq_interval ) & 1 = 1 then 'Su-'
else '..-' end
+ case when convert(binary(2),freq_interval ) & 2 = 2 then 'Mo-'
else '..-' end
+ case when convert(binary(2),freq_interval ) & 4 = 4 then 'Tu-'
else '..-' end
+ case when convert(binary(2),freq_interval ) & 8 = 8 then 'We-'
else '..-' end
+ case when convert(binary(2),freq_interval ) & 16 = 16 then 'Th-'
else '..-' end
+ case when convert(binary(2),freq_interval ) & 32 = 32 then 'Fr-'
else '..-' end
+ case when convert(binary(2),freq_interval ) & 64 = 64 then 'Sa'
else '..' end
Thank you for your patience
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me