|
I try to avoid views of a view, but it fit my desire for DRY (Don't Repeat Yourself) and laziness. 
|
|
|
|
|
Bruce Patin wrote: When I write a View2 that uses a View1, if View1 is ever updated, View2 does not see the update until I ALTER (with no changes needed) View2.
Seek ye the sp_refreshview procedure. Use it as needed.
At my last job I implemented a procedure which ran it on all views in accordance with their dependencies. It was part of our standard prod deployment process.
|
|
|
|
|
|
Support them all and allow the user to choose what he wants. 
|
|
|
|
|
Wordle 1,125 5/6
β¬β¬β¬π¨β¬
β¬β¬β¬π¨π¨
β¬π©β¬β¬π¨
β¬π©π¨π©π©
π©π©π©π©π©
|
|
|
|
|
Wordle 1,125 3/6*
β¬β¬β¬β¬π¨
π¨β¬π¨π¨π¨
π©π©π©π©π©
|
|
|
|
|
Wordle 1,125 3/6*
β¬π¨β¬β¬π¨
β¬β¬π¨π¨π¨
π©π©π©π©π©
"I have no idea what I did, but I'm taking full credit for it." - ThisOldTony
"Common sense is so rare these days, it should be classified as a super power" - Random T-shirt
AntiTwitter: @DalekDave is now a follower!
|
|
|
|
|
Wordle 1,125 3/6*
β¬β¬β¬β¬π¨
β¬β¬π©π¨β¬
π©π©π©π©π©
Happiness will never come to those who fail to appreciate what they already have. -Anon
And those who were seen dancing were thought to be insane by those who could not hear the music. -Frederick Nietzsche
|
|
|
|
|
β¬π¨β¬π¨π¨
β¬β¬π¨π¨π¨
β¬β¬π¨π¨π¨
π¨π¨π©β¬β¬
π©π©π©π©π©
In a closed society where everybody's guilty, the only crime is getting caught. In a world of thieves, the only final sin is stupidity. - Hunter S Thompson - RIP
|
|
|
|
|
Wordle 1,125 4/6
β¬π¨β¬β¬π¨
β¬β¬π¨π¨π¨
π©π©π©π©β¬
π©π©π©π©π©
Within you lies the power for good - Use it!
|
|
|
|
|
Quote: Wordle 1,125 4/6
β¬π¨β¬π¨π¨
π¨π©π¨β¬β¬
π¨π©π©β¬π©
π©π©π©π©π©
Ok, I have had my coffee, so you can all come out now!
|
|
|
|
|
Wordle 1.125 3/6
π¨β¬π©β¬π©
β¬β¬β¬π¨β¬
π©π©π©π©π©
Fitting 
GCS/GE d--(d) s-/+ a C+++ U+++ P-- L+@ E-- W+++ N+ o+ K- w+++ O? M-- V? PS+ PE Y+ PGP t+ 5? X R+++ tv-- b+(+++) DI+++ D++ G e++ h--- r+++ y+++* Weapons extension: ma- k++ F+2 X
The shortest horror story: On Error Resume Next
|
|
|
|
|
Wordle 1,125 6/6*
β¬β¬β¬π¨π¨
β¬β¬π¨β¬π¨
β¬β¬π¨π¨π¨
π¨π¨π©β¬β¬
π©π©π©β¬π©
π©π©π©π©π©
|
|
|
|
|
If you sleep outdoors this time of the year in Norway, you must be prepared for limited darkness trough the night. Visitors from further south may have problems getting a good nights sleep. Indoors it should be less of a problem, you'd think - just pull the curtain. It doesn't always work ...
Every summer, Oslo, Norway, arranges an international giant soccer tournament for kids 6-16 years, called Norway Cup. It has been held since 1972; this year 12,000 kids are participating. The kids sleep in sleeping bags in the classrooms of schools nearby. About a thousand of them will sleep with the lights turned on in the ceiling.
Why? The lights are controlled by IR sensors. With 30 kids sleeping in the classroom, the sensors are not it doubt: People are present; lights should be turned on.
But isn't there a main switch for turning the light off, regardless of what the sensor says? Yes, there is - but that will also turn off the lights in the emergency signs, the arrows pointing in the direction of the exit, in case the building has to be evacuated. For security reasons, those lights cannot be turned off. Therefore the ceiling lights cannot be turned off in the room where the kids are sleeping.
I laughed out hysterically when I read this in the newspaper. Whoever designed this light control should be dipped in tar and rolled in feathers.
Religious freedom is the freedom to say that two plus two make five.
|
|
|
|
|
Once doing work in Hamburg Germany during the summer, I learned to get a hotel room with dark curtains if room had exterior view. It is about ~53 deg north, so sun rises very early and sets very late, more so in Norway.
"A little time, a little trouble, your better day"
Badfinger
|
|
|
|
|
Sunrise today: 03:54. Sunset: 22:52.
But don't think of it as 'dark' from sunset to sunrise! At 01:00 it is still enough light to read a newspaper outdoors, without the aid of artificial light.
Religious freedom is the freedom to say that two plus two make five.
|
|
|
|
|
Wow, I knew it wasn't very dark outside @1:00am, but I was looking for sleep at that time.
Far north (and south) locations are truly the "midnight sun" experience.
Here in TX, one can't wait for the sun to go down to get relief from the heat.
"A little time, a little trouble, your better day"
Badfinger
|
|
|
|
|
Smart lighting is more than 20 years old, where a mobile app can control dimming of lights. They could have used such a technology isn't it?
Since I was working for Philips for some years, am aware of this technology.
|
|
|
|
|
I've been in Norway at this time of year, at a latitude similar to Oslo, and dimming the lights wouldn't have much of a noticeable effect between about 11pm and 2am. It's probably better for the kids to practice sleeping in full light. 
|
|
|
|
|
Amarnath S wrote: Smart lighting is more than 20 years old
In this country, we started building schools much more than 20 years ago, some of them with a build quality to make them stand even today! 
I am sure that the manufacturers would be jumping of joy if every new technology announcement would make every school, and other public institution immediately throw out all their old stuff and replace it with the new technology. (Sometimes, I have a feeling that it is that way!) I am not sure that taxpayers are equally happy with it.
I have been pondering 'smart' technology for my home for 30 years. Except for being 'new' and something to show to my friends, I still haven't found a single area where it has any other value for me personally. I guess that the situation is the same in many schools. If all you get from smart technology is dimmable light: We had that in my childhood, decades before the term 'smart home' was conceived.
Religious freedom is the freedom to say that two plus two make five.
|
|
|
|
|
I don't know about Norway, but I am pretty sure not having emergency lighting isolated to its own circuit from the main board is illegal here.
Software rusts. Simon Stephenson, ca 1994. So does this signature. me, 2012
|
|
|
|
|
As it should be
In a closed society where everybody's guilty, the only crime is getting caught. In a world of thieves, the only final sin is stupidity. - Hunter S Thompson - RIP
|
|
|
|
|
That surprised me, too. I can't believe that the solution at that school is according to Norwegian regulations. We use to be very strict on such things.
But then, if the school was built 50 years ago, and regulations were less strict then, maybe it was legal in those days. Maybe the politicians were so concerned about unnecessary public spending that when regulations were tightened, they decided to leave the school untouched.
Religious freedom is the freedom to say that two plus two make five.
|
|
|
|
|
I just looked up a 1976 copy of Australian Standard 3000 (Wiring Rules), which makes it clear that those provisions (separate circuit, protected wiring etc) applied then.
Maybe the school administration can expect a visit from the electrical authority.
As an aside, last year I had some wiring changes/additions in my house (new bathroom), and although the existing wiring is quite modern, they had to add an earth stake (MEN system) to comply with 2023 regulations.
Software rusts. Simon Stephenson, ca 1994. So does this signature. me, 2012
|
|
|
|
|
trΓΈnderen wrote: that will also turn off the lights in the emergency signs, the arrows pointing in the direction of the exit, in case the building has to be evacuated
You do point out that it doesn't get dark. Those signs aren't visible unless they're lit? In broad daylight?
Seriously, if the building has to be evacuated, they'll somehow figure it out. It's a classroom, I'm guessing the school isn't that big.
Warning labels were made for the people in charge. F****** nanny state is everywhere apparently.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
