Click here to Skip to main content
15,908,437 members
Home / Discussions / Database
   

Database

 
GeneralRe: Table Database Advice Pin
JackMisani25-Feb-18 22:43
JackMisani25-Feb-18 22:43 
AnswerRe: Table Database Advice Pin
Eddy Vluggen22-Feb-18 6:51
professionalEddy Vluggen22-Feb-18 6:51 
AnswerRe: Table Database Advice Pin
jschell23-Feb-18 13:44
jschell23-Feb-18 13:44 
GeneralRe: Table Database Advice Pin
JackMisani25-Feb-18 22:49
JackMisani25-Feb-18 22:49 
QuestionError converting data type nvarchar to datetime Pin
indian14321-Feb-18 11:13
indian14321-Feb-18 11:13 
AnswerRe: Error converting data type nvarchar to datetime Pin
Mycroft Holmes21-Feb-18 12:11
professionalMycroft Holmes21-Feb-18 12:11 
AnswerRe: Error converting data type nvarchar to datetime Pin
Member 1226788921-Feb-18 19:21
Member 1226788921-Feb-18 19:21 
QuestionNeed some suggestion Pin
indian14321-Feb-18 7:58
indian14321-Feb-18 7:58 
Hi,

I have been given an already existing application to modify, there is a need to modify an existing Table in the Database also, so I added a new Table which has association of the old tables to create a many to many relationship with unique combination. Like for example if Unit Cost of a Service and Program was same for all Cities earlier now I have added a Table which has ServiceProgramCostId, CityId and Unit Cost, which is ServiceProgramCityCostId as PK.
Now the problem came with communication, I am trying to explain my manager that this same City impact will have in other tables as well, its better to create a combination for LineItemsServiceProgramCityCost instead of LineItemsServiceProgramCost and BusinessRulesServiceProgramCityCost instead of BusinessRulesServiceProgramCost as well, as they are now dependent upon the City.

The other thing is the Previous Developer was deleting the orphaned records from ServiceProgramCost table so with new Combination ServiceProgramCityCost I am not able to delete the records from LineItemsServiceProgramCost, BusinessRulesServiceProgramCost tables like earlier, because the deletion now means from BusinessRulesServiceProgramCityCost table, I am becoming nervous about deleting records from LineItemsServiceProgramCost, BusinessRulesServiceProgramCost tables.

My question is, is it not better to use the new city relationship in those two tables is better or is it better to go ahead with old approach but limiting the deletes? The previous developer who worked is just saying simple what's there? But not suggesting me or maybe saying with Manager that I am not able to work or something. Our Business Analyst is on maternity leave.

Any idea would be greatly helpful - thanks in advance.

Thanks,

Abdul Aleem

"There is already enough hatred in the world lets spread love, compassion and affection."

QuestionDBAs- What is your biggest pet peeve with developers? Pin
Member 1320002419-Feb-18 13:32
Member 1320002419-Feb-18 13:32 
JokeRe: DBAs- What is your biggest pet peeve with developers? Pin
Mycroft Holmes19-Feb-18 15:25
professionalMycroft Holmes19-Feb-18 15:25 
AnswerRe: DBAs- What is your biggest pet peeve with developers? Pin
Eddy Vluggen19-Feb-18 17:13
professionalEddy Vluggen19-Feb-18 17:13 
AnswerRe: DBAs- What is your biggest pet peeve with developers? Pin
ZurdoDev20-Feb-18 2:10
professionalZurdoDev20-Feb-18 2:10 
AnswerRe: DBAs- What is your biggest pet peeve with developers? Pin
S Douglas8-Mar-18 5:13
professionalS Douglas8-Mar-18 5:13 
QuestionCan a computer install multiple versions of SQL Server Management Studio ? Pin
Member 245846712-Feb-18 15:58
Member 245846712-Feb-18 15:58 
AnswerRe: Can a computer install multiple versions of SQL Server Management Studio ? Pin
Chris Quinn12-Feb-18 21:53
Chris Quinn12-Feb-18 21:53 
AnswerRe: Can a computer install multiple versions of SQL Server Management Studio ? Pin
phil.o13-Feb-18 0:16
professionalphil.o13-Feb-18 0:16 
GeneralRe: Can a computer install multiple versions of SQL Server Management Studio ? Pin
jschell13-Feb-18 15:26
jschell13-Feb-18 15:26 
GeneralRe: Can a computer install multiple versions of SQL Server Management Studio ? Pin
phil.o13-Feb-18 15:39
professionalphil.o13-Feb-18 15:39 
AnswerRe: Can a computer install multiple versions of SQL Server Management Studio ? Pin
MadMyche23-Feb-18 3:37
professionalMadMyche23-Feb-18 3:37 
QuestionHow can I convert SQL Server data file version ? Pin
Member 24584678-Feb-18 14:39
Member 24584678-Feb-18 14:39 
AnswerRe: How can I convert SQL Server data file version ? Pin
Mycroft Holmes8-Feb-18 14:57
professionalMycroft Holmes8-Feb-18 14:57 
AnswerRe: How can I convert SQL Server data file version ? Pin
Chris Quinn8-Feb-18 22:56
Chris Quinn8-Feb-18 22:56 
AnswerRe: How can I convert SQL Server data file version ? Pin
jschell10-Feb-18 6:44
jschell10-Feb-18 6:44 
QuestionSql Server 2017 with Transact and synonyms Problems. Microsoft does not respond. Pin
zequion7-Feb-18 19:48
professionalzequion7-Feb-18 19:48 
Questionhow to delete specific data from multiple tables in sql database Pin
Ko Htet Kyaw7-Feb-18 5:53
Ko Htet Kyaw7-Feb-18 5:53 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.