All Questions
Tagged with sql-server design-patterns
7 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
0
votes
1
answer
199
views
Venue Reservation System Logic Approach/Clarification
I hope this is the right place to ask since this is a programming related question.
I’m developing a venue reservation app (similar to booking.com) and am almost done however I have 1 request for ...
- 103
-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
2
votes
3
answers
69
views
Verbose specification of exact Table or Implied
Consider the following two queries in SQL (Transact SQL):
UPDATE [database_name].[dbo].[table_name]
SET [database_name].[dbo].[table_name].[field_name] = @value
WHERE [database_name].[dbo].[...
- 131
2
votes
2
answers
171
views
Pricing File Creator
Problem
We have a number of different customers getting a number of different price files, each customer can then also have different styles of pricing files for example customers can have just two ...
- 123
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
0
votes
3
answers
353
views
Search on multiple values
I have a database having around 15 tables.Currently I am working on a report generation page, which is having 16 criteria.The values are distributed among multiple tables.User can select any number of ...
- 123