Viewing 15 posts - 1 through 15 (of 25 total)
I already post data. I do not know exactly what you are asking. Could you enlighten me please?
February 14, 2015 at 1:28 pm
hi aaron,
I see you understands the FEFO system. Can you help me with my query?
February 6, 2015 at 8:10 am
that's exactly what I want to do but I could not find the right words to express myself. thank you in advance for your help
February 6, 2015 at 3:19 am
We can insert a new row with the same CODART 'M0001' but with a different CODMVT and NUMLOT. I make a stock management by batch number. the data that I...
February 5, 2015 at 6:11 pm
Here is a sample insertion in my database
according to this data sample I want to make out 400 units 'M0001' into table FAIRE but starting with the batch(NUMLOT) which expires...
February 5, 2015 at 11:54 am
For the 400 units that I want out my table "FAIRE" I will first make a inserstion 120 of 'M0001' which the batch number (NUMLOT) = "101023", then I shall...
February 5, 2015 at 11:46 am
Here is a sample insertion in my database
according to this data sample I want to make out 400 units 'M0001' into table FAIRE but starting with the batch(NUMLOT) which expires...
February 5, 2015 at 11:31 am
yes When i insert a new row into FAIRE with a CODART of M0001 i want to update the existing rows
February 5, 2015 at 11:24 am
clear for the 400 units requested first I'm an insertion of 120 and 80 Update and 200 in the table "FAIRE"
February 5, 2015 at 10:52 am
yes I do exactly the insertion of 120 units (CODART) = 'M0001' (expiry date (DATPEREMP): 12/02/2012) in table "FAIRE"
then I do the update of 80 units on the item (CODART)...
February 5, 2015 at 10:48 am
hi sean lange,
thank you for answered and thank you for the time you devoted to my problem.
In fact what I have based on this data sample is:
set up a query...
February 5, 2015 at 9:59 am
sorry I failed to make insertion into table 'FAMILLE_ARTICLE'.
Here the insertion script update and also the conversion of dates
--insert table famille_article
INSERT INTO [HEALTHBOARD].[dbo].[FAMILLE_ARTICLE]
...
January 30, 2015 at 2:53 pm
here is a new scripting tables in my database.
ps: my database is called HEALTHBOARD
USE [HEALTHBOARD]
GO
/****** Object: Table [dbo].[FAMILLE_ARTICLE] Script Date: 01/30/2015 17:02:05 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER...
January 30, 2015 at 10:12 am
Viewing 15 posts - 1 through 15 (of 25 total)