Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sureshprpt
Starting Member
33 Posts |
 Posted - 2014-07-07 : 02:20:05
|
Hi All,
I need the sql query to create the item master in the table .In my Item master table only the Itemcode only change and others remain same with avaliable codes.
Please can you query and examples are follows:-
Table
Itemcode Searchtxt UDC1 UDC2 GLCode
covc0123 ancor 0001 0002 RM02 - available CODE
C0VC0124 " " " " - nEW CODE TO UPDATE IN TABLE
Thanks
Thanks & Regards
Suresh |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2014-07-08 : 12:45:16
|
Your question is not clear. Please use this article to help post your question so that we can help you: http://www.sqlservercentral.com/articles/Best+Practices/61537/
Tara Kizer
SQL Server MVP since 2007
http://weblogs.sqlteam.com/tarad/ |
 |
|
|
|
|
|
Query for Create new master