usually you want to delete data in certain tables, but not "lookup tables".

the script below will delete/truncate every table in foreign key hierarchy order, but you should add to the...

Best (9/27/2007)

---

table in which update has to be done --------------------Table a

table from where update has to be made----------------Table b

table structure of Table a--------------------contactid,lastname,firstname

table structure of table b-------------------leacode,lastname,firstname

table structure of table...

in the ORDER BY section of a statement, you can refer to data by the alias that was assigned to it, isntead of the function. will that help you out?

ie...

What have you tried so far?

This looks a lot like a homework question, so please bear with me;

in order to get information from two tables, you want to use a...

yep your right...select statements don't produce a loggable item, so there's no way to track who reads a table, unless you set up a profile.

select * from sys.messages will give you the error text as well as severity, etc.:

message_id

language_id

severity

is_event_logged

text

isn't this the problem?: @tradeid ahs a single quote, which would stop theprocess, and then all the other varables need doublesingle quotes, like @vcDeptName = ''IF-PM'',

exec sp_executesql N'sp_UpdateProcessedTrades',...

yeah i agree; it's just my knee jerk reaction was "but it's in a TRANSACTION", like that makes up for everything.

if you start a transaction, insert, and then rollback due to a business decision, your identity will increment, but no error is thrown. a missing identity value does not necessarily...

you can use the function USER_ID() and USER_NAME() inside your trigger, and there is a bunch of system functions like APP_NAME and others that might be helpful for auditing/logging. look...

show us the query you have done so far, so we can offer suggestions with your homework; you won't learn if someone just gives you the answer.

can you show us the sql you are currently using?

Update dbo.WipJobAllMat

Set dbo.WipJobAllMat.Bin = dbo.InvWarehouse.DefaultBin

FROM dbo.InvWarehouse

INNER JOIN dbo.WipMaster ON dbo.WipJobAllMat.Job = dbo.WipMaster.Job

Where dbo.InvWarehouse.StockCode = dbo.WipJobAllMat.StockCode

and dbo.WipJobAllMat.Job = dbo.WipMaster.Job

and dbo.WipMaster.Complete <> 'Y'

and dbo.WipMaster.JobClassification = '90'or dbo.WipMaster.JobClassification = '96'

i provided an example when using the convert function; take a look at books on line...

most people suggest using a datestamp like 200709261727 instead of the format you were suggesting;

for...

longtime known issue.

logins on a server are stored in the master database. access to the login is stored in the actual database (select permissions only, db_datareader for example) are inside...