Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Trigger resulting in NULL value
Message
From
11/07/2013 15:48:10
 
General information
Forum:
Microsoft SQL Server
Category:
Stored procedures, Triggers, UDFs
Environment versions
SQL Server:
SQL Server 6.5 and older
Application:
Web
Miscellaneous
Thread ID:
01578216
Message ID:
01578226
Views:
36
How would I convert this to using your suggested syntax:
	UPDATE dbo.Items
			SET Items.iqtyonhand = Items.iqtyonhand + Deleted.trn_qty - Inserted.trn_qty
		FROM dbo.Items
			INNER JOIN Inserted ON Items.iItemid = Inserted.trn_itmfk
			INNER JOIN Deleted ON Items.iItemID = Deleted.trn_itmfk
		WHERE iItemTypId = '43'
Frank.

Frank Cazabon
Samaan Systems Ltd.
www.samaansystems.com
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform