SQL SERVER BULK ENTRY QUERY

$10-30 USD

Closed

Posted

over 1 year ago

$10-30 USD

Paid on delivery

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] [nvarchar](2000) NULL, [TRANSACTIONIDINSEQUENCE] [nvarchar](2000) NULL, [EMISSION] [nvarchar](60) NULL, [REPORTINGGROUPTYPE] [int] NULL, [NONSEQUENTIALREFERENCE] [nvarchar](255) NULL, [DONEINDICATOR] [int] NOT NULL, CONSTRAINT [PK_BPSSERIALTRACKING] PRIMARY KEY CLUSTERED ( [PREFIX] ASC, [SERIALNUMBER] ASC, [DENOMID] ASC, [CURRENCYCODE] ASC, [DENOMINATION] ASC, [SERIES] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] GO

SQL

Microsoft SQL Server

Database Administration

MySQL

Software Architecture

Project ID: 34342840

About the project

19 proposals

Remote project

Active 2 yrs ago

Looking to make some money?

Email address

Benefits of bidding on Freelancer

Set your budget and timeframe

Get paid for your work

Outline your proposal

It's free to sign up and bid on jobs

19 freelancers are bidding on average $42 USD for this job

@teekayzitsi

Hi In my current Profession -I perfom the DBA and Developer duties in high traffic OLTP environment -Data Mining ,Data Science,Machine Learning -Python programing -data analysis using python and R -Data Scraping using python, -Database development in (Mysql,Postgres,SQlite and SQl) -Automation -Data warehousing on sql,mysql and postgres database (Star Schemas) and Business Intelligence systems development -Data extractions using Talend Open Studio,Python -Data Intergration using WSO2 ,Talend Open Studio -I have rich experienced in Database Administration, Excel -Data visualisation using Power BI,BIRT ,Jasper ,excel and Tableau -SQL server installations I am looking for the clear final requirements docs of your project so that I can start working immediately. If you need to discuss with me for any kind of suggestions or information, please knock me anytime. I am looking forward to hearing from you I can assure that if you work with me once, you will always work with me on these kind of projects and I can deliver quality and superior work at a price we are both comfortable with and within the agreed timeline. Kindly consider my bid.I will do whatever it takes to complete this project and earn a 5 star rating from you as well Kind Regards Takudzwa

$20 USD in 1 day

4.9

(47 reviews)

5.0

@Shakerfawzy

Hi, I can help you I'm Database Administrator with 10+ years of experience in maintenance, security, backup, recovery, designing, coding, testing and supporting solutions in SQL Server environments. Proficient in an assortment of technologies MS SQL Server 2000/2005/2008/2012/2014/2016/2017/2019, SAN Storage and Backup Solutions Thank you for your time and consideration. Best Regards, Shaker

$20 USD in 2 days

5.0

(21 reviews)

4.7

@bizmanas

Hi I have 15 years experience with sql server development, mysql development, postgress development. Programming using python, power bi. I will be able to help you with the project. Please ping me offline to discuss further.

$100 USD in 1 day

4.9

(14 reviews)

4.6

@ashiruddin

I have read your requirement,I am 10 years experienced database developer, designer,administrator,Database Programmer in MS SQL Server , MySQL, ORACLE , I am specialize in database design,analysis, report genration, dashboard creation using SSRS, SSIS, MS Power BI

$70 USD in 2 days

4.9

(14 reviews)

4.4

@freelancepraful

I can help you with sql server bulk insert queries , please ping/connect me now I am available. Please check my reviews and project which I have completed. I can create sql queries for sql server database as per design, let me know when to proceed. I can work on future works for databases also if needed. I will work for cheapest budget within time, budget can be re negotiated again, send the details for the project. Please contact me asap. I have 12+ years of experience in database programming, website designing, powershell scripting and android development. Feel free to message me anytime if you need to discuss this further.

$10 USD in 1 day

5.0

(11 reviews)

4.4

@CourserXu

Hi, there I am proficient in SQL development I have good experience of 7+ years in this field and I have done a few projects similar to yours successfully. I understood your requirements fully, but I have some questions to know clearly in more detail. If you work with me, it is the best choice, and you will get satisfied result. I am available to start work immediately. We can discuss in more detail via private chatting. Best regards.

$20 USD in 7 days

5.0

(5 reviews)

3.8

@ShahrukhNawab

I've been working for a development for 11 years, i am willing to do this job/task, i will finish this before your deadline thanks

$50 USD in 1 day

4.9

(3 reviews)

3.4

@symrizals

Hi, I'm Rizal, a desktop application with 5 years experience using Sql Server and Ms Access databases and I'm new to freelance work, I'm very willing to work with you so I can help complete your project.

$20 USD in 7 days

5.0

(1 review)

2.2

@hamzaabqader

Yo!, I’ve carefully checked your requirements and really interested in this job. I’m full stack node.js developer working at large-scale apps as a lead developer with U.S. and European teams. I’m offering best quality and highest performance at lowest price. I can complete your project on time and your will experience great satisfaction with me. I’m well versed in React/Redux, Angular JS, Node JS, html/css as well as javascript and jquery. I have rich experienced in Database Administration, SQL, Microsoft SQL Server, Software Architecture and MySQL as well as Database Administration, SQL, Microsoft SQL Server, Software Architecture and MySQL For more information about me, please refer to my portfolios. I’m ready to discuss your project and start immediately. Looking forward to hearing you back and discussing all details.. Thanks Hamza

$18 USD in 5 days

0.0

(0 reviews)

0.0

@brij4187ma

I have more than 8 years of experience in SQL Server database modelling, design, development, and Administration. I have worked for database designing and modelling of complex business in an efficient way. I have very good experience in TSql, writing complex scripts, complex stored procedures, functions, triggers etc. I am good with performance tuning which includes Index and its usages, JOINS, dynamic queries, CTE, Temp tables, Table variable, and all its usages.

$28 USD in 7 days

0.0

(0 reviews)

0.0

@sattari61

Experienced, result-oriented, detail-oriented Data Engineer with +10 years of IT industry experience in software development and support of enterprise applications and executing innovative solutions to enhance business productivity primarily in Python, ETL, Data warehouse, Spark, Airflow, GIT, C#, SQL, and Oracle. Also good at Hadoop (HDFS, Hive, Pig, nifi, Kafka, HBase).

$40 USD in 7 days

0.0

(0 reviews)

0.0

@mdilyas777

I have good experience in database administration in technologies like SQLSERVER, mysql and cloud technologies like AWS and AZURE.

$30 USD in 7 days

0.0

(0 reviews)

0.0

@taranalytics

Hi I have experience in writing complex DAX measures, and building Excel models & Power BI dashboards from scratch, and also making changes to the existing reports. I am quick at understanding the business context and Problem-solving. The pricing and #of days are PLACEHOLDERS, we can discuss more on this in the chat. Please find my details below. I have ~9 years of experience in Business Analytics and Data Architecture. I have expertise in Power BI, and designed and built multiple executive-level Power BI dashboards for clients across the Retail, Food & Beverage, Entertainment, and Fitness industries. Expertise in building end-to-end BI Infrastructure across industries including developing Data Models, Data Warehouses, and creating visualizations using SQL server, Azure, MSBI stack (SSIS, SSRS & SSAS), and Power BI. Expertise in Customer Analytics, Sales Analytics, Pricing, Sales & Operations Planning, and Digital Analytics domains across Retail, F&B, Entertainment, Fitness, Health Care, Textile, and Manufacturing industries

$20 USD in 7 days