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.

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 Query for Create new master

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/
Go to Top of Page
   

- Advertisement -