Click here to Skip to main content
15,506,757 members
Home / Discussions / Database
   

Database

 
GeneralRe: how to create a sum query between multiple tables in Microsoft access Pin
Mycroft Holmes15-Aug-18 14:09
professionalMycroft Holmes15-Aug-18 14:09 
GeneralRe: how to create a sum query between multiple tables in Microsoft access Pin
CHill6020-Aug-18 5:15
mveCHill6020-Aug-18 5:15 
GeneralRe: how to create a sum query between multiple tables in Microsoft access Pin
Mycroft Holmes20-Aug-18 13:57
professionalMycroft Holmes20-Aug-18 13:57 
QuestionStored Procedure execution from Entity Framework should return 0 or -1 if insert or update fails Pin
indian1437-Aug-18 15:27
indian1437-Aug-18 15:27 
AnswerRe: Stored Procedure execution from Entity Framework should return 0 or -1 if insert or update fails Pin
Mycroft Holmes7-Aug-18 15:37
professionalMycroft Holmes7-Aug-18 15:37 
GeneralRe: Stored Procedure execution from Entity Framework should return 0 or -1 if insert or update fails Pin
indian1437-Aug-18 15:39
indian1437-Aug-18 15:39 
GeneralRe: Stored Procedure execution from Entity Framework should return 0 or -1 if insert or update fails Pin
Mycroft Holmes7-Aug-18 17:38
professionalMycroft Holmes7-Aug-18 17:38 
GeneralRe: Stored Procedure execution from Entity Framework should return 0 or -1 if insert or update fails Pin
indian1438-Aug-18 7:38
indian1438-Aug-18 7:38 
Yes I can understand that, but there are 25 tables with same Columns Code and Description, one table is selected with Dropdown to add, update or delete, so I have written just one stored procedure instead of writing multiple ones. That's why I used LookupTableId, Because I have listed all those tables into one LookupTable and the LookupTableId comes from that table.
I think it better suited for this scenario, but yes in general its not a good practice.

About Program Type, its always the same Program Type that's why I just took the id and used it.

Thanks,

Abdul Aleem

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

GeneralRe: Stored Procedure execution from Entity Framework should return 0 or -1 if insert or update fails Pin
Richard Deeming8-Aug-18 1:27
mveRichard Deeming8-Aug-18 1:27 
GeneralRe: Stored Procedure execution from Entity Framework should return 0 or -1 if insert or update fails Pin
indian1438-Aug-18 7:42
indian1438-Aug-18 7:42 
GeneralRe: Stored Procedure execution from Entity Framework should return 0 or -1 if insert or update fails Pin
Richard Deeming8-Aug-18 9:23
mveRichard Deeming8-Aug-18 9:23 
GeneralRe: Stored Procedure execution from Entity Framework should return 0 or -1 if insert or update fails Pin
indian1439-Aug-18 7:05
indian1439-Aug-18 7:05 
QuestionDATABASE Maintainance Pin
ricardobrooks6-Aug-18 4:12
ricardobrooks6-Aug-18 4:12 
AnswerRe: DATABASE Maintainance Pin
Victor Nijegorodov6-Aug-18 9:01
Victor Nijegorodov6-Aug-18 9:01 
AnswerRe: DATABASE Maintainance Pin
Eddy Vluggen6-Aug-18 9:15
professionalEddy Vluggen6-Aug-18 9:15 
GeneralRe: DATABASE Maintainance Pin
CHill606-Aug-18 23:01
mveCHill606-Aug-18 23:01 
Questionrecovery method for hard drive Pin
Member 139376004-Aug-18 5:08
Member 139376004-Aug-18 5:08 
AnswerRe: recovery method for hard drive Pin
Victor Nijegorodov4-Aug-18 21:34
Victor Nijegorodov4-Aug-18 21:34 
QuestionNeed to drop a schema in which there are some objects exist Pin
indian1431-Aug-18 7:28
indian1431-Aug-18 7:28 
AnswerRe: Need to drop a schema in which there are some objects exist Pin
Mycroft Holmes1-Aug-18 16:03
professionalMycroft Holmes1-Aug-18 16:03 
AnswerRe: Need to drop a schema in which there are some objects exist Pin
CHill602-Aug-18 3:26
mveCHill602-Aug-18 3:26 
QuestionRe: Need to drop a schema in which there are some objects exist Pin
CHill606-Aug-18 2:40
mveCHill606-Aug-18 2:40 
GeneralLegacy software: can't load MSJTER35.DLL Pin
Keith Sheppard228-Jul-18 0:26
Keith Sheppard228-Jul-18 0:26 
GeneralRe: Legacy software: can't load MSJTER35.DLL Pin
Victor Nijegorodov28-Jul-18 0:45
Victor Nijegorodov28-Jul-18 0:45 
GeneralRe: Legacy software: can't load MSJTER35.DLL Pin
Keith Sheppard22-Aug-18 2:23
Keith Sheppard22-Aug-18 2:23 

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.