SQL-2008 Query in FIFO (First in First out) Costing Inventory Method

I need SQL QRY to allocate Cost Price of Inventory out as per FIFO Inventory method. Also Apply QRY to the data given in attached excel file (for test purpose).

For the Consider below mentioned steps and Example.

Step 1 – Create Table

CREATE TABLE [dbo].[StockTable] (

[TransNo] [numeric](18, 0) NULL ,

[TransDate] [smalldatetime] NULL ,

[TransPCode] [char] (8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

[TransProductQty] [decimal](18, 5) NULL ,

[TransCostRate] [decimal](18, 5) NULL ,

[TransSalePrice] [decimal](18, 5) NULL ,

[TransProductValue] [decimal](18, 5) NULL ,

[TransCostValue] [decimal](18, 5) NULL ,

[TransType] [char] (4) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

[TransInOut] [char] (4) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

[TransYear] [numeric](18, 0) NULL ,

[TransStore] [char] (22) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,



Step 2 – Insert Data (from Excel Data File attached)

Use SQL Data Import Wizard

Table 1: Example of stock movement

Квалификация: SQL, SQL-сервер Microsoft, Microsoft Access, Программирование баз данных, Управление базами данных

Показать больше vbnet sql print query, excel sql multiple query, visual basic 2008 query access database, issues sql 2008, sql 2008 deployment aspnet, upgrade crm sql 2008, sql 200 database convert sql 2008, net fileupload sql 2008 image data type, convert access database sql 2008, convert bak sql 2008, sql 2008 bids cusom query, query tree structure table sql 2008, sql server 2008 query latitude longitude radius, wcf application insert database sql 2008 vbnet query, test sql server 2008 query commands, sql 2008 query test tde, sale inventory system visual studio 2010 sql 2008

О работодателе:
( 4 отзыв(-а, -ов) ) LAHORE, Pakistan

ID проекта: #22757945



I have deep and proven experience in T-SQL development and debugging of queries with huge complexity. My total MSSQL Experience is 10+ years. Five of them was within USA company as Senior SQL/BI Developer. My everyday Больше

$56 USD за 7 дней(-я)
(5 отзывов(-а))

16 фрилансеров(-а) в среднем готовы выполнить эту работу за $28


I had done a similar Access projects before with 5* ratings: • https://www.freelancer.com/projects/database-programming/legal-finances-database-improvements/ • https://www.freelancer.com/projects/php/build-ACCESS-Data Больше

$26 USD за 17 дней(-я)
(26 отзывов(-а))

Please review my profile. https://www.freelancer.com/u/vw7590795vw.html I have 10.1 years experience in MS SQL Server and 7.4 years experience in SSRS, SSIS (Import / Export). Please let me know more details and when Больше

$30 USD за 1 день
(23 отзывов(-а))

Hi I am a Senior DBA with more than 15 years experience in sql server. I can help you. I've already done this task, I can start now. Regards.-

$30 USD за 1 день
(8 отзывов(-а))

I am good in sql along with automation and development, please let me know if you are good to award this project to me

$30 USD за 2 дней(-я)
(2 отзывов(-а))

• 20+ years’ experience Software Development - Since 1997 • 15+ years’ experience C#/.NET software development - Since 2004 • 17+ years’ experience ASP.NET Web Form ASPX - Since 2002 • 5+ years’ experience ASP.NET M Больше

$30 USD за 7 дней(-я)
(4 отзывов(-а))

Hello. I  have more then 10 years of experience in SQL Server databse development and Administration. I have worked with medium to large mission critical databases. Worked for database design and performance tuning. Больше

$55 USD за 1 день
(3 отзывов(-а))

Hi I have 6.5 years of experience in Business Analytics and Data Architecture. Expertise in building end-to-end BI Infrastructure across industries including developing Data Models, Data Warehouses and creating visua Больше

$30 USD за 3 дней(-я)
(1 отзыв)

Hi, I am able to complete your work in the specified time and budget. Please feel free to contact me with further details. Best Regards, Tinashe

$15 USD за 2 дней(-я)
(2 отзывов(-а))

I am Administrative Assistant with plenty of experience handling a number of tasks including - but not limited to - filing, transcription, data entry, taking calls from clients, scheduling, researching, and making trav Больше

$20 USD за 1 день
(0 отзывов(-а))

hi, I am having experience in .Net, VB, C#, SQL DB. Developed and delivered projects like payroll, Hospital management, Stock Management and service management systems etc., As of my understanding, SQL QRY to allocat Больше

$20 USD за 1 день
(0 отзывов(-а))

I am a certified Professional Data Engineer who has worked a lot on SQL, especially MySQL. Using SQL Server would be much easier because of the extra features. I am very good with SQL and I have worked on problem state Больше

$22 USD за 4 дней(-я)
(0 отзывов(-а))

I have 6 years of experience in SQL server and currently I am working with Gulf international bank.

$20 USD за 1 день
(0 отзывов(-а))

Hi, Thanks for the posting. I am writing this after reviewed your project description & attachments. I am interested in your project and Kindly drop a message so we can discuss. • Over 7+ Years I've been working on an Больше

$15 USD за 2 дней(-я)
(1 отзыв)

Have proficiency level experience working with IBM DB2, SQL server, Oracle and Amazon redshift for 4.4 years at Accenture which I would think I can get this proposal

$30 USD за 3 дней(-я)
(0 отзывов(-а))

=====SQL Expert======== Thanks for nice Post. Your Post fully match my previous work and present work. I Hope i am the best candidate for you. Please [login to view URL] will discuss on chat session

$25 USD за 2 дней(-я)
(0 отзывов(-а))