Viewing 7 posts - 1 through 7 (of 7 total)
vidya_pande (4/24/2010)
this is awesome support Kingston:-)
yeah awesome, thank you so much again 🙂
Heh... that'll probably get you fired because of how slow it is. It's also really, really bad...
April 25, 2010 at 4:42 am
Kingston Dhasian (4/22/2010)
ard_dicted (4/22/2010)
When I delete a transaction which using item with ID 2,3, and 4Does this mean you are running the query
DELETE FROM DetailTrans WHERE IdItem IN (2,3,4)
I mean...
April 22, 2010 at 8:02 am
Okay.. I will explain it as best as I could..
------
Items
------
IdItem*
ItemName
(Etc)
-----------
Transaction
-----------
IdTrans*
Date
(Etc)
----------
DetailTrans
-----------
IdTrans**
IdItem**
---------
Summary
---------
IdItem1
IdItem2
CountUsedTogether
Note. Summary.CountUsedTogether --> for counting how many times item used together..
The trigger I put is on DetailTrans, so when there is...
April 22, 2010 at 2:14 am
hmm, how about this problem?
i am pairing each id and count how many times they used together...
ID1 ID2 ...
April 21, 2010 at 8:26 am
Kingston Dhasian (4/21/2010)
You can use a simple join to do this
UPDATESWSETcount = count - 1
FROMsomewhere SW
INNER JOIN deleted D ON SW.idsomewhere = D.id
oh just saw your code, thank you so...
April 21, 2010 at 5:16 am
what should i put in where clause?
i tried
where id = @id
and it didnt work too..
i see in some discussion (http://www.bigresource.com/Tracker/Track-ms_sql-Dm8l6gPv/)
that we should use IN syntax, i tried...
April 21, 2010 at 4:34 am
Viewing 7 posts - 1 through 7 (of 7 total)