API tools faq
paste
Guest User

Untitled

a guest
Feb 18th, 2018
71
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 65.94 KB | None | 0 0
raw download clone embed print report
  1. USE [RF_WORLD_NOVUS]
  2. GO
  3. /****** Object: Trigger [dbo].[checkUniqueId] Script Date: 09/21/2010 10:59:01 ******/
  4. SET ANSI_NULLS ON
  5. GO
  6. SET QUOTED_IDENTIFIER ON
  7. GO
  8. -- =============================================
  9. -- Author:
  10. -- Create date:
  11. -- Description:
  12. -- =============================================
  13. ALTER TRIGGER [dbo].[checkUniqueId]
  14. ON [dbo].[tbl_inven]
  15. FOR UPDATE
  16. AS
  17. BEGIN
  18. -- SET NOCOUNT ON added to prevent extra result sets from
  19. -- interfering with SELECT statements.
  20. SET NOCOUNT ON;
  21.  
  22. -- Insert statements for trigger here
  23. declare @duped smallint;
  24. declare @s_value bigint;
  25. declare @k_value int;
  26. declare @serial int;
  27. declare @error int;
  28.  
  29. declare @ownerSerial int;
  30. declare @ownerSValue int;
  31. declare @ownerSColumn varchar(10);
  32.  
  33. if update(s0)
  34. begin
  35. SELECT @serial = serial, @k_value = k0, @s_value = s0 FROM Inserted
  36.  
  37. if @s_value > 0
  38. begin
  39. SELECT @ownerSerial = serial, @ownerSColumn = s_column FROM ItemLogs WHERE s_value = @s_value
  40. if @ownerSerial > 0
  41. begin
  42. delete from ItemLogs WHERE s_value = @s_value
  43. UPDATE tbl_inven SET @ownerSColumn = '-1' WHERE Serial = @ownerSerial
  44.  
  45. end
  46. insert into ItemLogs (serial, k_value, s_value, s_column) VALUES(@serial, @k_value, @s_value, 'K0')
  47.  
  48. set @error = @@ERROR
  49. if @error <> 0
  50. begin
  51. RAISERROR('>>>POSSIBLE DUPLICATE ITEM<<< ',10,1)
  52. ROLLBACK TRAN
  53. end
  54. end
  55. end
  56.  
  57. if update(k0)
  58. begin
  59. SELECT @k_value = k0, @serial = serial FROM Inserted
  60. if @k_value < 0
  61. begin
  62. delete from ItemLogs WHERE s_column = 'K0' AND serial = @serial
  63. end
  64. end
  65.  
  66. if update(s1)
  67. begin
  68. SELECT @serial = serial, @k_value = k1, @s_value = s1 FROM Inserted
  69.  
  70. if @s_value > 0
  71. begin
  72. SELECT @ownerSerial = serial, @ownerSColumn = s_column FROM ItemLogs WHERE s_value = @s_value
  73. if @ownerSerial > 0
  74. begin
  75. delete from ItemLogs WHERE s_value = @s_value
  76. UPDATE tbl_inven SET @ownerSColumn = '-1' WHERE Serial = @ownerSerial
  77.  
  78. end
  79. insert into ItemLogs (serial, k_value, s_value, s_column) VALUES(@serial, @k_value, @s_value, 'K1')
  80.  
  81. set @error = @@ERROR
  82. if @error <> 0
  83. begin
  84. RAISERROR('>>>POSSIBLE DUPLICATE ITEM<<< ',10,1)
  85. ROLLBACK TRAN
  86. end
  87. end
  88. end
  89.  
  90. if update(k1)
  91. begin
  92. SELECT @k_value = k1, @serial = serial FROM Inserted
  93. if @k_value < 0
  94. begin
  95. delete from ItemLogs WHERE s_column = 'K1' AND serial = @serial
  96. end
  97. end
  98.  
  99. if update(s2)
  100. begin
  101. SELECT @serial = serial, @k_value = k2, @s_value = s2 FROM Inserted
  102.  
  103. if @s_value > 0
  104. begin
  105. SELECT @ownerSerial = serial, @ownerSColumn = s_column FROM ItemLogs WHERE s_value = @s_value
  106. if @ownerSerial > 0
  107. begin
  108. delete from ItemLogs WHERE s_value = @s_value
  109. UPDATE tbl_inven SET @ownerSColumn = '-1' WHERE Serial = @ownerSerial
  110.  
  111. end
  112. insert into ItemLogs (serial, k_value, s_value, s_column) VALUES(@serial, @k_value, @s_value, 'K2')
  113.  
  114. set @error = @@ERROR
  115. if @error <> 0
  116. begin
  117. RAISERROR('>>>POSSIBLE DUPLICATE ITEM<<< ',10,1)
  118. ROLLBACK TRAN
  119. end
  120. end
  121. end
  122.  
  123. if update(k2)
  124. begin
  125. SELECT @k_value = k2, @serial = serial FROM Inserted
  126. if @k_value < 0
  127. begin
  128. delete from ItemLogs WHERE s_column = 'K2' AND serial = @serial
  129. end
  130. end
  131.  
  132. if update(s3)
  133. begin
  134. SELECT @serial = serial, @k_value = k3, @s_value = s3 FROM Inserted
  135.  
  136. if @s_value > 0
  137. begin
  138. SELECT @ownerSerial = serial, @ownerSColumn = s_column FROM ItemLogs WHERE s_value = @s_value
  139. if @ownerSerial > 0
  140. begin
  141. delete from ItemLogs WHERE s_value = @s_value
  142. UPDATE tbl_inven SET @ownerSColumn = '-1' WHERE Serial = @ownerSerial
  143.  
  144. end
  145. insert into ItemLogs (serial, k_value, s_value, s_column) VALUES(@serial, @k_value, @s_value, 'K3')
  146.  
  147. set @error = @@ERROR
  148. if @error <> 0
  149. begin
  150. RAISERROR('>>>POSSIBLE DUPLICATE ITEM<<< ',10,1)
  151. ROLLBACK TRAN
  152. end
  153. end
  154. end
  155.  
  156. if update(k3)
  157. begin
  158. SELECT @k_value = k3, @serial = serial FROM Inserted
  159. if @k_value < 0
  160. begin
  161. delete from ItemLogs WHERE s_column = 'K3' AND serial = @serial
  162. end
  163. end
  164.  
  165. if update(s4)
  166. begin
  167. SELECT @serial = serial, @k_value = k4, @s_value = s4 FROM Inserted
  168.  
  169. if @s_value > 0
  170. begin
  171. SELECT @ownerSerial = serial, @ownerSColumn = s_column FROM ItemLogs WHERE s_value = @s_value
  172. if @ownerSerial > 0
  173. begin
  174. delete from ItemLogs WHERE s_value = @s_value
  175. UPDATE tbl_inven SET @ownerSColumn = '-1' WHERE Serial = @ownerSerial
  176.  
  177. end
  178. insert into ItemLogs (serial, k_value, s_value, s_column) VALUES(@serial, @k_value, @s_value, 'K4')
  179.  
  180. set @error = @@ERROR
  181. if @error <> 0
  182. begin
  183. RAISERROR('>>>POSSIBLE DUPLICATE ITEM<<< ',10,1)
  184. ROLLBACK TRAN
  185. end
  186. end
  187. end
  188.  
  189. if update(k4)
  190. begin
  191. SELECT @k_value = k4, @serial = serial FROM Inserted
  192. if @k_value < 0
  193. begin
  194. delete from ItemLogs WHERE s_column = 'K4' AND serial = @serial
  195. end
  196. end
  197.  
  198. if update(s5)
  199. begin
  200. SELECT @serial = serial, @k_value = k5, @s_value = s5 FROM Inserted
  201.  
  202. if @s_value > 0
  203. begin
  204. SELECT @ownerSerial = serial, @ownerSColumn = s_column FROM ItemLogs WHERE s_value = @s_value
  205. if @ownerSerial > 0
  206. begin
  207. delete from ItemLogs WHERE s_value = @s_value
  208. UPDATE tbl_inven SET @ownerSColumn = '-1' WHERE Serial = @ownerSerial
  209.  
  210. end
  211. insert into ItemLogs (serial, k_value, s_value, s_column) VALUES(@serial, @k_value, @s_value, 'K5')
  212.  
  213. set @error = @@ERROR
  214. if @error <> 0
  215. begin
  216. RAISERROR('>>>POSSIBLE DUPLICATE ITEM<<< ',10,1)
  217. ROLLBACK TRAN
  218. end
  219. end
  220. end
  221.  
  222. if update(k5)
  223. begin
  224. SELECT @k_value = k5, @serial = serial FROM Inserted
  225. if @k_value < 0
  226. begin
  227. delete from ItemLogs WHERE s_column = 'K5' AND serial = @serial
  228. end
  229. end
  230.  
  231. if update(s6)
  232. begin
  233. SELECT @serial = serial, @k_value = k6, @s_value = s6 FROM Inserted
  234.  
  235. if @s_value > 0
  236. begin
  237. SELECT @ownerSerial = serial, @ownerSColumn = s_column FROM ItemLogs WHERE s_value = @s_value
  238. if @ownerSerial > 0
  239. begin
  240. delete from ItemLogs WHERE s_value = @s_value
  241. UPDATE tbl_inven SET @ownerSColumn = '-1' WHERE Serial = @ownerSerial
  242.  
  243. end
  244. insert into ItemLogs (serial, k_value, s_value, s_column) VALUES(@serial, @k_value, @s_value, 'K6')
  245.  
  246. set @error = @@ERROR
  247. if @error <> 0
  248. begin
  249. RAISERROR('>>>POSSIBLE DUPLICATE ITEM<<< ',10,1)
  250. ROLLBACK TRAN
  251. end
  252. end
  253. end
  254.  
  255. if update(k6)
  256. begin
  257. SELECT @k_value = k6, @serial = serial FROM Inserted
  258. if @k_value < 0
  259. begin
  260. delete from ItemLogs WHERE s_column = 'K6' AND serial = @serial
  261. end
  262. end
  263.  
  264. if update(s7)
  265. begin
  266. SELECT @serial = serial, @k_value = k7, @s_value = s7 FROM Inserted
  267.  
  268. if @s_value > 0
  269. begin
  270. SELECT @ownerSerial = serial, @ownerSColumn = s_column FROM ItemLogs WHERE s_value = @s_value
  271. if @ownerSerial > 0
  272. begin
  273. delete from ItemLogs WHERE s_value = @s_value
  274. UPDATE tbl_inven SET @ownerSColumn = '-1' WHERE Serial = @ownerSerial
  275.  
  276. end
  277. insert into ItemLogs (serial, k_value, s_value, s_column) VALUES(@serial, @k_value, @s_value, 'K7')
  278.  
  279. set @error = @@ERROR
  280. if @error <> 0
  281. begin
  282. RAISERROR('>>>POSSIBLE DUPLICATE ITEM<<< ',10,1)
  283. ROLLBACK TRAN
  284. end
  285. end
  286. end
  287.  
  288. if update(k7)
  289. begin
  290. SELECT @k_value = k7, @serial = serial FROM Inserted
  291. if @k_value < 0
  292. begin
  293. delete from ItemLogs WHERE s_column = 'K7' AND serial = @serial
  294. end
  295. end
  296.  
  297. if update(s8)
  298. begin
  299. SELECT @serial = serial, @k_value = k8, @s_value = s8 FROM Inserted
  300.  
  301. if @s_value > 0
  302. begin
  303. SELECT @ownerSerial = serial, @ownerSColumn = s_column FROM ItemLogs WHERE s_value = @s_value
  304. if @ownerSerial > 0
  305. begin
  306. delete from ItemLogs WHERE s_value = @s_value
  307. UPDATE tbl_inven SET @ownerSColumn = '-1' WHERE Serial = @ownerSerial
  308.  
  309. end
  310. insert into ItemLogs (serial, k_value, s_value, s_column) VALUES(@serial, @k_value, @s_value, 'K8')
  311.  
  312. set @error = @@ERROR
  313. if @error <> 0
  314. begin
  315. RAISERROR('>>>POSSIBLE DUPLICATE ITEM<<< ',10,1)
  316. ROLLBACK TRAN
  317. end
  318. end
  319. end
  320.  
  321. if update(k8)
  322. begin
  323. SELECT @k_value = k8, @serial = serial FROM Inserted
  324. if @k_value < 0
  325. begin
  326. delete from ItemLogs WHERE s_column = 'K8' AND serial = @serial
  327. end
  328. end
  329.  
  330. if update(s9)
  331. begin
  332. SELECT @serial = serial, @k_value = k9, @s_value = s9 FROM Inserted
  333.  
  334. if @s_value > 0
  335. begin
  336. SELECT @ownerSerial = serial, @ownerSColumn = s_column FROM ItemLogs WHERE s_value = @s_value
  337. if @ownerSerial > 0
  338. begin
  339. delete from ItemLogs WHERE s_value = @s_value
  340. UPDATE tbl_inven SET @ownerSColumn = '-1' WHERE Serial = @ownerSerial
  341.  
  342. end
  343. insert into ItemLogs (serial, k_value, s_value, s_column) VALUES(@serial, @k_value, @s_value, 'K9')
  344.  
  345. set @error = @@ERROR
  346. if @error <> 0
  347. begin
  348. RAISERROR('>>>POSSIBLE DUPLICATE ITEM<<< ',10,1)
  349. ROLLBACK TRAN
  350. end
  351. end
  352. end
  353.  
  354. if update(k9)
  355. begin
  356. SELECT @k_value = k9, @serial = serial FROM Inserted
  357. if @k_value < 0
  358. begin
  359. delete from ItemLogs WHERE s_column = 'K9' AND serial = @serial
  360. end
  361. end
  362.  
  363. if update(s10)
  364. begin
  365. SELECT @serial = serial, @k_value = k10, @s_value = s10 FROM Inserted
  366.  
  367. if @s_value > 0
  368. begin
  369. SELECT @ownerSerial = serial, @ownerSColumn = s_column FROM ItemLogs WHERE s_value = @s_value
  370. if @ownerSerial > 0
  371. begin
  372. delete from ItemLogs WHERE s_value = @s_value
  373. UPDATE tbl_inven SET @ownerSColumn = '-1' WHERE Serial = @ownerSerial
  374.  
  375. end
  376. insert into ItemLogs (serial, k_value, s_value, s_column) VALUES(@serial, @k_value, @s_value, 'K10')
  377.  
  378. set @error = @@ERROR
  379. if @error <> 0
  380. begin
  381. RAISERROR('>>>POSSIBLE DUPLICATE ITEM<<< ',10,1)
  382. ROLLBACK TRAN
  383. end
  384. end
  385. end
  386.  
  387. if update(k10)
  388. begin
  389. SELECT @k_value = k10, @serial = serial FROM Inserted
  390. if @k_value < 0
  391. begin
  392. delete from ItemLogs WHERE s_column = 'K10' AND serial = @serial
  393. end
  394. end
  395.  
  396. if update(s11)
  397. begin
  398. SELECT @serial = serial, @k_value = k11, @s_value = s11 FROM Inserted
  399.  
  400. if @s_value > 0
  401. begin
  402. SELECT @ownerSerial = serial, @ownerSColumn = s_column FROM ItemLogs WHERE s_value = @s_value
  403. if @ownerSerial > 0
  404. begin
  405. delete from ItemLogs WHERE s_value = @s_value
  406. UPDATE tbl_inven SET @ownerSColumn = '-1' WHERE Serial = @ownerSerial
  407.  
  408. end
  409. insert into ItemLogs (serial, k_value, s_value, s_column) VALUES(@serial, @k_value, @s_value, 'K11')
  410.  
  411. set @error = @@ERROR
  412. if @error <> 0
  413. begin
  414. RAISERROR('>>>POSSIBLE DUPLICATE ITEM<<< ',10,1)
  415. ROLLBACK TRAN
  416. end
  417. end
  418. end
  419.  
  420. if update(k11)
  421. begin
  422. SELECT @k_value = k11, @serial = serial FROM Inserted
  423. if @k_value < 0
  424. begin
  425. delete from ItemLogs WHERE s_column = 'K11' AND serial = @serial
  426. end
  427. end
  428.  
  429. if update(s12)
  430. begin
  431. SELECT @serial = serial, @k_value = k12, @s_value = s12 FROM Inserted
  432.  
  433. if @s_value > 0
  434. begin
  435. SELECT @ownerSerial = serial, @ownerSColumn = s_column FROM ItemLogs WHERE s_value = @s_value
  436. if @ownerSerial > 0
  437. begin
  438. delete from ItemLogs WHERE s_value = @s_value
  439. UPDATE tbl_inven SET @ownerSColumn = '-1' WHERE Serial = @ownerSerial
  440.  
  441. end
  442. insert into ItemLogs (serial, k_value, s_value, s_column) VALUES(@serial, @k_value, @s_value, 'K12')
  443.  
  444. set @error = @@ERROR
  445. if @error <> 0
  446. begin
  447. RAISERROR('>>>POSSIBLE DUPLICATE ITEM<<< ',10,1)
  448. ROLLBACK TRAN
  449. end
  450. end
  451. end
  452.  
  453. if update(k12)
  454. begin
  455. SELECT @k_value = k12, @serial = serial FROM Inserted
  456. if @k_value < 0
  457. begin
  458. delete from ItemLogs WHERE s_column = 'K12' AND serial = @serial
  459. end
  460. end
  461.  
  462. if update(s13)
  463. begin
  464. SELECT @serial = serial, @k_value = k13, @s_value = s13 FROM Inserted
  465.  
  466. if @s_value > 0
  467. begin
  468. SELECT @ownerSerial = serial, @ownerSColumn = s_column FROM ItemLogs WHERE s_value = @s_value
  469. if @ownerSerial > 0
  470. begin
  471. delete from ItemLogs WHERE s_value = @s_value
  472. UPDATE tbl_inven SET @ownerSColumn = '-1' WHERE Serial = @ownerSerial
  473.  
  474. end
  475. insert into ItemLogs (serial, k_value, s_value, s_column) VALUES(@serial, @k_value, @s_value, 'K13')
  476.  
  477. set @error = @@ERROR
  478. if @error <> 0
  479. begin
  480. RAISERROR('>>>POSSIBLE DUPLICATE ITEM<<< ',10,1)
  481. ROLLBACK TRAN
  482. end
  483. end
  484. end
  485.  
  486. if update(k13)
  487. begin
  488. SELECT @k_value = k13, @serial = serial FROM Inserted
  489. if @k_value < 0
  490. begin
  491. delete from ItemLogs WHERE s_column = 'K13' AND serial = @serial
  492. end
  493. end
  494.  
  495. if update(s14)
  496. begin
  497. SELECT @serial = serial, @k_value = k14, @s_value = s14 FROM Inserted
  498.  
  499. if @s_value > 0
  500. begin
  501. SELECT @ownerSerial = serial, @ownerSColumn = s_column FROM ItemLogs WHERE s_value = @s_value
  502. if @ownerSerial > 0
  503. begin
  504. delete from ItemLogs WHERE s_value = @s_value
  505. UPDATE tbl_inven SET @ownerSColumn = '-1' WHERE Serial = @ownerSerial
  506.  
  507. end
  508. insert into ItemLogs (serial, k_value, s_value, s_column) VALUES(@serial, @k_value, @s_value, 'K14')
  509.  
  510. set @error = @@ERROR
  511. if @error <> 0
  512. begin
  513. RAISERROR('>>>POSSIBLE DUPLICATE ITEM<<< ',10,1)
  514. ROLLBACK TRAN
  515. end
  516. end
  517. end
  518.  
  519. if update(k14)
  520. begin
  521. SELECT @k_value = k14, @serial = serial FROM Inserted
  522. if @k_value < 0
  523. begin
  524. delete from ItemLogs WHERE s_column = 'K14' AND serial = @serial
  525. end
  526. end
  527.  
  528. if update(s15)
  529. begin
  530. SELECT @serial = serial, @k_value = k15, @s_value = s15 FROM Inserted
  531.  
  532. if @s_value > 0
  533. begin
  534. SELECT @ownerSerial = serial, @ownerSColumn = s_column FROM ItemLogs WHERE s_value = @s_value
  535. if @ownerSerial > 0
  536. begin
  537. delete from ItemLogs WHERE s_value = @s_value
  538. UPDATE tbl_inven SET @ownerSColumn = '-1' WHERE Serial = @ownerSerial
  539.  
  540. end
  541. insert into ItemLogs (serial, k_value, s_value, s_column) VALUES(@serial, @k_value, @s_value, 'K15')
  542.  
  543. set @error = @@ERROR
  544. if @error <> 0
  545. begin
  546. RAISERROR('>>>POSSIBLE DUPLICATE ITEM<<< ',10,1)
  547. ROLLBACK TRAN
  548. end
  549. end
  550. end
  551.  
  552. if update(k15)
  553. begin
  554. SELECT @k_value = k15, @serial = serial FROM Inserted
  555. if @k_value < 0
  556. begin
  557. delete from ItemLogs WHERE s_column = 'K15' AND serial = @serial
  558. end
  559. end
  560.  
  561. if update(s16)
  562. begin
  563. SELECT @serial = serial, @k_value = k16, @s_value = s16 FROM Inserted
  564.  
  565. if @s_value > 0
  566. begin
  567. SELECT @ownerSerial = serial, @ownerSColumn = s_column FROM ItemLogs WHERE s_value = @s_value
  568. if @ownerSerial > 0
  569. begin
  570. delete from ItemLogs WHERE s_value = @s_value
  571. UPDATE tbl_inven SET @ownerSColumn = '-1' WHERE Serial = @ownerSerial
  572.  
  573. end
  574. insert into ItemLogs (serial, k_value, s_value, s_column) VALUES(@serial, @k_value, @s_value, 'K16')
  575.  
  576. set @error = @@ERROR
  577. if @error <> 0
  578. begin
  579. RAISERROR('>>>POSSIBLE DUPLICATE ITEM<<< ',10,1)
  580. ROLLBACK TRAN
  581. end
  582. end
  583. end
  584.  
  585. if update(k16)
  586. begin
  587. SELECT @k_value = k16, @serial = serial FROM Inserted
  588. if @k_value < 0
  589. begin
  590. delete from ItemLogs WHERE s_column = 'K16' AND serial = @serial
  591. end
  592. end
  593.  
  594. if update(s17)
  595. begin
  596. SELECT @serial = serial, @k_value = k17, @s_value = s17 FROM Inserted
  597.  
  598. if @s_value > 0
  599. begin
  600. SELECT @ownerSerial = serial, @ownerSColumn = s_column FROM ItemLogs WHERE s_value = @s_value
  601. if @ownerSerial > 0
  602. begin
  603. delete from ItemLogs WHERE s_value = @s_value
  604. UPDATE tbl_inven SET @ownerSColumn = '-1' WHERE Serial = @ownerSerial
  605.  
  606. end
  607. insert into ItemLogs (serial, k_value, s_value, s_column) VALUES(@serial, @k_value, @s_value, 'K17')
  608.  
  609. set @error = @@ERROR
  610. if @error <> 0
  611. begin
  612. RAISERROR('>>>POSSIBLE DUPLICATE ITEM<<< ',10,1)
  613. ROLLBACK TRAN
  614. end
  615. end
  616. end
  617.  
  618. if update(k17)
  619. begin
  620. SELECT @k_value = k17, @serial = serial FROM Inserted
  621. if @k_value < 0
  622. begin
  623. delete from ItemLogs WHERE s_column = 'K17' AND serial = @serial
  624. end
  625. end
  626.  
  627. if update(s18)
  628. begin
  629. SELECT @serial = serial, @k_value = k18, @s_value = s18 FROM Inserted
  630.  
  631. if @s_value > 0
  632. begin
  633. SELECT @ownerSerial = serial, @ownerSColumn = s_column FROM ItemLogs WHERE s_value = @s_value
  634. if @ownerSerial > 0
  635. begin
  636. delete from ItemLogs WHERE s_value = @s_value
  637. UPDATE tbl_inven SET @ownerSColumn = '-1' WHERE Serial = @ownerSerial
  638.  
  639. end
  640. insert into ItemLogs (serial, k_value, s_value, s_column) VALUES(@serial, @k_value, @s_value, 'K18')
  641.  
  642. set @error = @@ERROR
  643. if @error <> 0
  644. begin
  645. RAISERROR('>>>POSSIBLE DUPLICATE ITEM<<< ',10,1)
  646. ROLLBACK TRAN
  647. end
  648. end
  649. end
  650.  
  651. if update(k18)
  652. begin
  653. SELECT @k_value = k18, @serial = serial FROM Inserted
  654. if @k_value < 0
  655. begin
  656. delete from ItemLogs WHERE s_column = 'K18' AND serial = @serial
  657. end
  658. end
  659.  
  660. if update(s19)
  661. begin
  662. SELECT @serial = serial, @k_value = k19, @s_value = s19 FROM Inserted
  663.  
  664. if @s_value > 0
  665. begin
  666. SELECT @ownerSerial = serial, @ownerSColumn = s_column FROM ItemLogs WHERE s_value = @s_value
  667. if @ownerSerial > 0
  668. begin
  669. delete from ItemLogs WHERE s_value = @s_value
  670. UPDATE tbl_inven SET @ownerSColumn = '-1' WHERE Serial = @ownerSerial
  671.  
  672. end
  673. insert into ItemLogs (serial, k_value, s_value, s_column) VALUES(@serial, @k_value, @s_value, 'K19')
  674.  
  675. set @error = @@ERROR
  676. if @error <> 0
  677. begin
  678. RAISERROR('>>>POSSIBLE DUPLICATE ITEM<<< ',10,1)
  679. ROLLBACK TRAN
  680. end
  681. end
  682. end
  683.  
  684. if update(k19)
  685. begin
  686. SELECT @k_value = k19, @serial = serial FROM Inserted
  687. if @k_value < 0
  688. begin
  689. delete from ItemLogs WHERE s_column = 'K19' AND serial = @serial
  690. end
  691. end
  692.  
  693. if update(s20)
  694. begin
  695. SELECT @serial = serial, @k_value = k20, @s_value = s20 FROM Inserted
  696.  
  697. if @s_value > 0
  698. begin
  699. SELECT @ownerSerial = serial, @ownerSColumn = s_column FROM ItemLogs WHERE s_value = @s_value
  700. if @ownerSerial > 0
  701. begin
  702. delete from ItemLogs WHERE s_value = @s_value
  703. UPDATE tbl_inven SET @ownerSColumn = '-1' WHERE Serial = @ownerSerial
  704.  
  705. end
  706. insert into ItemLogs (serial, k_value, s_value, s_column) VALUES(@serial, @k_value, @s_value, 'K20')
  707.  
  708. set @error = @@ERROR
  709. if @error <> 0
  710. begin
  711. RAISERROR('>>>POSSIBLE DUPLICATE ITEM<<< ',10,1)
  712. ROLLBACK TRAN
  713. end
  714. end
  715. end
  716.  
  717. if update(k20)
  718. begin
  719. SELECT @k_value = k20, @serial = serial FROM Inserted
  720. if @k_value < 0
  721. begin
  722. delete from ItemLogs WHERE s_column = 'K20' AND serial = @serial
  723. end
  724. end
  725.  
  726. if update(s21)
  727. begin
  728. SELECT @serial = serial, @k_value = k21, @s_value = s21 FROM Inserted
  729.  
  730. if @s_value > 0
  731. begin
  732. SELECT @ownerSerial = serial, @ownerSColumn = s_column FROM ItemLogs WHERE s_value = @s_value
  733. if @ownerSerial > 0
  734. begin
  735. delete from ItemLogs WHERE s_value = @s_value
  736. UPDATE tbl_inven SET @ownerSColumn = '-1' WHERE Serial = @ownerSerial
  737.  
  738. end
  739. insert into ItemLogs (serial, k_value, s_value, s_column) VALUES(@serial, @k_value, @s_value, 'K21')
  740.  
  741. set @error = @@ERROR
  742. if @error <> 0
  743. begin
  744. RAISERROR('>>>POSSIBLE DUPLICATE ITEM<<< ',10,1)
  745. ROLLBACK TRAN
  746. end
  747. end
  748. end
  749.  
  750. if update(k21)
  751. begin
  752. SELECT @k_value = k21, @serial = serial FROM Inserted
  753. if @k_value < 0
  754. begin
  755. delete from ItemLogs WHERE s_column = 'K21' AND serial = @serial
  756. end
  757. end
  758.  
  759. if update(s22)
  760. begin
  761. SELECT @serial = serial, @k_value = k22, @s_value = s22 FROM Inserted
  762.  
  763. if @s_value > 0
  764. begin
  765. SELECT @ownerSerial = serial, @ownerSColumn = s_column FROM ItemLogs WHERE s_value = @s_value
  766. if @ownerSerial > 0
  767. begin
  768. delete from ItemLogs WHERE s_value = @s_value
  769. UPDATE tbl_inven SET @ownerSColumn = '-1' WHERE Serial = @ownerSerial
  770.  
  771. end
  772. insert into ItemLogs (serial, k_value, s_value, s_column) VALUES(@serial, @k_value, @s_value, 'K22')
  773.  
  774. set @error = @@ERROR
  775. if @error <> 0
  776. begin
  777. RAISERROR('>>>POSSIBLE DUPLICATE ITEM<<< ',10,1)
  778. ROLLBACK TRAN
  779. end
  780. end
  781. end
  782.  
  783. if update(k22)
  784. begin
  785. SELECT @k_value = k22, @serial = serial FROM Inserted
  786. if @k_value < 0
  787. begin
  788. delete from ItemLogs WHERE s_column = 'K22' AND serial = @serial
  789. end
  790. end
  791.  
  792. if update(s23)
  793. begin
  794. SELECT @serial = serial, @k_value = k23, @s_value = s23 FROM Inserted
  795.  
  796. if @s_value > 0
  797. begin
  798. SELECT @ownerSerial = serial, @ownerSColumn = s_column FROM ItemLogs WHERE s_value = @s_value
  799. if @ownerSerial > 0
  800. begin
  801. delete from ItemLogs WHERE s_value = @s_value
  802. UPDATE tbl_inven SET @ownerSColumn = '-1' WHERE Serial = @ownerSerial
  803.  
  804. end
  805. insert into ItemLogs (serial, k_value, s_value, s_column) VALUES(@serial, @k_value, @s_value, 'K23')
  806.  
  807. set @error = @@ERROR
  808. if @error <> 0
  809. begin
  810. RAISERROR('>>>POSSIBLE DUPLICATE ITEM<<< ',10,1)
  811. ROLLBACK TRAN
  812. end
  813. end
  814. end
  815.  
  816. if update(k23)
  817. begin
  818. SELECT @k_value = k23, @serial = serial FROM Inserted
  819. if @k_value < 0
  820. begin
  821. delete from ItemLogs WHERE s_column = 'K23' AND serial = @serial
  822. end
  823. end
  824.  
  825. if update(s24)
  826. begin
  827. SELECT @serial = serial, @k_value = k24, @s_value = s24 FROM Inserted
  828.  
  829. if @s_value > 0
  830. begin
  831. SELECT @ownerSerial = serial, @ownerSColumn = s_column FROM ItemLogs WHERE s_value = @s_value
  832. if @ownerSerial > 0
  833. begin
  834. delete from ItemLogs WHERE s_value = @s_value
  835. UPDATE tbl_inven SET @ownerSColumn = '-1' WHERE Serial = @ownerSerial
  836.  
  837. end
  838. insert into ItemLogs (serial, k_value, s_value, s_column) VALUES(@serial, @k_value, @s_value, 'K24')
  839.  
  840. set @error = @@ERROR
  841. if @error <> 0
  842. begin
  843. RAISERROR('>>>POSSIBLE DUPLICATE ITEM<<< ',10,1)
  844. ROLLBACK TRAN
  845. end
  846. end
  847. end
  848.  
  849. if update(k24)
  850. begin
  851. SELECT @k_value = k24, @serial = serial FROM Inserted
  852. if @k_value < 0
  853. begin
  854. delete from ItemLogs WHERE s_column = 'K24' AND serial = @serial
  855. end
  856. end
  857.  
  858. if update(s25)
  859. begin
  860. SELECT @serial = serial, @k_value = k25, @s_value = s25 FROM Inserted
  861.  
  862. if @s_value > 0
  863. begin
  864. SELECT @ownerSerial = serial, @ownerSColumn = s_column FROM ItemLogs WHERE s_value = @s_value
  865. if @ownerSerial > 0
  866. begin
  867. delete from ItemLogs WHERE s_value = @s_value
  868. UPDATE tbl_inven SET @ownerSColumn = '-1' WHERE Serial = @ownerSerial
  869.  
  870. end
  871. insert into ItemLogs (serial, k_value, s_value, s_column) VALUES(@serial, @k_value, @s_value, 'K25')
  872.  
  873. set @error = @@ERROR
  874. if @error <> 0
  875. begin
  876. RAISERROR('>>>POSSIBLE DUPLICATE ITEM<<< ',10,1)
  877. ROLLBACK TRAN
  878. end
  879. end
  880. end
  881.  
  882. if update(k25)
  883. begin
  884. SELECT @k_value = k25, @serial = serial FROM Inserted
  885. if @k_value < 0
  886. begin
  887. delete from ItemLogs WHERE s_column = 'K25' AND serial = @serial
  888. end
  889. end
  890.  
  891. if update(s26)
  892. begin
  893. SELECT @serial = serial, @k_value = k26, @s_value = s26 FROM Inserted
  894.  
  895. if @s_value > 0
  896. begin
  897. SELECT @ownerSerial = serial, @ownerSColumn = s_column FROM ItemLogs WHERE s_value = @s_value
  898. if @ownerSerial > 0
  899. begin
  900. delete from ItemLogs WHERE s_value = @s_value
  901. UPDATE tbl_inven SET @ownerSColumn = '-1' WHERE Serial = @ownerSerial
  902.  
  903. end
  904. insert into ItemLogs (serial, k_value, s_value, s_column) VALUES(@serial, @k_value, @s_value, 'K26')
  905.  
  906. set @error = @@ERROR
  907. if @error <> 0
  908. begin
  909. RAISERROR('>>>POSSIBLE DUPLICATE ITEM<<< ',10,1)
  910. ROLLBACK TRAN
  911. end
  912. end
  913. end
  914.  
  915. if update(k26)
  916. begin
  917. SELECT @k_value = k26, @serial = serial FROM Inserted
  918. if @k_value < 0
  919. begin
  920. delete from ItemLogs WHERE s_column = 'K26' AND serial = @serial
  921. end
  922. end
  923.  
  924. if update(s27)
  925. begin
  926. SELECT @serial = serial, @k_value = k27, @s_value = s27 FROM Inserted
  927.  
  928. if @s_value > 0
  929. begin
  930. SELECT @ownerSerial = serial, @ownerSColumn = s_column FROM ItemLogs WHERE s_value = @s_value
  931. if @ownerSerial > 0
  932. begin
  933. delete from ItemLogs WHERE s_value = @s_value
  934. UPDATE tbl_inven SET @ownerSColumn = '-1' WHERE Serial = @ownerSerial
  935.  
  936. end
  937. insert into ItemLogs (serial, k_value, s_value, s_column) VALUES(@serial, @k_value, @s_value, 'K27')
  938.  
  939. set @error = @@ERROR
  940. if @error <> 0
  941. begin
  942. RAISERROR('>>>POSSIBLE DUPLICATE ITEM<<< ',10,1)
  943. ROLLBACK TRAN
  944. end
  945. end
  946. end
  947.  
  948. if update(k27)
  949. begin
  950. SELECT @k_value = k27, @serial = serial FROM Inserted
  951. if @k_value < 0
  952. begin
  953. delete from ItemLogs WHERE s_column = 'K27' AND serial = @serial
  954. end
  955. end
  956.  
  957. if update(s28)
  958. begin
  959. SELECT @serial = serial, @k_value = k28, @s_value = s28 FROM Inserted
  960.  
  961. if @s_value > 0
  962. begin
  963. SELECT @ownerSerial = serial, @ownerSColumn = s_column FROM ItemLogs WHERE s_value = @s_value
  964. if @ownerSerial > 0
  965. begin
  966. delete from ItemLogs WHERE s_value = @s_value
  967. UPDATE tbl_inven SET @ownerSColumn = '-1' WHERE Serial = @ownerSerial
  968.  
  969. end
  970. insert into ItemLogs (serial, k_value, s_value, s_column) VALUES(@serial, @k_value, @s_value, 'K28')
  971.  
  972. set @error = @@ERROR
  973. if @error <> 0
  974. begin
  975. RAISERROR('>>>POSSIBLE DUPLICATE ITEM<<< ',10,1)
  976. ROLLBACK TRAN
  977. end
  978. end
  979. end
  980.  
  981. if update(k28)
  982. begin
  983. SELECT @k_value = k28, @serial = serial FROM Inserted
  984. if @k_value < 0
  985. begin
  986. delete from ItemLogs WHERE s_column = 'K28' AND serial = @serial
  987. end
  988. end
  989.  
  990. if update(s29)
  991. begin
  992. SELECT @serial = serial, @k_value = k29, @s_value = s29 FROM Inserted
  993.  
  994. if @s_value > 0
  995. begin
  996. SELECT @ownerSerial = serial, @ownerSColumn = s_column FROM ItemLogs WHERE s_value = @s_value
  997. if @ownerSerial > 0
  998. begin
  999. delete from ItemLogs WHERE s_value = @s_value
  1000. UPDATE tbl_inven SET @ownerSColumn = '-1' WHERE Serial = @ownerSerial
  1001.  
  1002. end
  1003. insert into ItemLogs (serial, k_value, s_value, s_column) VALUES(@serial, @k_value, @s_value, 'K29')
  1004.  
  1005. set @error = @@ERROR
  1006. if @error <> 0
  1007. begin
  1008. RAISERROR('>>>POSSIBLE DUPLICATE ITEM<<< ',10,1)
  1009. ROLLBACK TRAN
  1010. end
  1011. end
  1012. end
  1013.  
  1014. if update(k29)
  1015. begin
  1016. SELECT @k_value = k29, @serial = serial FROM Inserted
  1017. if @k_value < 0
  1018. begin
  1019. delete from ItemLogs WHERE s_column = 'K29' AND serial = @serial
  1020. end
  1021. end
  1022.  
  1023. if update(s30)
  1024. begin
  1025. SELECT @serial = serial, @k_value = k30, @s_value = s30 FROM Inserted
  1026.  
  1027. if @s_value > 0
  1028. begin
  1029. SELECT @ownerSerial = serial, @ownerSColumn = s_column FROM ItemLogs WHERE s_value = @s_value
  1030. if @ownerSerial > 0
  1031. begin
  1032. delete from ItemLogs WHERE s_value = @s_value
  1033. UPDATE tbl_inven SET @ownerSColumn = '-1' WHERE Serial = @ownerSerial
  1034.  
  1035. end
  1036. insert into ItemLogs (serial, k_value, s_value, s_column) VALUES(@serial, @k_value, @s_value, 'K30')
  1037.  
  1038. set @error = @@ERROR
  1039. if @error <> 0
  1040. begin
  1041. RAISERROR('>>>POSSIBLE DUPLICATE ITEM<<< ',10,1)
  1042. ROLLBACK TRAN
  1043. end
  1044. end
  1045. end
  1046.  
  1047. if update(k30)
  1048. begin
  1049. SELECT @k_value = k30, @serial = serial FROM Inserted
  1050. if @k_value < 0
  1051. begin
  1052. delete from ItemLogs WHERE s_column = 'K30' AND serial = @serial
  1053. end
  1054. end
  1055.  
  1056. if update(s31)
  1057. begin
  1058. SELECT @serial = serial, @k_value = k31, @s_value = s31 FROM Inserted
  1059.  
  1060. if @s_value > 0
  1061. begin
  1062. SELECT @ownerSerial = serial, @ownerSColumn = s_column FROM ItemLogs WHERE s_value = @s_value
  1063. if @ownerSerial > 0
  1064. begin
  1065. delete from ItemLogs WHERE s_value = @s_value
  1066. UPDATE tbl_inven SET @ownerSColumn = '-1' WHERE Serial = @ownerSerial
  1067.  
  1068. end
  1069. insert into ItemLogs (serial, k_value, s_value, s_column) VALUES(@serial, @k_value, @s_value, 'K31')
  1070.  
  1071. set @error = @@ERROR
  1072. if @error <> 0
  1073. begin
  1074. RAISERROR('>>>POSSIBLE DUPLICATE ITEM<<< ',10,1)
  1075. ROLLBACK TRAN
  1076. end
  1077. end
  1078. end
  1079.  
  1080. if update(k31)
  1081. begin
  1082. SELECT @k_value = k31, @serial = serial FROM Inserted
  1083. if @k_value < 0
  1084. begin
  1085. delete from ItemLogs WHERE s_column = 'K31' AND serial = @serial
  1086. end
  1087. end
  1088.  
  1089. if update(s32)
  1090. begin
  1091. SELECT @serial = serial, @k_value = k32, @s_value = s32 FROM Inserted
  1092.  
  1093. if @s_value > 0
  1094. begin
  1095. SELECT @ownerSerial = serial, @ownerSColumn = s_column FROM ItemLogs WHERE s_value = @s_value
  1096. if @ownerSerial > 0
  1097. begin
  1098. delete from ItemLogs WHERE s_value = @s_value
  1099. UPDATE tbl_inven SET @ownerSColumn = '-1' WHERE Serial = @ownerSerial
  1100.  
  1101. end
  1102. insert into ItemLogs (serial, k_value, s_value, s_column) VALUES(@serial, @k_value, @s_value, 'K32')
  1103.  
  1104. set @error = @@ERROR
  1105. if @error <> 0
  1106. begin
  1107. RAISERROR('>>>POSSIBLE DUPLICATE ITEM<<< ',10,1)
  1108. ROLLBACK TRAN
  1109. end
  1110. end
  1111. end
  1112.  
  1113. if update(k32)
  1114. begin
  1115. SELECT @k_value = k32, @serial = serial FROM Inserted
  1116. if @k_value < 0
  1117. begin
  1118. delete from ItemLogs WHERE s_column = 'K32' AND serial = @serial
  1119. end
  1120. end
  1121.  
  1122. if update(s33)
  1123. begin
  1124. SELECT @serial = serial, @k_value = k33, @s_value = s33 FROM Inserted
  1125.  
  1126. if @s_value > 0
  1127. begin
  1128. SELECT @ownerSerial = serial, @ownerSColumn = s_column FROM ItemLogs WHERE s_value = @s_value
  1129. if @ownerSerial > 0
  1130. begin
  1131. delete from ItemLogs WHERE s_value = @s_value
  1132. UPDATE tbl_inven SET @ownerSColumn = '-1' WHERE Serial = @ownerSerial
  1133.  
  1134. end
  1135. insert into ItemLogs (serial, k_value, s_value, s_column) VALUES(@serial, @k_value, @s_value, 'K33')
  1136.  
  1137. set @error = @@ERROR
  1138. if @error <> 0
  1139. begin
  1140. RAISERROR('>>>POSSIBLE DUPLICATE ITEM<<< ',10,1)
  1141. ROLLBACK TRAN
  1142. end
  1143. end
  1144. end
  1145.  
  1146. if update(k33)
  1147. begin
  1148. SELECT @k_value = k33, @serial = serial FROM Inserted
  1149. if @k_value < 0
  1150. begin
  1151. delete from ItemLogs WHERE s_column = 'K33' AND serial = @serial
  1152. end
  1153. end
  1154.  
  1155. if update(s34)
  1156. begin
  1157. SELECT @serial = serial, @k_value = k34, @s_value = s34 FROM Inserted
  1158.  
  1159. if @s_value > 0
  1160. begin
  1161. SELECT @ownerSerial = serial, @ownerSColumn = s_column FROM ItemLogs WHERE s_value = @s_value
  1162. if @ownerSerial > 0
  1163. begin
  1164. delete from ItemLogs WHERE s_value = @s_value
  1165. UPDATE tbl_inven SET @ownerSColumn = '-1' WHERE Serial = @ownerSerial
  1166.  
  1167. end
  1168. insert into ItemLogs (serial, k_value, s_value, s_column) VALUES(@serial, @k_value, @s_value, 'K34')
  1169.  
  1170. set @error = @@ERROR
  1171. if @error <> 0
  1172. begin
  1173. RAISERROR('>>>POSSIBLE DUPLICATE ITEM<<< ',10,1)
  1174. ROLLBACK TRAN
  1175. end
  1176. end
  1177. end
  1178.  
  1179. if update(k34)
  1180. begin
  1181. SELECT @k_value = k34, @serial = serial FROM Inserted
  1182. if @k_value < 0
  1183. begin
  1184. delete from ItemLogs WHERE s_column = 'K34' AND serial = @serial
  1185. end
  1186. end
  1187.  
  1188. if update(s35)
  1189. begin
  1190. SELECT @serial = serial, @k_value = k35, @s_value = s35 FROM Inserted
  1191.  
  1192. if @s_value > 0
  1193. begin
  1194. SELECT @ownerSerial = serial, @ownerSColumn = s_column FROM ItemLogs WHERE s_value = @s_value
  1195. if @ownerSerial > 0
  1196. begin
  1197. delete from ItemLogs WHERE s_value = @s_value
  1198. UPDATE tbl_inven SET @ownerSColumn = '-1' WHERE Serial = @ownerSerial
  1199.  
  1200. end
  1201. insert into ItemLogs (serial, k_value, s_value, s_column) VALUES(@serial, @k_value, @s_value, 'K35')
  1202.  
  1203. set @error = @@ERROR
  1204. if @error <> 0
  1205. begin
  1206. RAISERROR('>>>POSSIBLE DUPLICATE ITEM<<< ',10,1)
  1207. ROLLBACK TRAN
  1208. end
  1209. end
  1210. end
  1211.  
  1212. if update(k35)
  1213. begin
  1214. SELECT @k_value = k35, @serial = serial FROM Inserted
  1215. if @k_value < 0
  1216. begin
  1217. delete from ItemLogs WHERE s_column = 'K35' AND serial = @serial
  1218. end
  1219. end
  1220.  
  1221. if update(s36)
  1222. begin
  1223. SELECT @serial = serial, @k_value = k36, @s_value = s36 FROM Inserted
  1224.  
  1225. if @s_value > 0
  1226. begin
  1227. SELECT @ownerSerial = serial, @ownerSColumn = s_column FROM ItemLogs WHERE s_value = @s_value
  1228. if @ownerSerial > 0
  1229. begin
  1230. delete from ItemLogs WHERE s_value = @s_value
  1231. UPDATE tbl_inven SET @ownerSColumn = '-1' WHERE Serial = @ownerSerial
  1232.  
  1233. end
  1234. insert into ItemLogs (serial, k_value, s_value, s_column) VALUES(@serial, @k_value, @s_value, 'K36')
  1235.  
  1236. set @error = @@ERROR
  1237. if @error <> 0
  1238. begin
  1239. RAISERROR('>>>POSSIBLE DUPLICATE ITEM<<< ',10,1)
  1240. ROLLBACK TRAN
  1241. end
  1242. end
  1243. end
  1244.  
  1245. if update(k36)
  1246. begin
  1247. SELECT @k_value = k36, @serial = serial FROM Inserted
  1248. if @k_value < 0
  1249. begin
  1250. delete from ItemLogs WHERE s_column = 'K36' AND serial = @serial
  1251. end
  1252. end
  1253.  
  1254. if update(s37)
  1255. begin
  1256. SELECT @serial = serial, @k_value = k37, @s_value = s37 FROM Inserted
  1257.  
  1258. if @s_value > 0
  1259. begin
  1260. SELECT @ownerSerial = serial, @ownerSColumn = s_column FROM ItemLogs WHERE s_value = @s_value
  1261. if @ownerSerial > 0
  1262. begin
  1263. delete from ItemLogs WHERE s_value = @s_value
  1264. UPDATE tbl_inven SET @ownerSColumn = '-1' WHERE Serial = @ownerSerial
  1265.  
  1266. end
  1267. insert into ItemLogs (serial, k_value, s_value, s_column) VALUES(@serial, @k_value, @s_value, 'K37')
  1268.  
  1269. set @error = @@ERROR
  1270. if @error <> 0
  1271. begin
  1272. RAISERROR('>>>POSSIBLE DUPLICATE ITEM<<< ',10,1)
  1273. ROLLBACK TRAN
  1274. end
  1275. end
  1276. end
  1277.  
  1278. if update(k37)
  1279. begin
  1280. SELECT @k_value = k37, @serial = serial FROM Inserted
  1281. if @k_value < 0
  1282. begin
  1283. delete from ItemLogs WHERE s_column = 'K37' AND serial = @serial
  1284. end
  1285. end
  1286.  
  1287. if update(s38)
  1288. begin
  1289. SELECT @serial = serial, @k_value = k38, @s_value = s38 FROM Inserted
  1290.  
  1291. if @s_value > 0
  1292. begin
  1293. SELECT @ownerSerial = serial, @ownerSColumn = s_column FROM ItemLogs WHERE s_value = @s_value
  1294. if @ownerSerial > 0
  1295. begin
  1296. delete from ItemLogs WHERE s_value = @s_value
  1297. UPDATE tbl_inven SET @ownerSColumn = '-1' WHERE Serial = @ownerSerial
  1298.  
  1299. end
  1300. insert into ItemLogs (serial, k_value, s_value, s_column) VALUES(@serial, @k_value, @s_value, 'K38')
  1301.  
  1302. set @error = @@ERROR
  1303. if @error <> 0
  1304. begin
  1305. RAISERROR('>>>POSSIBLE DUPLICATE ITEM<<< ',10,1)
  1306. ROLLBACK TRAN
  1307. end
  1308. end
  1309. end
  1310.  
  1311. if update(k38)
  1312. begin
  1313. SELECT @k_value = k38, @serial = serial FROM Inserted
  1314. if @k_value < 0
  1315. begin
  1316. delete from ItemLogs WHERE s_column = 'K38' AND serial = @serial
  1317. end
  1318. end
  1319.  
  1320. if update(s39)
  1321. begin
  1322. SELECT @serial = serial, @k_value = k39, @s_value = s39 FROM Inserted
  1323.  
  1324. if @s_value > 0
  1325. begin
  1326. SELECT @ownerSerial = serial, @ownerSColumn = s_column FROM ItemLogs WHERE s_value = @s_value
  1327. if @ownerSerial > 0
  1328. begin
  1329. delete from ItemLogs WHERE s_value = @s_value
  1330. UPDATE tbl_inven SET @ownerSColumn = '-1' WHERE Serial = @ownerSerial
  1331.  
  1332. end
  1333. insert into ItemLogs (serial, k_value, s_value, s_column) VALUES(@serial, @k_value, @s_value, 'K39')
  1334.  
  1335. set @error = @@ERROR
  1336. if @error <> 0
  1337. begin
  1338. RAISERROR('>>>POSSIBLE DUPLICATE ITEM<<< ',10,1)
  1339. ROLLBACK TRAN
  1340. end
  1341. end
  1342. end
  1343.  
  1344. if update(k39)
  1345. begin
  1346. SELECT @k_value = k39, @serial = serial FROM Inserted
  1347. if @k_value < 0
  1348. begin
  1349. delete from ItemLogs WHERE s_column = 'K39' AND serial = @serial
  1350. end
  1351. end
  1352.  
  1353. if update(s40)
  1354. begin
  1355. SELECT @serial = serial, @k_value = k40, @s_value = s40 FROM Inserted
  1356.  
  1357. if @s_value > 0
  1358. begin
  1359. SELECT @ownerSerial = serial, @ownerSColumn = s_column FROM ItemLogs WHERE s_value = @s_value
  1360. if @ownerSerial > 0
  1361. begin
  1362. delete from ItemLogs WHERE s_value = @s_value
  1363. UPDATE tbl_inven SET @ownerSColumn = '-1' WHERE Serial = @ownerSerial
  1364.  
  1365. end
  1366. insert into ItemLogs (serial, k_value, s_value, s_column) VALUES(@serial, @k_value, @s_value, 'K40')
  1367.  
  1368. set @error = @@ERROR
  1369. if @error <> 0
  1370. begin
  1371. RAISERROR('>>>POSSIBLE DUPLICATE ITEM<<< ',10,1)
  1372. ROLLBACK TRAN
  1373. end
  1374. end
  1375. end
  1376.  
  1377. if update(k40)
  1378. begin
  1379. SELECT @k_value = k40, @serial = serial FROM Inserted
  1380. if @k_value < 0
  1381. begin
  1382. delete from ItemLogs WHERE s_column = 'K40' AND serial = @serial
  1383. end
  1384. end
  1385.  
  1386. if update(s41)
  1387. begin
  1388. SELECT @serial = serial, @k_value = k41, @s_value = s41 FROM Inserted
  1389.  
  1390. if @s_value > 0
  1391. begin
  1392. SELECT @ownerSerial = serial, @ownerSColumn = s_column FROM ItemLogs WHERE s_value = @s_value
  1393. if @ownerSerial > 0
  1394. begin
  1395. delete from ItemLogs WHERE s_value = @s_value
  1396. UPDATE tbl_inven SET @ownerSColumn = '-1' WHERE Serial = @ownerSerial
  1397.  
  1398. end
  1399. insert into ItemLogs (serial, k_value, s_value, s_column) VALUES(@serial, @k_value, @s_value, 'K41')
  1400.  
  1401. set @error = @@ERROR
  1402. if @error <> 0
  1403. begin
  1404. RAISERROR('>>>POSSIBLE DUPLICATE ITEM<<< ',10,1)
  1405. ROLLBACK TRAN
  1406. end
  1407. end
  1408. end
  1409.  
  1410. if update(k41)
  1411. begin
  1412. SELECT @k_value = k41, @serial = serial FROM Inserted
  1413. if @k_value < 0
  1414. begin
  1415. delete from ItemLogs WHERE s_column = 'K41' AND serial = @serial
  1416. end
  1417. end
  1418.  
  1419. if update(s42)
  1420. begin
  1421. SELECT @serial = serial, @k_value = k42, @s_value = s42 FROM Inserted
  1422.  
  1423. if @s_value > 0
  1424. begin
  1425. SELECT @ownerSerial = serial, @ownerSColumn = s_column FROM ItemLogs WHERE s_value = @s_value
  1426. if @ownerSerial > 0
  1427. begin
  1428. delete from ItemLogs WHERE s_value = @s_value
  1429. UPDATE tbl_inven SET @ownerSColumn = '-1' WHERE Serial = @ownerSerial
  1430.  
  1431. end
  1432. insert into ItemLogs (serial, k_value, s_value, s_column) VALUES(@serial, @k_value, @s_value, 'K42')
  1433.  
  1434. set @error = @@ERROR
  1435. if @error <> 0
  1436. begin
  1437. RAISERROR('>>>POSSIBLE DUPLICATE ITEM<<< ',10,1)
  1438. ROLLBACK TRAN
  1439. end
  1440. end
  1441. end
  1442.  
  1443. if update(k42)
  1444. begin
  1445. SELECT @k_value = k42, @serial = serial FROM Inserted
  1446. if @k_value < 0
  1447. begin
  1448. delete from ItemLogs WHERE s_column = 'K42' AND serial = @serial
  1449. end
  1450. end
  1451.  
  1452. if update(s43)
  1453. begin
  1454. SELECT @serial = serial, @k_value = k43, @s_value = s43 FROM Inserted
  1455.  
  1456. if @s_value > 0
  1457. begin
  1458. SELECT @ownerSerial = serial, @ownerSColumn = s_column FROM ItemLogs WHERE s_value = @s_value
  1459. if @ownerSerial > 0
  1460. begin
  1461. delete from ItemLogs WHERE s_value = @s_value
  1462. UPDATE tbl_inven SET @ownerSColumn = '-1' WHERE Serial = @ownerSerial
  1463.  
  1464. end
  1465. insert into ItemLogs (serial, k_value, s_value, s_column) VALUES(@serial, @k_value, @s_value, 'K43')
  1466.  
  1467. set @error = @@ERROR
  1468. if @error <> 0
  1469. begin
  1470. RAISERROR('>>>POSSIBLE DUPLICATE ITEM<<< ',10,1)
  1471. ROLLBACK TRAN
  1472. end
  1473. end
  1474. end
  1475.  
  1476. if update(k43)
  1477. begin
  1478. SELECT @k_value = k43, @serial = serial FROM Inserted
  1479. if @k_value < 0
  1480. begin
  1481. delete from ItemLogs WHERE s_column = 'K43' AND serial = @serial
  1482. end
  1483. end
  1484.  
  1485. if update(s44)
  1486. begin
  1487. SELECT @serial = serial, @k_value = k44, @s_value = s44 FROM Inserted
  1488.  
  1489. if @s_value > 0
  1490. begin
  1491. SELECT @ownerSerial = serial, @ownerSColumn = s_column FROM ItemLogs WHERE s_value = @s_value
  1492. if @ownerSerial > 0
  1493. begin
  1494. delete from ItemLogs WHERE s_value = @s_value
  1495. UPDATE tbl_inven SET @ownerSColumn = '-1' WHERE Serial = @ownerSerial
  1496.  
  1497. end
  1498. insert into ItemLogs (serial, k_value, s_value, s_column) VALUES(@serial, @k_value, @s_value, 'K44')
  1499.  
  1500. set @error = @@ERROR
  1501. if @error <> 0
  1502. begin
  1503. RAISERROR('>>>POSSIBLE DUPLICATE ITEM<<< ',10,1)
  1504. ROLLBACK TRAN
  1505. end
  1506. end
  1507. end
  1508.  
  1509. if update(k44)
  1510. begin
  1511. SELECT @k_value = k44, @serial = serial FROM Inserted
  1512. if @k_value < 0
  1513. begin
  1514. delete from ItemLogs WHERE s_column = 'K44' AND serial = @serial
  1515. end
  1516. end
  1517.  
  1518. if update(s45)
  1519. begin
  1520. SELECT @serial = serial, @k_value = k45, @s_value = s45 FROM Inserted
  1521.  
  1522. if @s_value > 0
  1523. begin
  1524. SELECT @ownerSerial = serial, @ownerSColumn = s_column FROM ItemLogs WHERE s_value = @s_value
  1525. if @ownerSerial > 0
  1526. begin
  1527. delete from ItemLogs WHERE s_value = @s_value
  1528. UPDATE tbl_inven SET @ownerSColumn = '-1' WHERE Serial = @ownerSerial
  1529.  
  1530. end
  1531. insert into ItemLogs (serial, k_value, s_value, s_column) VALUES(@serial, @k_value, @s_value, 'K45')
  1532.  
  1533. set @error = @@ERROR
  1534. if @error <> 0
  1535. begin
  1536. RAISERROR('>>>POSSIBLE DUPLICATE ITEM<<< ',10,1)
  1537. ROLLBACK TRAN
  1538. end
  1539. end
  1540. end
  1541.  
  1542. if update(k45)
  1543. begin
  1544. SELECT @k_value = k45, @serial = serial FROM Inserted
  1545. if @k_value < 0
  1546. begin
  1547. delete from ItemLogs WHERE s_column = 'K45' AND serial = @serial
  1548. end
  1549. end
  1550.  
  1551. if update(s46)
  1552. begin
  1553. SELECT @serial = serial, @k_value = k46, @s_value = s46 FROM Inserted
  1554.  
  1555. if @s_value > 0
  1556. begin
  1557. SELECT @ownerSerial = serial, @ownerSColumn = s_column FROM ItemLogs WHERE s_value = @s_value
  1558. if @ownerSerial > 0
  1559. begin
  1560. delete from ItemLogs WHERE s_value = @s_value
  1561. UPDATE tbl_inven SET @ownerSColumn = '-1' WHERE Serial = @ownerSerial
  1562.  
  1563. end
  1564. insert into ItemLogs (serial, k_value, s_value, s_column) VALUES(@serial, @k_value, @s_value, 'K46')
  1565.  
  1566. set @error = @@ERROR
  1567. if @error <> 0
  1568. begin
  1569. RAISERROR('>>>POSSIBLE DUPLICATE ITEM<<< ',10,1)
  1570. ROLLBACK TRAN
  1571. end
  1572. end
  1573. end
  1574.  
  1575. if update(k46)
  1576. begin
  1577. SELECT @k_value = k46, @serial = serial FROM Inserted
  1578. if @k_value < 0
  1579. begin
  1580. delete from ItemLogs WHERE s_column = 'K46' AND serial = @serial
  1581. end
  1582. end
  1583.  
  1584. if update(s47)
  1585. begin
  1586. SELECT @serial = serial, @k_value = k47, @s_value = s47 FROM Inserted
  1587.  
  1588. if @s_value > 0
  1589. begin
  1590. SELECT @ownerSerial = serial, @ownerSColumn = s_column FROM ItemLogs WHERE s_value = @s_value
  1591. if @ownerSerial > 0
  1592. begin
  1593. delete from ItemLogs WHERE s_value = @s_value
  1594. UPDATE tbl_inven SET @ownerSColumn = '-1' WHERE Serial = @ownerSerial
  1595.  
  1596. end
  1597. insert into ItemLogs (serial, k_value, s_value, s_column) VALUES(@serial, @k_value, @s_value, 'K47')
  1598.  
  1599. set @error = @@ERROR
  1600. if @error <> 0
  1601. begin
  1602. RAISERROR('>>>POSSIBLE DUPLICATE ITEM<<< ',10,1)
  1603. ROLLBACK TRAN
  1604. end
  1605. end
  1606. end
  1607.  
  1608. if update(k47)
  1609. begin
  1610. SELECT @k_value = k47, @serial = serial FROM Inserted
  1611. if @k_value < 0
  1612. begin
  1613. delete from ItemLogs WHERE s_column = 'K47' AND serial = @serial
  1614. end
  1615. end
  1616.  
  1617. if update(s48)
  1618. begin
  1619. SELECT @serial = serial, @k_value = k48, @s_value = s48 FROM Inserted
  1620.  
  1621. if @s_value > 0
  1622. begin
  1623. SELECT @ownerSerial = serial, @ownerSColumn = s_column FROM ItemLogs WHERE s_value = @s_value
  1624. if @ownerSerial > 0
  1625. begin
  1626. delete from ItemLogs WHERE s_value = @s_value
  1627. UPDATE tbl_inven SET @ownerSColumn = '-1' WHERE Serial = @ownerSerial
  1628.  
  1629. end
  1630. insert into ItemLogs (serial, k_value, s_value, s_column) VALUES(@serial, @k_value, @s_value, 'K48')
  1631.  
  1632. set @error = @@ERROR
  1633. if @error <> 0
  1634. begin
  1635. RAISERROR('>>>POSSIBLE DUPLICATE ITEM<<< ',10,1)
  1636. ROLLBACK TRAN
  1637. end
  1638. end
  1639. end
  1640.  
  1641. if update(k48)
  1642. begin
  1643. SELECT @k_value = k48, @serial = serial FROM Inserted
  1644. if @k_value < 0
  1645. begin
  1646. delete from ItemLogs WHERE s_column = 'K48' AND serial = @serial
  1647. end
  1648. end
  1649.  
  1650. if update(s49)
  1651. begin
  1652. SELECT @serial = serial, @k_value = k49, @s_value = s49 FROM Inserted
  1653.  
  1654. if @s_value > 0
  1655. begin
  1656. SELECT @ownerSerial = serial, @ownerSColumn = s_column FROM ItemLogs WHERE s_value = @s_value
  1657. if @ownerSerial > 0
  1658. begin
  1659. delete from ItemLogs WHERE s_value = @s_value
  1660. UPDATE tbl_inven SET @ownerSColumn = '-1' WHERE Serial = @ownerSerial
  1661.  
  1662. end
  1663. insert into ItemLogs (serial, k_value, s_value, s_column) VALUES(@serial, @k_value, @s_value, 'K49')
  1664.  
  1665. set @error = @@ERROR
  1666. if @error <> 0
  1667. begin
  1668. RAISERROR('>>>POSSIBLE DUPLICATE ITEM<<< ',10,1)
  1669. ROLLBACK TRAN
  1670. end
  1671. end
  1672. end
  1673.  
  1674. if update(k49)
  1675. begin
  1676. SELECT @k_value = k49, @serial = serial FROM Inserted
  1677. if @k_value < 0
  1678. begin
  1679. delete from ItemLogs WHERE s_column = 'K49' AND serial = @serial
  1680. end
  1681. end
  1682.  
  1683. if update(s50)
  1684. begin
  1685. SELECT @serial = serial, @k_value = k50, @s_value = s50 FROM Inserted
  1686.  
  1687. if @s_value > 0
  1688. begin
  1689. SELECT @ownerSerial = serial, @ownerSColumn = s_column FROM ItemLogs WHERE s_value = @s_value
  1690. if @ownerSerial > 0
  1691. begin
  1692. delete from ItemLogs WHERE s_value = @s_value
  1693. UPDATE tbl_inven SET @ownerSColumn = '-1' WHERE Serial = @ownerSerial
  1694.  
  1695. end
  1696. insert into ItemLogs (serial, k_value, s_value, s_column) VALUES(@serial, @k_value, @s_value, 'K50')
  1697.  
  1698. set @error = @@ERROR
  1699. if @error <> 0
  1700. begin
  1701. RAISERROR('>>>POSSIBLE DUPLICATE ITEM<<< ',10,1)
  1702. ROLLBACK TRAN
  1703. end
  1704. end
  1705. end
  1706.  
  1707. if update(k50)
  1708. begin
  1709. SELECT @k_value = k50, @serial = serial FROM Inserted
  1710. if @k_value < 0
  1711. begin
  1712. delete from ItemLogs WHERE s_column = 'K50' AND serial = @serial
  1713. end
  1714. end
  1715.  
  1716. if update(s51)
  1717. begin
  1718. SELECT @serial = serial, @k_value = k51, @s_value = s51 FROM Inserted
  1719.  
  1720. if @s_value > 0
  1721. begin
  1722. SELECT @ownerSerial = serial, @ownerSColumn = s_column FROM ItemLogs WHERE s_value = @s_value
  1723. if @ownerSerial > 0
  1724. begin
  1725. delete from ItemLogs WHERE s_value = @s_value
  1726. UPDATE tbl_inven SET @ownerSColumn = '-1' WHERE Serial = @ownerSerial
  1727.  
  1728. end
  1729. insert into ItemLogs (serial, k_value, s_value, s_column) VALUES(@serial, @k_value, @s_value, 'K51')
  1730.  
  1731. set @error = @@ERROR
  1732. if @error <> 0
  1733. begin
  1734. RAISERROR('>>>POSSIBLE DUPLICATE ITEM<<< ',10,1)
  1735. ROLLBACK TRAN
  1736. end
  1737. end
  1738. end
  1739.  
  1740. if update(k51)
  1741. begin
  1742. SELECT @k_value = k51, @serial = serial FROM Inserted
  1743. if @k_value < 0
  1744. begin
  1745. delete from ItemLogs WHERE s_column = 'K51' AND serial = @serial
  1746. end
  1747. end
  1748.  
  1749. if update(s52)
  1750. begin
  1751. SELECT @serial = serial, @k_value = k52, @s_value = s52 FROM Inserted
  1752.  
  1753. if @s_value > 0
  1754. begin
  1755. SELECT @ownerSerial = serial, @ownerSColumn = s_column FROM ItemLogs WHERE s_value = @s_value
  1756. if @ownerSerial > 0
  1757. begin
  1758. delete from ItemLogs WHERE s_value = @s_value
  1759. UPDATE tbl_inven SET @ownerSColumn = '-1' WHERE Serial = @ownerSerial
  1760.  
  1761. end
  1762. insert into ItemLogs (serial, k_value, s_value, s_column) VALUES(@serial, @k_value, @s_value, 'K52')
  1763.  
  1764. set @error = @@ERROR
  1765. if @error <> 0
  1766. begin
  1767. RAISERROR('>>>POSSIBLE DUPLICATE ITEM<<< ',10,1)
  1768. ROLLBACK TRAN
  1769. end
  1770. end
  1771. end
  1772.  
  1773. if update(k52)
  1774. begin
  1775. SELECT @k_value = k52, @serial = serial FROM Inserted
  1776. if @k_value < 0
  1777. begin
  1778. delete from ItemLogs WHERE s_column = 'K52' AND serial = @serial
  1779. end
  1780. end
  1781.  
  1782. if update(s53)
  1783. begin
  1784. SELECT @serial = serial, @k_value = k53, @s_value = s53 FROM Inserted
  1785.  
  1786. if @s_value > 0
  1787. begin
  1788. SELECT @ownerSerial = serial, @ownerSColumn = s_column FROM ItemLogs WHERE s_value = @s_value
  1789. if @ownerSerial > 0
  1790. begin
  1791. delete from ItemLogs WHERE s_value = @s_value
  1792. UPDATE tbl_inven SET @ownerSColumn = '-1' WHERE Serial = @ownerSerial
  1793.  
  1794. end
  1795. insert into ItemLogs (serial, k_value, s_value, s_column) VALUES(@serial, @k_value, @s_value, 'K53')
  1796.  
  1797. set @error = @@ERROR
  1798. if @error <> 0
  1799. begin
  1800. RAISERROR('>>>POSSIBLE DUPLICATE ITEM<<< ',10,1)
  1801. ROLLBACK TRAN
  1802. end
  1803. end
  1804. end
  1805.  
  1806. if update(k53)
  1807. begin
  1808. SELECT @k_value = k53, @serial = serial FROM Inserted
  1809. if @k_value < 0
  1810. begin
  1811. delete from ItemLogs WHERE s_column = 'K53' AND serial = @serial
  1812. end
  1813. end
  1814.  
  1815. if update(s54)
  1816. begin
  1817. SELECT @serial = serial, @k_value = k54, @s_value = s54 FROM Inserted
  1818.  
  1819. if @s_value > 0
  1820. begin
  1821. SELECT @ownerSerial = serial, @ownerSColumn = s_column FROM ItemLogs WHERE s_value = @s_value
  1822. if @ownerSerial > 0
  1823. begin
  1824. delete from ItemLogs WHERE s_value = @s_value
  1825. UPDATE tbl_inven SET @ownerSColumn = '-1' WHERE Serial = @ownerSerial
  1826.  
  1827. end
  1828. insert into ItemLogs (serial, k_value, s_value, s_column) VALUES(@serial, @k_value, @s_value, 'K54')
  1829.  
  1830. set @error = @@ERROR
  1831. if @error <> 0
  1832. begin
  1833. RAISERROR('>>>POSSIBLE DUPLICATE ITEM<<< ',10,1)
  1834. ROLLBACK TRAN
  1835. end
  1836. end
  1837. end
  1838.  
  1839. if update(k54)
  1840. begin
  1841. SELECT @k_value = k54, @serial = serial FROM Inserted
  1842. if @k_value < 0
  1843. begin
  1844. delete from ItemLogs WHERE s_column = 'K54' AND serial = @serial
  1845. end
  1846. end
  1847.  
  1848. if update(s55)
  1849. begin
  1850. SELECT @serial = serial, @k_value = k55, @s_value = s55 FROM Inserted
  1851.  
  1852. if @s_value > 0
  1853. begin
  1854. SELECT @ownerSerial = serial, @ownerSColumn = s_column FROM ItemLogs WHERE s_value = @s_value
  1855. if @ownerSerial > 0
  1856. begin
  1857. delete from ItemLogs WHERE s_value = @s_value
  1858. UPDATE tbl_inven SET @ownerSColumn = '-1' WHERE Serial = @ownerSerial
  1859.  
  1860. end
  1861. insert into ItemLogs (serial, k_value, s_value, s_column) VALUES(@serial, @k_value, @s_value, 'K55')
  1862.  
  1863. set @error = @@ERROR
  1864. if @error <> 0
  1865. begin
  1866. RAISERROR('>>>POSSIBLE DUPLICATE ITEM<<< ',10,1)
  1867. ROLLBACK TRAN
  1868. end
  1869. end
  1870. end
  1871.  
  1872. if update(k55)
  1873. begin
  1874. SELECT @k_value = k55, @serial = serial FROM Inserted
  1875. if @k_value < 0
  1876. begin
  1877. delete from ItemLogs WHERE s_column = 'K55' AND serial = @serial
  1878. end
  1879. end
  1880.  
  1881. if update(s56)
  1882. begin
  1883. SELECT @serial = serial, @k_value = k56, @s_value = s56 FROM Inserted
  1884.  
  1885. if @s_value > 0
  1886. begin
  1887. SELECT @ownerSerial = serial, @ownerSColumn = s_column FROM ItemLogs WHERE s_value = @s_value
  1888. if @ownerSerial > 0
  1889. begin
  1890. delete from ItemLogs WHERE s_value = @s_value
  1891. UPDATE tbl_inven SET @ownerSColumn = '-1' WHERE Serial = @ownerSerial
  1892.  
  1893. end
  1894. insert into ItemLogs (serial, k_value, s_value, s_column) VALUES(@serial, @k_value, @s_value, 'K56')
  1895.  
  1896. set @error = @@ERROR
  1897. if @error <> 0
  1898. begin
  1899. RAISERROR('>>>POSSIBLE DUPLICATE ITEM<<< ',10,1)
  1900. ROLLBACK TRAN
  1901. end
  1902. end
  1903. end
  1904.  
  1905. if update(k56)
  1906. begin
  1907. SELECT @k_value = k56, @serial = serial FROM Inserted
  1908. if @k_value < 0
  1909. begin
  1910. delete from ItemLogs WHERE s_column = 'K56' AND serial = @serial
  1911. end
  1912. end
  1913.  
  1914. if update(s57)
  1915. begin
  1916. SELECT @serial = serial, @k_value = k57, @s_value = s57 FROM Inserted
  1917.  
  1918. if @s_value > 0
  1919. begin
  1920. SELECT @ownerSerial = serial, @ownerSColumn = s_column FROM ItemLogs WHERE s_value = @s_value
  1921. if @ownerSerial > 0
  1922. begin
  1923. delete from ItemLogs WHERE s_value = @s_value
  1924. UPDATE tbl_inven SET @ownerSColumn = '-1' WHERE Serial = @ownerSerial
  1925.  
  1926. end
  1927. insert into ItemLogs (serial, k_value, s_value, s_column) VALUES(@serial, @k_value, @s_value, 'K57')
  1928.  
  1929. set @error = @@ERROR
  1930. if @error <> 0
  1931. begin
  1932. RAISERROR('>>>POSSIBLE DUPLICATE ITEM<<< ',10,1)
  1933. ROLLBACK TRAN
  1934. end
  1935. end
  1936. end
  1937.  
  1938. if update(k57)
  1939. begin
  1940. SELECT @k_value = k57, @serial = serial FROM Inserted
  1941. if @k_value < 0
  1942. begin
  1943. delete from ItemLogs WHERE s_column = 'K57' AND serial = @serial
  1944. end
  1945. end
  1946.  
  1947. if update(s58)
  1948. begin
  1949. SELECT @serial = serial, @k_value = k58, @s_value = s58 FROM Inserted
  1950.  
  1951. if @s_value > 0
  1952. begin
  1953. SELECT @ownerSerial = serial, @ownerSColumn = s_column FROM ItemLogs WHERE s_value = @s_value
  1954. if @ownerSerial > 0
  1955. begin
  1956. delete from ItemLogs WHERE s_value = @s_value
  1957. UPDATE tbl_inven SET @ownerSColumn = '-1' WHERE Serial = @ownerSerial
  1958.  
  1959. end
  1960. insert into ItemLogs (serial, k_value, s_value, s_column) VALUES(@serial, @k_value, @s_value, 'K58')
  1961.  
  1962. set @error = @@ERROR
  1963. if @error <> 0
  1964. begin
  1965. RAISERROR('>>>POSSIBLE DUPLICATE ITEM<<< ',10,1)
  1966. ROLLBACK TRAN
  1967. end
  1968. end
  1969. end
  1970.  
  1971. if update(k58)
  1972. begin
  1973. SELECT @k_value = k58, @serial = serial FROM Inserted
  1974. if @k_value < 0
  1975. begin
  1976. delete from ItemLogs WHERE s_column = 'K58' AND serial = @serial
  1977. end
  1978. end
  1979.  
  1980. if update(s59)
  1981. begin
  1982. SELECT @serial = serial, @k_value = k59, @s_value = s59 FROM Inserted
  1983.  
  1984. if @s_value > 0
  1985. begin
  1986. SELECT @ownerSerial = serial, @ownerSColumn = s_column FROM ItemLogs WHERE s_value = @s_value
  1987. if @ownerSerial > 0
  1988. begin
  1989. delete from ItemLogs WHERE s_value =
Add Comment
Please, Sign In to add comment
Public Pastes
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!