SQL SERVER BULK ENTRY QUERY
Budjetti $10-30 USD
Job Description:
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
20 freelanceria on tarjonnut keskimäärin $41 tähän työhön
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 Lisää
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 Lisää
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 Lisää
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 Lisää
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
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 Lisää
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.
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 Lisää
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 Lisää
I have good experience in database administration in technologies like SQLSERVER, mysql and cloud technologies like AWS and AZURE.
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 Lisää
