Lukket

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

Færdigheder: SQL, Microsoft SQL Server, Database Administration, MySQL, Software Arkitektur

Om klienten:
( 8 bedømmelser ) Dubai, United Arab Emirates

Projekt ID: #34342840

20 freelancere byder i gennemsnit $41 timen for dette job

(123 bedømmelser)
7.8
(15 bedømmelser)
5.5
(46 bedømmelser)
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 Flere

$20 USD på 1 dag
(29 bedømmelser)
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 Flere

$20 USD in 2 dage
(14 bedømmelser)
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 Flere

$100 USD på 1 dag
(12 bedømmelser)
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 Flere

$10 USD på 1 dag
(4 bedømmelser)
4.3
(26 bedømmelser)
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 Flere

$70 USD in 2 dage
(11 bedømmelser)
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 på 1 dag
(3 bedømmelser)
3.3
(5 bedømmelser)
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 Flere

$20 USD in 7 dage
(5 bedømmelser)
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 in 7 dage
(0 bedømmelser)
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 Flere

$18 USD in 5 dage
(0 bedømmelser)
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 Flere

$140 USD in 7 dage
(0 bedømmelser)
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 Flere

$28 USD in 7 dage
(0 bedømmelser)
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 Flere

$40 USD in 7 dage
(0 bedømmelser)
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 dage
(0 bedømmelser)
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 Flere

$20 USD in 7 dage
(1 bedømmelse)
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 Flere

$20 USD in 7 dage
(0 bedømmelser)
0.0