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
 General SQL Server Forums
 New to SQL Server Programming
 updating the SQL data

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2006-09-12 : 18:32:18
skumar writes "Hi guys,

i'm a newbie in database and i need some ideas for the below mentioned
problem.

i'm creating sql table from a txt file using DTS package, now once the table
gets created, i need to multiple some revenue accounts with xyz number and
expense accounts with abc number.

i'm thinking more towards the line of writing a store procedure but don't
have any experience in it.

PLease guide me in the right direction, also if a good book could be refered
for future; which will help me query language and this kind of issues, that
will be GREAT!!

Thanx in advance"

Luis Martin
Yak Posting Veteran

54 Posts

Posted - 2006-09-12 : 18:34:52
What do you want to update?
One table?. More?
You have to tell us a litle more, please.
Go to Top of Page

Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)

7020 Posts

Posted - 2006-09-12 : 19:13:17
Tou can read the SQL reference in SQL Server Books Online.

SQL Server 2000 Books Online
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/startsql/portal_7ap1.asp

SQL Server 2005 Books Online
http://msdn2.microsoft.com/en-us/library/ms130214.aspx


CODO ERGO SUM
Go to Top of Page
   

- Advertisement -