Click here to Skip to main content
14,635,075 members
Home » Discussions » Database
   

Database

 
GeneralRe: Sql server deadlock issue with table bulk insert and update on same table Pin
kali siddhu30-Jun-20 23:29
Memberkali siddhu30-Jun-20 23:29 
GeneralRe: Sql server deadlock issue with table bulk insert and update on same table Pin
Richard MacCutchan30-Jun-20 23:31
mveRichard MacCutchan30-Jun-20 23:31 
GeneralRe: Sql server deadlock issue with table bulk insert and update on same table Pin
David Mujica1-Jul-20 5:36
MemberDavid Mujica1-Jul-20 5:36 
GeneralRe: Sql server deadlock issue with table bulk insert and update on same table Pin
kali siddhu15-Jul-20 23:44
Memberkali siddhu15-Jul-20 23:44 
AnswerRe: Sql server deadlock issue with table bulk insert and update on same table Pin
ZurdoDev1-Jul-20 7:03
mveZurdoDev1-Jul-20 7:03 
QuestionHttp 500 error with register page Pin
and180y29-Jun-20 4:31
Memberand180y29-Jun-20 4:31 
AnswerRe: Http 500 error with register page Pin
ZurdoDev29-Jun-20 4:33
mveZurdoDev29-Jun-20 4:33 
GeneralRe: Http 500 error with register page Pin
and180y29-Jun-20 4:45
Memberand180y29-Jun-20 4:45 
GeneralRe: Http 500 error with register page Pin
ZurdoDev29-Jun-20 4:49
mveZurdoDev29-Jun-20 4:49 
AnswerRe: Http 500 error with register page Pin
Richard Deeming29-Jun-20 5:15
mveRichard Deeming29-Jun-20 5:15 
GeneralRe: Http 500 error with register page Pin
and180y29-Jun-20 5:21
Memberand180y29-Jun-20 5:21 
GeneralRe: Http 500 error with register page Pin
and180y29-Jun-20 7:40
Memberand180y29-Jun-20 7:40 
GeneralRe: Http 500 error with register page Pin
Richard MacCutchan29-Jun-20 9:36
mveRichard MacCutchan29-Jun-20 9:36 
GeneralRe: Http 500 error with register page Pin
and180y29-Jun-20 12:37
Memberand180y29-Jun-20 12:37 
GeneralRe: Http 500 error with register page Pin
Richard MacCutchan29-Jun-20 21:44
mveRichard MacCutchan29-Jun-20 21:44 
GeneralRe: Http 500 error with register page Pin
and180y1-Jul-20 8:03
Memberand180y1-Jul-20 8:03 
GeneralRe: Http 500 error with register page Pin
Richard MacCutchan1-Jul-20 9:10
mveRichard MacCutchan1-Jul-20 9:10 
GeneralRe: Http 500 error with register page Pin
and180y1-Jul-20 9:42
Memberand180y1-Jul-20 9:42 
GeneralRe: Http 500 error with register page Pin
and180y1-Jul-20 13:11
Memberand180y1-Jul-20 13:11 
GeneralRe: Http 500 error with register page Pin
Richard MacCutchan1-Jul-20 22:37
mveRichard MacCutchan1-Jul-20 22:37 
GeneralRe: Http 500 error with register page Pin
and180y2-Jul-20 4:57
Memberand180y2-Jul-20 4:57 
QuestionReporting data Pin
Joan M19-Jun-20 10:03
professionalJoan M19-Jun-20 10:03 
AnswerRe: Reporting data Pin
Mycroft Holmes19-Jun-20 12:25
professionalMycroft Holmes19-Jun-20 12:25 
Joan M wrote:
And I would like to solve this in the database part, not creating different tables and then working in the PHP area
Wrong tools for the jobs, database for servicing your data query and PHP for the presentation.

You could store your queries in a table, relate them to a query/stored proc and expose a title in a combo box for the user to select. Display would need to be an auto generated table to support different result sets.

The problem with this is that you may need to support different filtering parameters and you end up with an entire framework to support the reporting when it is faster and simpler to build a result page and query for each report request.
Never underestimate the power of human stupidity -
RAH
I'm old. I know stuff - JSOP

GeneralRe: Reporting data Pin
Joan M20-Jun-20 1:11
professionalJoan M20-Jun-20 1:11 
GeneralRe: Reporting data Pin
David Mujica22-Jun-20 4:27
MemberDavid Mujica22-Jun-20 4:27 

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.