Færdiggjort

T-SQL Script Required

I need a simple T-SQL script created to insert a row between existing rows where the given criteria is met. See attached excel doc showing the before and after requirement. For each vehicle of type 'A10' on a given date and order #, I need an additional row inserted using the same order number and date but I need the Vehicle type to be specified as 'A11'.

Evner: Microsoft SQL Server, SQL, T-SQL (Transact Structures Query Language)

Se mere: sqlcmd, sql create job script, sql scripts examples, transact-sql, run r script from sql server, execute any external script, grant execute any external script, sp_execute_external_script r, perl script retrieve data excel, net sql server table write excel pivot, macro script update database excel, sample perl script read data excel, script required php installer, php script required, script required, ajax script export html excel, php script required install complete, script generate report excel, script php read excel file, perl script fetch datas excel

Om arbejdsgiveren:
( 3 bedømmelser ) Melbourne, Australia

Projekt ID: #17669425

Tildelt til:

Agiletechstudio

Hi, there i read your initial requirements and i have some question regarding to your t-sql [login to view URL] can we discuss it on chat ?

$25 USD på 1 dag
(15 bedømmelser)
4.3

6 freelancere byder i gennemsnit $24 på dette job

paskal77

Hello! I can develop a stored procedure, which you can call from your application and allow you to enter a new row in the place you require Contact by chat Thank you Andrés

$25 USD på 1 dag
(45 bedømmelser)
5.3
ketangodhani10

Hi, I am a full stack .Net Developer and having 4+ years’ experience. -Strong database knowledge: MS-SQL Server, MySQL, Access, Entity Framework. -Extensive knowledge: Azure, C#, VB, ASP.Net, MVC, Win Forms, Web Flere

$20 USD på 1 dag
(2 bedømmelser)
2.8
ganeshrasekar

I can do it .. I need a simple T-SQL script created to insert a row between existing rows where the given criteria is met. See attached excel doc showing the before and after requirement. For each vehicle of type 'A10 Flere

$30 USD på 1 dag
(2 bedømmelser)
2.9
$17 USD in 3 dage
(0 bedømmelser)
0.0
gans4kls87

I have more than 8 years of experience on SQL server (2008/12/14). I had done more than 100 projects . I have team to support any sort of requirements on SQL as well as Advanced Excel (VBA).

$25 USD på 1 dag
(0 bedømmelser)
0.0