Viewing 15 posts - 271 through 285 (of 530 total)
Seems like near impossible to do. The only way you could enforce this, is by adding a 'BOM level' to the product table.
E.g. Car = 1, Wheel = 2, Hubcap...
June 24, 2003 at 4:35 am
I'm afraid we're not going to solve your problem without any additional input.
Can you post some DDL and sample data on this problem...
June 23, 2003 at 7:28 am
Same here, I would go for code reuse IF (and only if) the performance remains acceptable.
Maybe, an in-between approach, would be to create a view for each 'codename' you have....
June 20, 2003 at 7:39 am
Can't see a reason for this behaviour. Maybe somewhere down the line, one of the outer joins gets 'converted' to a cross join?
I would suggest advancing step by step, adding...
June 20, 2003 at 7:33 am
Mike,
You certainly have to add the ID values to a temporary table. A previous thread (not so long ago) talked about performance problems with a huge IN clause.
If possibly, I...
June 20, 2003 at 2:39 am
From the Sybase site.
quote:
SARG (search argument) the query's qualifying clause(s).
In other words, the WHERE...
June 19, 2003 at 8:19 am
Logic like this :
DECLARE @strToCheck varchar(100)
DECLARE @iPos int
SELECT @strToCheck = column_name FROM ...
WHILE LEN(@strToCheck) > 0
SET @iPos = CHARINDEX(CHR(10), @strToCheck)
--Account...
June 17, 2003 at 8:17 am
I think most important names have been dropped in the thread. Cognos and BusinessObjects are big players in BI (and reporting).
Both suites offer a host of functionality, besides pure reporting,...
June 17, 2003 at 7:41 am
Dalecorey,
Glad we agree on the outcome of this discussion. And yes, you are right that both intelligence AND logic are needed for a programmer.
Does this thread qualify for the longest...
June 17, 2003 at 7:10 am
Frank,
Been there .. done that. But ended up with a horrible application that was in no way maintainable. One simple example : one function with about 1500 lines of code,...
June 17, 2003 at 5:57 am
dalecorey,
I am still struggling with your interpretation for the need of intelligence.
Obviously, a programmer needs to be intelligent in the way that he can perform the analysis (and in heaps...
June 17, 2003 at 12:38 am
quote:
The good thing here is it is the other guy it messed up. If you find serious lack of quality in an...
June 16, 2003 at 5:58 am
Seems to be turning into an endless discussion here...
Does everyone more or less see a developper as being someone who :
1. Is able to translate requirements into a design.
2. Is...
June 16, 2003 at 5:06 am
Seems like we're thinking the same thing...
quote:
In university they teach us in data structure courses that app1 is the one and only.
June 16, 2003 at 2:07 am
Frank,
Never thought about it that way...
One question though ...
What is the best program :
1. a perfectly written program, written with the best design methodology, with optimal performance, making use of...
June 16, 2003 at 1:20 am
Viewing 15 posts - 271 through 285 (of 530 total)