Закрыт

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

Навыки: SQL, SQL-сервер Microsoft, Управление базами данных, MySQL, Архитектура ПО

О клиенте:
( 8 отзыв(-а, -ов) ) Dubai, United Arab Emirates

ID проекта: #34342840

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

(123 отзывов(-а))
7.8
(15 отзывов(-а))
5.5
(46 отзывов(-а))
5.2
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 Больше

$20 USD за 1 день
(29 отзывов(-а))
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 Больше

$20 USD за 2 дней(-я)
(14 отзывов(-а))
4.2
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 Больше

$100 USD за 1 день
(12 отзывов(-а))
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 Больше

$10 USD за 1 день
(4 отзывов(-а))
4.3
(26 отзывов(-а))
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 Больше

$70 USD за 2 дней(-я)
(11 отзывов(-а))
4.3
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 за 1 день
(3 отзывов(-а))
3.3
(5 отзывов(-а))
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 Больше

$20 USD за 7 дней(-я)
(5 отзывов(-а))
2.0
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 за 7 дней(-я)
(0 отзывов(-а))
1.9
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 Больше

$18 USD за 5 дней(-я)
(0 отзывов(-а))
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 Больше

$140 USD за 7 дней(-я)
(0 отзывов(-а))
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 Больше

$28 USD за 7 дней(-я)
(0 отзывов(-а))
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 Больше

$40 USD за 7 дней(-я)
(0 отзывов(-а))
0.0
mdilyas777

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

$30 USD за 7 дней(-я)
(0 отзывов(-а))
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 Больше

$20 USD за 7 дней(-я)
(1 отзыв)
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 a Больше

$20 USD за 7 дней(-я)
(0 отзывов(-а))
0.0