SQL Jobs

ecommerce web app with used items and users can add items and also same can buy in product user can add item for maintainance first then show for sale and admin panel for managemnet and reports

Building an ETL process to load data from Source system to a SQL datawarehouse. You must have experience building ETL process using SQL scripts, Stored procedure or SSIS. Experience in Datawarehouse design and setting dimension and fact tables.

I'm looking for a tech support who can help me in my job. Tech Stack: Azure Synapse Power BI SQL Server Pyspark

I would like somebody to help with a two page web application to render some data for a personal project.

Предприятие торгующее множеством китайских безделушек, требуется создание базы данных с отстатками, ценами и автоматическим расчетом прибыли.

Create dynamic table 1. auto add new columns as per the post . 2. insert these records into the database. Database to be used is Mysql Data API :

Developing MSAccess based real time portal for updation by user and customized report generation for admin. It will have separate forms for each user login, dynamic drop down menu.

From scratch 5-8 websites as our products are ready

Looking to switch from using a local shared access file to an online version that can be accessed from anywhere with access control. Questions to be answered: • Would you be able to install a SQL database in something like MySQL on a Windows computer? Or would it require an actual SQL Server? • Approximately how long would it take for the database to be built? • How much would it cost to build it? • Will you support the database if we needed support?

This project is based on sql and details of this project are in uploaded file.

Built a web platform that can help individual investors to track their dividends.

Build data base or basic program for CRUD

I have multiple excel sheets linked with each other to transform the data and get insights. Everything gets stored in the output excel file after transformation which contains roughly 50 data points. I also have sheets that explain the process and the logic behind excel formulas, filters and how they are used. I want to use SSIS for data transformation instead of doing the whole thing on excel to obtain similar results. Also, I only want to do the transformation on 4 data points initially and am mainly interested in the calculations that we can do the calculations in SSIS. This is a simple project requiring simple calculations and maybe a walk in the park for someone who is well versed with SSIS. It also has a potential opportunity for extension once the Proof of Concept (4 data points) ...

I have a flutter app for which I need to develop backend. I am planning to use NodeJS for developing APIs and Stored Procedures for DB SQL queries. If you have good experience and pace are not too occupied in office or other freelance projects, then please bid.

I need someone helping me fixing this issue which is implementing missing instruction and create a branch for it

Hi, developers. I need help for Multi layer BOM Selection in SQL. I have a project related to multi-layer BOM. Each BOM has multiple levels (layers). The columns in the BOM table include final product id, component id, quantity, level, and location id, component category, progress. I'll provide table detail, and rules once you take this project, thank you.

I need someone helping me fixing this issue which is implementing missing instruction and create a branch for it

The Data Analyst is responsible for developing Finance dashboards and reporting solutions, analyzing and modeling large database.

Hi, I need someone to urgently fix my xml feed: I get the following error: there are 10 listings in the XML and they are rejected due to the location, please note that you need to fill at least the first 2 levels of the location.

Need dot net Developer to customize reports and makes some pages on web using SQL database

some data post or receive to my another project in php

I have erp already developed. Based on db structure power bi reports needs to be designed. Around 40-45 reports. Report should reflect in real-time. If any data entry is done in erp, it should be reflected in dashboard.

Have table which have trade list, Create MySql query for TradeVolume Changes 24h/7d/30d/1y Reference daily trade volume changes in %

I need to add the new Users ID that was added to the database in a email. The code is already done, I just need someone to make the SQL that gets the last MAX userID form table USERS and adds + 1, and puts that in the line below $email_message .= "firstname: ".clean_string($_POST['firstname'])."n"; $email_message .= "lastname: ".clean_string($_POST['lastname'])."n"; $email_message .= "username: ".clean_string($_POST['username'])."n"; $email_message .= "email: ".clean_string($_POST['email'])."n"; $email_message .= "street1: ".clean_string($_POST['street1'])."n"; $email_message .= "street2: ".clean_string($_POST['str...

We need to integrate the front end with the backend. We have the ux, what we have to do is integrated stripe and manage the properties and user in the admin panel. This is the workflow Be ready to work

necesito crear con cron job para respaldos de base de datos

Need an sql developer to support my job in error and bug fixing sometimes creating views,procedures and queries as well

We are currently looking for someone that can help us design actionable reporting and dashboards for our subscription-based e-commerce company. Responsibilities will include: Write SQL queries and stored routines to return and manipulate data per business needs Debugging and troubleshooting queries, stored procedures, and data integration solutions Optimize query performance tuning Develop and build analytic reports from conception to publication Connecting our SQL data source to reporting applications such as Power BI to create visual reports that can show us KPIs and Business Drivers, Customer Analytics, and more that effectively communicate trends, patterns, and predictions using relevant data. Collaborating with programmers and organizational leaders to identify opportunities for ...

We need implement automation to the process of developing / mantaining database objects with repository, versioning, CI/CD, etc.

We have several established .NET applications and SSRS Reports. Due to a promotion, we need additional resources to help maintain and develop additional reports and data feeds to BI platform. The Reports are manufacturing/Engineering based using data feeds from 123 Insight and the SDK interface.

I have a mysql databse but i need the data mapped as they are not represented with the same column name

Need to develop a web based dental clinic practice management software...

The website should be as a main tool for a company providing the service of collecting information from members about certain objects they used and their ratings of these objects. Feature to see detailed and cumulative ratings are able for paid memberships only..

CREATE TABLE [dbo].[TRANSPORTSERIALTRACKING]( [PREFIX] [nvarchar](10) NOT NULL, [SERIALNUMBER] [nvarchar](30) NOT NULL, [DENOMID] [int] NOT NULL, [CURRENCYCODE] [nvarchar](30) NOT NULL, [DENOMINATION] [nvarchar](30) NOT NULL, [SERIES] [nvarchar](30) NOT NULL, [NUMERICSERIALNUMBER] [bigint] NULL, [SUFFIX] [nvarchar](10) NULL, [LASTINCASHCENTERID] [int] NOT NULL, [DATEFIRSTIN] [date] NULL, [DATEFIRSTOUT] [date] NULL, [COUNTRETURNS] [int] NOT NULL, [DATELASTIN] [date] NULL, [DATEDESTROYED] [date] NULL, [SORTINGDATEINSEQUENCE] [nvarchar](2000) NULL, [SORTINGSITEINSEQUENCE] [nvarchar](2000) NULL, [SORTINGQUALITYINSEQUENCE] [nvarchar](2000) NULL, [SORTINGMACHINEINSEQUENCE] [nvarchar](2000) NULL, [TRANSPORTFILEIDINSEQUENCE] [nvarchar](2000) NULL, [HEADERCARDINSEQUENCE] [nvarch...

Hi All, I have attached a workbook wherein I have compared Variance of year/quarter/month with any different year/quarter/month. So far I have achieved it with help of Parameter that gives user flexibility to choose amongst the period and then filter values display accordingly. But now I have a requirement to have different filters for each column (Previous and Current) as follows: Therefore, to keep “Select Period” filter, and add “Periods Filter” above each Current and Previous Period columns and name each filter accordingly Column header should update based on which period is being filtered (for previous or current)

See document for details. Short: I would like 1 php page that will have 3 tabs. tab1 -> contains all fixed items like a BAG, SACK, BOX tab2 -> the options -> like a red ball, blue ball, organge ball tab3 -> will contain all options possible.. bag -> blue ball bag -> blue ball + red ball etc

Hello I would like some one to create a snowflake query to get the data in the format as shown in tab 3 in the attached document. The table is present in tab 1 and the requirements are detailed in tab 2 .

Actualmente la empresa se dedica al desarrollo de sistemas ERP a empresas nacionales. Entre los proyectos se encuentran: El desarrollo del sistema interno a la empresa Papiro S.A (empresa líder en el mercado de impresiones digitales). Desarrollo interno del sistema del hotel Patagonia Green. Desarrollo del sistema de información de Mercator S.A. Entre otros. El estilo de trabajo se enmarca en la metodología Ágil. Específicamente se realizan sprints cada 2 semanas donde se revisan los resultados y se vuelve a planear el trabajo. Además actualmente se trabaja mediante una metodología semi-presencial, donde los programadores vienen a la oficina los días que se estimen conveniente. La cultura de trabajo sigue también lo estipul...

Need someone having knowledge of sql, data visualization. Data science expert.

convert xml data and load into database

K zobrazení podrobností se zaregistrujte nebo přihlaste.

THERE ARE FOUR PROJECTS WITH R TWO WITH SQL AND TWO WITH TABLEAU I NEED A SOLUTION FILES OR DETAILS SOLVING TECHNIQUE ON THESE

Hello, I want a website where I can store information. The functions should be as this one

We require a programmer for a large MS Access/SQL Server project for 2-3 months. Please write me, if you are an experinced MS Access and MS SQL Server developer.

The business evaluator provides a blueprint for scaling your business to the next level, and the blueprint will establish your baseline with your peer group and advise you on what you need to do (people and budget) to accelerate to the next level. It is to be used for lead generation and a resource for anyone who needs to evaluate an MSP for Non-Competitive Interest, Development Capital, Ownership disputes, Potential Sale, Retirement Succession Planning, Investment, Scale of Your MSP, or Curiosity A competitive Website: The functionality is currently written in Excel. It needs to utilize a WordPress-enabled SQL currently in an Excel array. We are using WordPress with an Avada-purchased theme. The system is to generate reports based on customer input and retrieves text and data (per...

Create excel based tool which link to SAP and automates data extraction from SAP. Example of requirement: 1) Input data parameters in Excel 2) Basis mentioned data parameters, Excel connects to SAP in backend and downloads report 3) Perform some basic data validation and formatting on the downloaded SAP output

To install SQL Server 2016 in linux VMs Installation in a Private cloud. Installation on NVME drives wil logs and data on separate location Database LB and HA environment essential. Add existing databases to the new instance Good Knowledge on Database replication, Indexing and Log Truncation

Temos plataforma de e-commerce própria e gostaria de integrar o gateway de pagamentos da GetNet. Para integração da nossa API, 0 desenvolvedor terá que se basear na nossa documentação: Obs: Banco de Dados MySQL e código fonte desenvolvido utilizando Visual Studio 2013

App para desarrollar en c# extraer datos de una bd en sql y exportar en formato xml debe hacer preview y envío de datos a una web se da todo el esquema de trabajo para integrar y enviar

App en c# que debe funcionar con una app local para extraer datos de sql convertir en plantilla xml , realizar un preview , modo de aprobación y enviar a un servidor todo el esquema de funcionamiento se da en manual