Viewing 15 posts - 10,816 through 10,830 (of 59,064 total)
solus - Tuesday, October 23, 2018 4:13 AMposition.loadshape is varchar(64) and its nullable
Then instead of using IS NOT NULL, try the following...
October 23, 2018 at 6:22 am
Hold the phone a minute, please. What is the datatype of the position.loadshape column? If it's a numeric datatype, what is the minimum value that it can be?
October 22, 2018 at 8:36 pm
[code...October 22, 2018 at 8:26 pm
October 22, 2018 at 3:56 pm
Hmmmmm.... pulling data from production and putting it on another server... sounds like a security issue just waiting to happen to me.
October 22, 2018 at 12:14 pm
October 22, 2018 at 11:52 am
October 22, 2018 at 11:16 am
It's not that easy. You have to understand the whole gambit of things including the real meaning of protecting data at rest as well as encryption of the sensitive columns...
October 22, 2018 at 9:06 am
October 22, 2018 at 7:16 am
p.s. Eirikur has the beginning of the code with his reference to sys.databases.
October 22, 2018 at 4:57 am
Viewing 15 posts - 10,816 through 10,830 (of 59,064 total)