August 29, 2013 at 2:09 pm
Hi Sean,
The First Query That you Gave Me Helped.
what i want to do is first split the value from the first Table(Units)
and them Afterwards i will need to insert the splitted value to The UASSSEM Table under
ManufacturingCODE Column And Model
Best Regards,
Noel
August 29, 2013 at 2:32 pm
Stylez (8/29/2013)
Hi Sean,The First Query That you Gave Me Helped.
what i want to do is first split the value from the first Table(Units)
and them Afterwards i will need to insert the splitted value to The UASSSEM Table under
ManufacturingCODE Column And Model
Best Regards,
Noel
OK that makes more sense now. Something like this? I think there is another column you want but I don't know for sure.
insert UASSSEM (MFGCODE,model)
select PARSENAME(replace(engine, ' ', '.'), 2), PARSENAME(replace(engine, ' ', '.'), 1)
From Units
Where UnitNumber = '170272'
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
September 4, 2013 at 9:53 am
Much Thanks To All For Helping Me Out on This.
Problem Solved
Best Regards,
Noel
Viewing 3 posts - 16 through 17 (of 17 total)
You must be logged in to reply to this topic. Login to reply