Devam Ediyor

Microsoft SQL T-SQL coding required

Job description – create an SQL T-SQL procedure for updating MicroSoft SQL table

refer to [url removed, login to view] (attached & in links) for detail

I work in a proprietary environment called OpenInsight ([url removed, login to view])

• The data structures are based on special characters with which fields are delimited (details in the attached links to files).

• We refer to a piece of data by its field position within the record.

• The attached file [url removed, login to view] is the raw format of the data

• The attached file [url removed, login to view] is its hex equivalence

• The attached file [url removed, login to view] is how this record looks when I view it through our editor. You can see each field on its own line.

Ideally please show me an example that you can write an SQL procedure, as I require a professional.

This is one sample of my requirements, to which I shall have many more conversions if I can get the code to work.

the links to my additional information are :

[url removed, login to view]

[url removed, login to view]

[url removed, login to view]

[url removed, login to view]

[url removed, login to view]

If you don't understand the requirement, please ask for more detail.

I will be timing the conversion against some large files, so please code optimally for the environment

I will pay on completion of the task

Beceriler: Microsoft, Yazılım Mimarisi, SQL

Daha fazlasını gör: when you don t get the job, sql pdf files, sql pdf file, sql data conversion, sql code pdf, line coding, how to get coding job, how to get coding, how to get an editor job, data structures through c, data structures example, data conversion sql, t-sql with, t-sql in, microsoft professional, microsoft links, editor job description, microsoft com, toshiba, t-sql;, sql microsoft, pdf files conversions, amazonaws, sql view table, task timing

İşveren Hakkında:
( 4 değerlendirme ) PARRAMATTA, Australia

Proje NO: #6534459

Bu iş için 11 freelancer ortalamada $196 teklif veriyor


Hi, I have 8.5 years experience in SQL Server 2005|2008|2008R2|2012 and involve in designing databases, Indexing Strategies, table partitioning, writing Stored Procedures, Triggers, functions and views. I have ex Daha Fazla

in %bids___i_period_sub_35% gün içinde277%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(30 Değerlendirme)

In the update statements mentioned in the doc, I could not find the where conditions. Also is the entire process an attempt to reduce the network bandwidth? Are you open to alternate solutions?

in %bids___i_period_sub_35% gün içinde315%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(15 Değerlendirme)

Please chat with me and I will show the work and complex SP which i have done till now. Skype id : jami.mech.005

in %bids___i_period_sub_35% gün içinde177%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(14 Değerlendirme)

Hi, I need more details on this. Can you ping me so that we can discuss on this. I am an individual freelance, having more than 10yrs of exp in developing applications, window & web based, using .Net (C#.Net, Asp Daha Fazla

in %bids___i_period_sub_35% gün içinde200%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(3 Değerlendirme)

Hi, sir. I'm interested in your job. I'm new on freelancer, but I've rich experiences, I can do this perfectly. If you give me the chance to do this, I'll do my best and you will be satisfy. I hope to discuss more Daha Fazla

in %bids___i_period_sub_35% gün içinde264%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(3 Değerlendirme)

I have bachelor and master degrees in IT. My Primary skills include Java, Python, VB/.NET, Delphi, and PHP. Also database skills include MS Access, MySQL, and Oracle. My Other skills include server and network administ Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% AUD
(9 Değerlendirme)

sir, as you know that we are very new in but we are very sure that we can fulfill your need. give us this opportunity.

in %bids___i_period_sub_35% gün içinde222%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)

I have much experience on sql. I worked with Oracle and MSSQL for a telecommunication enterprise and a gubernamental department. I have interacted with many stored procedures, jobs and sql scripts (CRUD).

in %bids___i_period_sub_35% gün içinde155%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)

Hi, I can develop the required stored procedures one for the import of data and other for the export of data. propose the following for the import of data: -- take:binary data, primary key of the row if this is no Daha Fazla

in %bids___i_period_sub_35% gün içinde250%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)

For what I understand, what you need is a procedure to just parse the bin file and return the information as a simple query. To solve this i'll use the varbinary data type to stored this information. Use a table (or Daha Fazla

in %bids___i_period_sub_35% gün içinde45%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)

Aucune proposition n'a encore été fournie.

in %bids___i_period_sub_35% gün içinde100%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(1 Yorum)

In my understanding, the requirement for this project is to parse large records and update to the columns in a SQL Server table ([dbo].[rtc]) in order and aligned to the column Id. Now, the question is, How are we goi Daha Fazla

in %bids___i_period_sub_35% gün içinde155%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)