I have a categories table, and it has a trigger on it. When a change is made to a category, the trigger fires a change on the parent category. By design, the change to the parent should fire a change to the parent of the parent, and so on and so forth... but its not.
Is there a way to make sql...
Actually, I have found an option using a udf that parses the two rows into a third table.. The UDF is fired by a trigger. I like it, it works pretty seamlessly.
Thanks :)
ALFII.com
http://www.alfii.com
---------------------
If this post answered or helped to answer your question, please reply...
Rudy I would like to see a more efficient query.. That's the best I had and I knew it was suffering. I've learned a lot of sql from you over the years.
QofQ's are still so very disappointing, they lack such baseline functions.. Certain string functions for instance and I'd say they've been...
I have a query that I'm trying to run...
InvImages has two fields ImageFile and AutoID.
Products has Name, CatID and Images. The current design is that products can have multiple images.. so in my query I wanted to run this query..
Images is filled with Image IDs..
One product's Images field...
The best way, I guess would to be to cycle through the list and add each unique element to a new list.
<cfset CountryList = quotedvaluelist(getLocations.Country)>
<cfset StatesList = quotedvaluelist(getLocations.State)>
<cfset CitiesList = quotedvaluelist(getLocations.City)>
<cfset...
Thanks a lot guys!
ALFII.com
http://www.alfii.com
---------------------
If this post answered or helped to answer your question, please reply with such so that forum members with a similar question will know to use this advice.
Is there a way, without modifying a table, to find gaps in the primary key... IE... where rows have been deleted, and to select the two rows surrounding it?
So In this table..
ID | Name
---------
1 | John
2 | Jim
4 | Suzi
5 | Donald
7 | Jeffrey
10 | Zach
11 | Kimmy
12 | Bobby
I would...
I have a Cold Fusion web service (CFC) that I wrotefor flash but have been able to deploy in Flash, CF, and PHP, so I know it works..
The data is returned as a cf struct.. and I haven't been able to figure out how to return this struct to VB.. All other languages work fine but I just don't know...
This is aggravating..
I have a sony vaio laptop with crystal clear display.. but the display is a little small... I have an external monitor, keyboard, and mouse.. So I basically want to close the lid on it and use it as a tower.
The trouble is that no resolution shows up perfectly on the...
More on this... Yesterday, when I tried this and had both displaying the same image... the driver for both monitors (in Display Properties >> Settings) was 'Plug N Play on Mobile Intel(R) 915GM/GMS,910 GML Express'. Today, that is #2's driver... #1's is 'Sony Notebook LCD on Mobile Intel(R)...
I have an old VAIO that I'm placing in an office as just a general workhorse... Basically I want to just place it as a tower..
I have the external keyboard mouse and monitor.. and yesterday, everything worked perfect.. but when I restarted, the second monitor stretched the display from the...
This is the finished product, apparently working, but 'd like some opinion
update users
set balance = (ISNULL((select sum(creditamount)
from credits
where creditUserID = users.UserID
and left(CreditDate,11) = left(GetDate(),11)),0))
where userid in (Select...
Alright...
Thanks for the answers so far.. One more question regarding error handling.
@nError = @@ERROR
IF @nError <> 0
BEGIN
IF @@TRANCOUNT > 0
ROLLBACK -- Roll back the transaction if any
EXEC msdb.dbo.sp_send_dbmail
@profile_name = 'Your ProfileName'...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.