I need a tsql script to generate some test data 1. for each row in a table, read the companyid and customer name 2. for each company generate a 7 column transaction for each first of the month between the start date and the end date (current month) 3. test if transaction exists in a second table and if not, insert it a transaction would look like
...----- the Problem Will happen If the Customer Need to Delete the Transaction With ID=1 then I must re Calc All Rows again depend to the change , and this need very fast TSQL Code Please read the article as reference --- [kirjaudu nähdäksesi URL:n]
I Use Sql server 2012 I have ERP System and I need to calc FIFO,LIFO and Average cost in for the inventory Item I have 4 types of transaction 'IN' (Purchase) ,'OUT'... 210 the Problem Will happen If the Customer Need to Delete the Transaction With ID=1 then I must re Calc All Rows again depend to the change , and this need very fast TSQL Code
This is a relatively big job and having knowledge in working with XRX (XML / exist-db databases and XQuery server-side technology) will be essential, unless you can convince me otherwise. Our application consists of 14 pages (most of the same styling elements can be used across these pages). We would like to introduce Bootstrap framework to each page
...index management, integrity checks, configuration, patching. How statistics work, how indexes are stored, how they can be created and managed effectively. Strong experience in TSQL code Knowledge in Database Administration in SQL Server Knowledge to detect and troubleshoot SQL Server related CPU,memory,I/O, disk space and other resource contention
...apropiado en Electricidad / Electrónica o Ingeniería Informática o Control y Automatización Industrial • La experiencia de programación con .Net, C / C ++, C #, VB / VB.Net, SQL / TSQL / SQL + u otro lenguaje de alto nivel es una gran ventaja. • Experiencia en diseño / dibujo eléctrico con AutoCAD Electrical, Eplan, etc. es un a...
I cannot give you access to my database. I am looking for help summing when the account number changes. See Example. I want to Sum to total Cost from Table 'a' based on the Account#. In other words when the account number changes I want to stop, Add a line for the Totals. I don't want to repeat the Total Sales Price from Table 'b' over and over, I just want it once on the ...
...tables. The work needed is to extract the data from the source Azure SQL Server and load it into the destination DB according to the mapping rules. Coding should be done using TSQL in SSIS packages. There is also some data to be loaded to an Azure Cosmos DB from the source Azure SQL Server. There will be about 30 tables to load into the destination DB
I need a basic tsql query for a the attached spreadsheet to produce the desired output. I believe I need a subquery to output file where; Distinct records where the status <> 'Active' Where there are duplicate records with multiple Status I need to output only one record where there are no Status = 'Active' The purpose of the report is to determine
Hello, I need some XQuery code done. The instructions are in the attached file. Please take a look at it. I will award it to the lowest offer. Also I have another XPath code that I need done if you can do that as well, I will award that. Thank you
Please see the attached document. There are some simple XPath questions that I need answered. Cheapest offer will be awarded that project....the attached document. There are some simple XPath questions that I need answered. Cheapest offer will be awarded that project. Also have another project like this but with XQuery if you can do for cheap as well.
...which contains academic research on the inquisition [kirjaudu nähdäksesi URL:n] I need to do upgrades to the site which includes XML, XQUERY, XPATH and HTML/CSS and Ajax. I am both a medieval research and software developer. The site is very modular and the data is well architected, although the site is not