Is there a "bacth size setting" or some such t-sql option that determines the number of records sql will hold before commiting them as a group to the database?
TIA,
Barkingdog
Not that I know of, but you can use marshalling by setting up a loop and tellng it to commit.
In t-sql you can do the following to check if a value is odd or even. If it returns a 0 then the number is even, if it returns a 1 it is an odd number.
select @.Value%2
I need to do something similar in a backgroundColor expression in RS 2005, any ideas? I dont see any built-in function for this.
You could do something like this and just use the boolean result(pseudocode only, not tested)
(@.Value/2 = CInt(@.Value/2))
|||Thanks csi_hugh
This works great!
