Closed

SQL SERVER BULK ENTRY QUERY

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

Skills: SQL, Microsoft SQL Server, Database Administration, MySQL, Software Architecture

About the Client:
( 8 reviews ) Dubai, United Arab Emirates

Project ID: #34342840

21 freelancers are bidding on average $41 for this job

(121 Reviews)
7.8
(13 Reviews)
5.5
(45 Reviews)
5.2
ashupathania

Hi , I just read your posting. It sounds like you need an expert in Database development. I have around 10 years of experience in database development and I had worked with reputed clients like Microsoft,Telus,HCL an More

$30 USD in 1 day
(32 Reviews)
5.1
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 u More

$20 USD in 1 day
(29 Reviews)
4.7
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 as More

$20 USD in 2 days
(14 Reviews)
4.2
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, d More

$70 USD in 2 days
(11 Reviews)
4.3
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 More

$10 USD in 1 day
(4 Reviews)
4.3
(24 Reviews)
4.1
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 fu More

$100 USD in 1 day
(11 Reviews)
4.1
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
(3 Reviews)
3.3
(5 Reviews)
3.2
PadmajaKarekar

Hello! I hope you are doing well. I am an experienced database administrator using SQL (14+ Years). I have already read your project description and am very interested in your project. I can help you with your bulk More

$20 USD in 7 days
(2 Reviews)
1.2
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
(0 Reviews)
0.0
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 More

$18 USD in 5 days
(0 Reviews)
0.0
nebojsaivic22

⭐⭐⭐⭐⭐5-Stars Rating for all of my Projects⭐⭐⭐⭐⭐ Hi Dear, I hope you are doing well and safe from COVID-19. I am a ?Professional Full Stack Web Developer? with 6 years of experience. Therefore, I think that I can impl More

$140 USD in 7 days
(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 More

$28 USD in 7 days
(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 More

$40 USD in 7 days
(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 Reviews)
0.0
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 question More

$20 USD in 7 days
(0 Reviews)
0.0