All Questions
3 questions
3
votes
4
answers
513
views
How to Handle Item Prices Change for Reporting
I am building a Point of sales software with Sql Server 2008-R2. I am now confused about how to handle multiple items with prices change.
Let us say price of Pepsi is $2.0 on 10-09-2019 but today it'...
- 33
-2
votes
1
answer
353
views
Correct terminology for a table which provides "dynamic columns"
A common pattern in database design is to append dynamic columns to a table with a design like so:
create table MasterTable
(
Id int not null primary key
, Name nvarchar(64) not null unique
...
- 435
6
votes
1
answer
429
views
How to set up a sql database to cater for user records, group records and default records?
Outline
I have an application that loads data from a database. I'm not talking about client data here though, I'm talking about application configuration. The database will therefore come with some ...
- 169