sql server 2008 insert and update statements
$30-250 USD
Paid on delivery
i need some sort of a SQL insert statement to insert rows. i have 2 databases. ATLAS and ADVNET.
the table that i need to insert into is ADVNET.dbo.jnl_itemattribute and this table has 4 columns
-ItemId (PK, uniqueidentifier) this references over to the other database at : [url removed, login to view]
-WebTitle (varchar(max),null)
-WebSEOUrl (varchar(2000),null)
-WebProductPrice(decimal18,8),null)
The table that i need to insert from is [url removed, login to view]
the problem is that i do not have the ItemId in the source table. I only have the ItemNumber, which is in a column in [url removed, login to view]
If i were to run this SQL statement, it would show the cross reference:
select ItemId,itemnumber from item where itemnumber = 'DES 09100'
the source column ItemNumber shows the DES 09100
So either we somehow insert all of the ItemIds into the source table [url removed, login to view] OR you design a SQL statement that can cross reference the ItemNumber to the ItemId and then return that as a value.
also, the source table of ADVNET.dbo.import has many rows. i would like the sql statement to capture all of the rows in ADVNET.dbo.import and insert them into the ADVNET.dbo.jnl_itemattribute, BUT with grabbing the ItemId from ATLAS.dbo.item
Project ID: #7310901
About the project
Awarded to:
Hi. I have the task already done. I can provide you an SQL statement that performs data copying or I can copy the data if you provide for me access to you databases.
11 freelancers are bidding on average $83 for this job
EXPERIENCED DEVELOPER. PLEASE CHECK MY BADGES, PROJECTS AND REVIEWS... JOST NOTE ON MY SQL LEVEL 3 BADGE WHICH MAKES ME ONE OF THE TOP SQL FREELANCERS AROUND
Can u tell me is itemNumber is unique for each item in database? If Item number is unique then we can create item id and save it in table?
I work as a data and analytics key specialist in Singapore. I work in Qlilvoew, Tableau, SQL, Oracle everyday. More than happy to help you with required queries. Very doable in one day.
Hi. I am professional database developer. I can fix for you that referential integrity issue. If you like my offer, feel free to contact me. Thanks
SQL server DBA/MSBI Developer with 4+ years of experience. I can write a query for fixing this issue immediately please check my last review (5 Star)
I work with SQL Server in a international company, I do a lot of process or similar querys that you want
I am USA based. Can get this done within a day. Just need to understand your database tables better.