Fermé

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

Compétences : SQL, Serveur SQL Microsoft, Administration de Bases de données, MySQL, Architecture Logicielle

Concernant le client :
( 8 commentaires ) Dubai, United Arab Emirates

Nº du projet : #34342840

20 freelances font une offre moyenne de 41 $ pour ce travail

(123 Commentaires)
7.8
(15 Commentaires)
5.5
(46 Commentaires)
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 Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(29 Commentaires)
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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(14 Commentaires)
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 Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(12 Commentaires)
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 Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(4 Commentaires)
4.3
(26 Commentaires)
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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(11 Commentaires)
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

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(3 Commentaires)
3.3
(5 Commentaires)
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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(5 Commentaires)
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.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(0 Commentaires)
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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 5 jours
(0 Commentaires)
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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(0 Commentaires)
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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(0 Commentaires)
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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(0 Commentaires)
0.0
mdilyas777

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(0 Commentaires)
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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(1 Évaluation)
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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(0 Commentaires)
0.0