Click here to Skip to main content
12,754,745 members (34,671 online)
   

Database

 
GeneralRe: update values in a table in single query Pin
gvprabu10-Feb-13 19:02
membergvprabu10-Feb-13 19:02 
AnswerRe: update values in a table in single query Pin
gvprabu20-Feb-13 22:43
membergvprabu20-Feb-13 22:43 
QuestionIs it possible to print a variable in stored procedure Pin
Deepthi.214567-Feb-13 20:45
memberDeepthi.214567-Feb-13 20:45 
AnswerRe: Is it possible to print a variable in stored procedure Pin
nainakarri7-Feb-13 21:22
membernainakarri7-Feb-13 21:22 
GeneralRe: Is it possible to print a variable in stored procedure Pin
vanikanc12-Feb-13 9:19
membervanikanc12-Feb-13 9:19 
QuestionVisual Studio 2005 Access 2010 Database Pin
Member 98194707-Feb-13 13:06
memberMember 98194707-Feb-13 13:06 
AnswerRe: Visual Studio 2005 Access 2010 Database Pin
Mycroft Holmes7-Feb-13 14:45
memberMycroft Holmes7-Feb-13 14:45 
QuestionSimulate transaction: non blocking insert / update Pin
Bob Stanneveld7-Feb-13 12:12
memberBob Stanneveld7-Feb-13 12:12 
Hello,

We're currently implementing a warehouse management system with some customizations. One task is to plan the work in the warehouse by releasing waves of picking activities. The release is handled by a stored procedure. This stored procedure generates data on the amount of work that needs to be done, number of containers that are required, etc.. The planner needs to know this information in order to release the appropriate waves.

So, in order to capture the required data, we have another stored procedure which releases all waves that are not yet released and rolls back the transaction once it's done. This roll-back is a guarantee. The problem is that during this 'simulation' other queries are blocked, which creates a performance problem.

Is there a way to run the 'simulation' without blocking all other queries?


Thanks in advance!


Kind regards,
Bob Stanneveld
AnswerRe: Simulate transaction: non blocking insert / update Pin
Mycroft Holmes7-Feb-13 14:44
memberMycroft Holmes7-Feb-13 14:44 
QuestionPropagating a MySQL transaction with MSMQ II Pin
Ger Hayden6-Feb-13 9:08
memberGer Hayden6-Feb-13 9:08 
QuestionMissing Data in an Access Report Pin
Vuyiswa Maseko6-Feb-13 4:03
memberVuyiswa Maseko6-Feb-13 4:03 
AnswerRe: Missing Data in an Access Report Pin
jschell6-Feb-13 9:11
memberjschell6-Feb-13 9:11 
GeneralRe: Missing Data in an Access Report Pin
Vuyiswa Maseko6-Feb-13 20:01
memberVuyiswa Maseko6-Feb-13 20:01 
GeneralRe: Missing Data in an Access Report Pin
jschell7-Feb-13 10:52
memberjschell7-Feb-13 10:52 
AnswerRe: Missing Data in an Access Report Pin
Mycroft Holmes6-Feb-13 13:27
memberMycroft Holmes6-Feb-13 13:27 
GeneralRe: Missing Data in an Access Report Pin
Vuyiswa Maseko6-Feb-13 20:06
memberVuyiswa Maseko6-Feb-13 20:06 
GeneralRe: Missing Data in an Access Report Pin
Mycroft Holmes6-Feb-13 21:27
memberMycroft Holmes6-Feb-13 21:27 
GeneralRe: Missing Data in an Access Report Pin
Vuyiswa Maseko6-Feb-13 21:32
memberVuyiswa Maseko6-Feb-13 21:32 
GeneralRe: Missing Data in an Access Report Pin
jschell7-Feb-13 10:56
memberjschell7-Feb-13 10:56 
Questionoracle error with winserver2008 Pin
fares35-Feb-13 2:03
memberfares35-Feb-13 2:03 
AnswerRe: oracle error with winserver2008 Pin
Bernhard Hiller5-Feb-13 5:57
memberBernhard Hiller5-Feb-13 5:57 
Questionchar(255) vs varchar(255) vs varchar(MAX) Pin
devvvy1-Feb-13 19:22
memberdevvvy1-Feb-13 19:22 
AnswerRe: char(255) vs varchar(255) vs varchar(MAX) Pin
Richard MacCutchan2-Feb-13 0:07
mvpRichard MacCutchan2-Feb-13 0:07 
GeneralRe: char(255) vs varchar(255) vs varchar(MAX) Pin
devvvy2-Feb-13 16:39
memberdevvvy2-Feb-13 16:39 
AnswerRe: char(255) vs varchar(255) vs varchar(MAX) Pin
PIEBALDconsult2-Feb-13 6:22
memberPIEBALDconsult2-Feb-13 6:22 

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.


Advertise | Privacy | Mobile
Web01 | 2.8.170217.1 | Last Updated 21 Feb 2017
Copyright © CodeProject, 1999-2017
All Rights Reserved. Terms of Service
Layout: fixed | fluid