Viewing 15 posts - 301 through 315 (of 530 total)
One (additional) way to avoid trigger recursion is using an INSTEAD OF trigger. You probably will have to rewrite your trigger since the original update will not be executed...
June 10, 2003 at 1:14 am
You could use a JDBC driver. Don't know if any ODBC-like drivers exist on Unix.
June 10, 2003 at 1:06 am
I'm not going to write a query here. Just some ideas. If you need more help, I'm glad to help you out.
Your query will look something like
June 6, 2003 at 1:54 am
Yep, your analysis is correct.
There are two ways depending on the data.
1. Is description and budget_version always the same for one project?
In this case, you can use
June 6, 2003 at 1:47 am
Try this ... (without the INSERT INTO)
SELECT name, descrip, version
FROM projects_600
GROUP BY name, descrip, version
UNION
SELECT name,...
June 5, 2003 at 9:44 am
Jeremy, your query is correct, I think. If I'm not mistaking, using NOT IN should be avoided because of performance issues. I'm sure you can find some reference in older...
June 5, 2003 at 7:55 am
And here's the complete query again, with matching brackets. Sorry for that...
SELECT T3.groupid FROM
(SELECT groupid FROM #GROUP
...
June 5, 2003 at 5:51 am
Here goes nothing ...
We want to retrieve all groupid's from the 'receiving' user that comply with the requiremens.
SELECT T3.groupid FROM
The main FROM clause... A subquery to...
June 5, 2003 at 5:48 am
OK. Changed it a bit.
First use the previous query, but just get all 'rows' where a null is present and group by groupid of the person that receives the share.
Now...
June 5, 2003 at 4:20 am
Use the code tags... You can insert them using the hash key button on the 'Format' bar over the message box.
June 5, 2003 at 1:44 am
Are you sure the Server is 'busy', or do you have a number of locks on the data?
In the first case, I'm afraid you cannot do a lot, besides from...
June 4, 2003 at 7:27 am
I am not sure I get the complete picture, but I'll give it a shot anyway.
Isn't it possible to use an self full outer join (or is it full outer...
June 4, 2003 at 4:23 am
Just a wild guess here...
Active Directory allows you to 'publish' the 'location' of an 'entity' on the network. Such an entity can be a user or a computer, but it...
June 3, 2003 at 6:12 am
I don't see a solution to your problem in a single query. The problem lies in the assignment of a unique Trip_ID in the new table.
However, you could do it...
June 3, 2003 at 4:14 am
Trying to build it from scratch :
1. Start from the DAY table that should contain an entry for each day.
2. Adding the STORE and PRODUCT table. You want to have...
May 28, 2003 at 3:44 am
Viewing 15 posts - 301 through 315 (of 530 total)