[solved] unknown syntax of stored procedure
-
Hi Experts, in an existing sp at our company I find this: SET @MonthFrom=(@Month%12)-1 where @Monthis a calling parameter and @MonthFrom is declared within the sp. Can someone please explain what "%12" means? Thank you, Bernd
It is called The modulo arithmetic operator[^] It returns the remainder of dividing @month by 12.
-
It is called The modulo arithmetic operator[^] It returns the remainder of dividing @month by 12.
-
Hi Peter, thx for your help. I could no determine that from the code and without a clue I was unable to find it in the internet. Now I wonder what sense this makes? None?!? Greets Bernd
You are welcome. Please do one thing, according to CP instruction : "If your problem was answered then edit your message and add "[Solved]" to the subject line of the original post, and cast an approval vote to the one or several answers that really helped you." Thanks.