Viewing 15 posts - 1,276 through 1,290 (of 1,419 total)
Besides assigning items like couch, lamps, bed to rooms, ... this UI is a tool to enforce which columns other UI's or database clients can see? So maybe it makes...
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
November 7, 2019 at 7:46 pm
The problem is that the requested parameters are dynamic over the time. And honestly, I can't imagine, in 2019, a DB design requiring view, SP and table update when...
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
November 6, 2019 at 2:35 pm
Is the value column in the T_ROOM_ATTRIBUTES table necessary? Why not delete row(s) (in T_ROOM_ATTRIBUTES) if a room no longer has attribute(s)?
Do you want the target output to always have...
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
November 5, 2019 at 9:53 pm
Note that it says "a query". It is literally, as you say, running one query, not multiple queries. Your representation is a different use case.
Yes one query. Run multiple...
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
November 4, 2019 at 10:23 pm
Nope, just wrong. Multi-version read consistency does not introduce phantom rows - it gives a consistent view of data at a single point in time. Databases are state machines...
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
November 4, 2019 at 9:17 pm
Right they won't see the 11th row because it's no longer the 11th row and displaying it as such is no longer accurate. They will see that row if...
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
November 4, 2019 at 6:43 pm
Or maybe not even locate the page. Just a tally function and table cardinality from dm view.
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
November 4, 2019 at 6:35 pm
This article mentions the "cte trick" to pagination. I wonder how how fast it would be locating the page and then using a tally table on rownums and then without...
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
November 4, 2019 at 5:49 pm
Nadella is a big fan of relational databases. As a business it can't be beat. Who wants to swap it out for something else? Lol (head explodes)
https://www.youtube.com/watch?v=0ey91VaQsOY
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
November 2, 2019 at 12:14 pm
To split the partial weeks use GROUP BY month. To get the weeks to align with your preferred days use dateadd to move the window. To generate dates this code...
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
October 31, 2019 at 3:37 pm
scdecade interesting stuff! If / when you get a public project going you should drop us a note!
Thanks! Yes I'm going to hopefully come up with a plan. At...
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
October 30, 2019 at 10:32 pm
So is the class JsonResourceResultsHandler your own class(?) or part of the api? Couldn't google it %^)
It's part of a C# library called JsonAutoService I developed originally to help...
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
October 30, 2019 at 8:39 pm
Where you attempt to insert with an incorrect column name it results in a compile time error. Sql Server is not able to come up with an execution plan for...
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
October 30, 2019 at 6:56 pm
Did you try openrowset?
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
October 30, 2019 at 6:04 pm
I haven't played with net core, do you have any info on the type conversion differences? I can't find anything, weak google fu I guess.
In C# since 5 years...
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
October 30, 2019 at 4:14 pm
Viewing 15 posts - 1,276 through 1,290 (of 1,419 total)