Query for Create new master - SQL Server Forums

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/

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources