« first day (2518 days earlier)      last day (2649 days later) » 

ypercubeᵀᴹ
ypercubeᵀᴹ
18:05
per say ...
Thank you. This is an interesting link you posted. I don't require nosql per say. But the backend I will be using for my app which has all the functionalities I want, offers (like many backends) noSql type of database — Snake 45 mins ago
Sami
Sami
Hello everyone
SQL Server 2008:
I have a table called `Machines` with columns `MachineID, MachineName, Counter`.
and another table called PreventiveMaintenance which hold the types of the maintenance that the machine should do 
+----+------------+
| ID |     PM     |
+----+------------+
|  1 |    PM 250  |
|  2 |    PM 500  |
|  3 |    PM 750  |
|  4 |    PM 1000 |
|  5 |    PM 2000 |
|  6 |    PM 6000 |
+----+------------+
The conditions:
If the machine work 250H it should do a PM250
If the machine work 500H it should do a PM500
...until 6000H
then
If the machine work 6250H it should do a PM250
There is a table relate those tables called PM_Machine
Tom V
Tom V
@ypercubeᵀᴹ brrr
Sami
Sami
When for example Machine.Counter = 250
then insert a row in PM_Machine
Tom V
Tom V
Don't try Latin if you don't get it
Andriy M
Andriy M
@ypercubeᵀᴹ I think that's how per se is pronounced in English.
ypercubeᵀᴹ
ypercubeᵀᴹ
18:14
@AndriyM Yeah, pronounced maybe, not written.
Joe Obbish
Joe Obbish
@TomV The comment doesn't require latin per say
3
Tom V
Tom V
@JoeObbish exactly
Look I make a lot of errors when trying to write or speak English or French when required. When it adds nothing and you're just trying to be fancy make sure you master it
ypercubeᵀᴹ
ypercubeᵀᴹ
@TomV what's your native language? I thought it was French
Tom V
Tom V
Dutch but I honestly think my French is ok
Better than my English anyway
Joe Obbish
Joe Obbish
yeah I used to occasionally use latin like that
then I realized that I was being stupid and it added nothing, so I stopped
Sami
Sami
18:18
Ok
Joe Obbish
Joe Obbish
is "etc" latin?
Tom V
Tom V
@JoeObbish in origin
Et cetera is
Joe Obbish
Joe Obbish
well I'm guilty of that one, but I think no others
Tom V
Tom V
E. G. Is too
Joe Obbish
Joe Obbish
I stopped using that one
Sami
Sami
18:20
Etc
French
Which mean "Etcetera" in english
Tom V
Tom V
Etc would probably work equally well if you just used 'and so on' in English
Sami
Sami
Now, I understand that my question is not clear
Tom V
Tom V
French would probably be 'et ainsi (de suite)'
Sami
Sami
You mean "La suite"?
Tom V
Tom V
@Sami no
Tom V
Tom V
18:41
@AndriyM siekwel is how sql would be pronounced in Dutch but that doesn't make it correct
Sami
Sami
Now, mybe may question will be clear rextester.com/LAF54811
I need just an idea to solve this problem. Please
ypercubeᵀᴹ
ypercubeᵀᴹ
@TomV Be siek, get wel. siekwel.
Tom V
Tom V
18:59
@ypercubeᵀᴹ no sick:well = NoSQL
@Sami what problem?
@Sami if I understand what you mean it's an application problem
Joe Obbish
Joe Obbish
yeah, there wasn't a question mark that I could find in any part of that
Tom V
Tom V
19:18
I especially don't see how the database can distinguish between a machine operating 8 hours or breaking down
I'm probably missing something. That happens a lot
Paul White
Paul White
@TomV How often? Once per say?
😀
Joe Obbish
Joe Obbish
hiss
Paul White
Paul White
Yeah it hurt typing that
Sami
Sami
@TomV Why it's an application problem? I try to use a trigger on "Machines" table
but my trigger will fail when the value of "Machines.MachineCounter" > 6000
Joe Obbish
Joe Obbish
github is "git for dummies", right? yet I still find it difficult to use...
Tom V
Tom V
19:40
@PaulWhite are you here all week? I'll check out the veal
@Sami what trigger? I don't see any in your code
Joe Obbish
Joe Obbish
Anyone got any ideas for dumb things involving CCIs (bad column definitions, maintenance issues, partition definitions) that can be programmatically checked for? Already got a list of 20 or so
ypercubeᵀᴹ
ypercubeᵀᴹ
20:00
@JoeObbish it's a git repo + a fancy web interface
Nothing stops you from not using it ;)
Joe Obbish
Joe Obbish
not true
there's this guy who lifts weights who is making me use it
ypercubeᵀᴹ
ypercubeᵀᴹ
@JoeObbish ah, I suppose you have to use it to make PRs?
Joe Obbish
Joe Obbish
I don't know what a PR is
personal record?
ypercubeᵀᴹ
ypercubeᵀᴹ
pull request
But I don't see how one can "make" you use github. A github repository is a git repository, as any other.
What are you forced to do?
Joe Obbish
Joe Obbish
well I don't know anything
so that limits my options

« first day (2518 days earlier)      last day (2649 days later) »