Click here to Skip to main content
       

Database

 
AnswerRe: SQL Server 2008 Pinmemberjschell11-Feb-13 8:20 
Questionupdate values in a table in single query Pinmembernainakarri7-Feb-13 20:07 
AnswerRe: update values in a table in single query PinmemberMycroft Holmes7-Feb-13 21:00 
GeneralRe: update values in a table in single query PinmemberShameel10-Feb-13 22:38 
GeneralRe: update values in a table in single query PinmemberMycroft Holmes11-Feb-13 13:30 
AnswerRe: update values in a table in single query PinmvpEddy Vluggen7-Feb-13 22:42 
GeneralRe: update values in a table in single query Pinmembergvprabu10-Feb-13 18:02 
AnswerRe: update values in a table in single query Pinmembergvprabu20-Feb-13 21:43 
QuestionIs it possible to print a variable in stored procedure PinmemberDeepthi.214567-Feb-13 19:45 
AnswerRe: Is it possible to print a variable in stored procedure Pinmembernainakarri7-Feb-13 20:22 
GeneralRe: Is it possible to print a variable in stored procedure Pinmembervanikanc12-Feb-13 8:19 
QuestionVisual Studio 2005 Access 2010 Database PinmemberMember 98194707-Feb-13 12:06 
AnswerRe: Visual Studio 2005 Access 2010 Database PinmemberMycroft Holmes7-Feb-13 13:45 
QuestionSimulate transaction: non blocking insert / update PinmemberBob Stanneveld7-Feb-13 11: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 PinmemberMycroft Holmes7-Feb-13 13:44 
QuestionPropagating a MySQL transaction with MSMQ II PinmemberGer Hayden6-Feb-13 8:08 
QuestionMissing Data in an Access Report PinmemberVuyiswa Maseko6-Feb-13 3:03 
AnswerRe: Missing Data in an Access Report Pinmemberjschell6-Feb-13 8:11 
GeneralRe: Missing Data in an Access Report PinmemberVuyiswa Maseko6-Feb-13 19:01 
GeneralRe: Missing Data in an Access Report Pinmemberjschell7-Feb-13 9:52 
AnswerRe: Missing Data in an Access Report PinmemberMycroft Holmes6-Feb-13 12:27 
GeneralRe: Missing Data in an Access Report PinmemberVuyiswa Maseko6-Feb-13 19:06 
GeneralRe: Missing Data in an Access Report PinmemberMycroft Holmes6-Feb-13 20:27 
GeneralRe: Missing Data in an Access Report PinmemberVuyiswa Maseko6-Feb-13 20:32 
GeneralRe: Missing Data in an Access Report Pinmemberjschell7-Feb-13 9:56 
Questionoracle error with winserver2008 Pinmemberfares35-Feb-13 1:03 
AnswerRe: oracle error with winserver2008 PinmemberBernhard Hiller5-Feb-13 4:57 
Questionchar(255) vs varchar(255) vs varchar(MAX) Pinmemberdevvvy1-Feb-13 18:22 
AnswerRe: char(255) vs varchar(255) vs varchar(MAX) PinmvpRichard MacCutchan1-Feb-13 23:07 
GeneralRe: char(255) vs varchar(255) vs varchar(MAX) [modified] Pinmemberdevvvy2-Feb-13 15:39 
AnswerRe: char(255) vs varchar(255) vs varchar(MAX) PinmemberPIEBALDconsult2-Feb-13 5:22 
GeneralRe: char(255) vs varchar(255) vs varchar(MAX) Pinmemberdevvvy2-Feb-13 23:30 
GeneralRe: char(255) vs varchar(255) vs varchar(MAX) Pinmemberjschell3-Feb-13 6:36 
QuestionSP Unexpected Behavior Pinmembereddieangel1-Feb-13 7:19 
QuestionEncrypt a field in the database. Pinmembervanikanc1-Feb-13 5:31 
AnswerRe: Encrypt a field in the database. PinmvpEddy Vluggen1-Feb-13 7:02 
Questioncheck before insert Pinmembervanikanc31-Jan-13 4:55 
AnswerRe: check before insert PinmvpEddy Vluggen31-Jan-13 5:00 
GeneralRe: check before insert PinmvpEddy Vluggen31-Jan-13 10:35 
AnswerRe: check before insert Pinmembermark merrens31-Jan-13 8:10 
GeneralRe: check before insert Pinmembervanikanc31-Jan-13 8:21 
GeneralRe: check before insert Pinmembermark merrens31-Jan-13 10:09 
GeneralRe: check before insert PinmemberChris Meech31-Jan-13 10:24 
GeneralRe: check before insert Pinmembermark merrens31-Jan-13 10:25 
AnswerRe: check before insert Pinmemberdjj551-Feb-13 7:50 
GeneralRe: check before insert Pinmembervanikanc1-Feb-13 7:55 
GeneralRe: check before insert Pinmemberdjj551-Feb-13 8:25 
QuestionIdentify DML changes between two databases PinmemberMember 313707830-Jan-13 20:56 
AnswerRe: Identify DML changes between two databases PinmemberMycroft Holmes30-Jan-13 21:11 
GeneralRe: Identify DML changes between two databases PinmemberMember 313707830-Jan-13 21:26 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    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
Web04 | 2.8.140926.1 | Last Updated 1 Oct 2014
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid