Viewing 15 posts - 16 through 30 (of 37 total)
I have this same problem with a procedure of mine! I have about 12 procedures with the same layout that run on a weekly basis, and one of them returns...
March 8, 2004 at 3:15 pm
I don't see an ISNULL anywhere in your trigger - where are you trying to use one? The proper format is:
ISNULL(value_to_check, value_if_null)
This statement will either return value_to_check if it isn't...
March 4, 2004 at 9:48 am
Upon further thought, I agree with this last statement - I don't think that posting to the forums should contribute points to a person's total at all. It's obvious that...
March 4, 2004 at 9:41 am
I think that a rating system would do the community as a whole some good. Even if the person who's posting has less experience, they'll still know which answer helped...
March 4, 2004 at 8:35 am
I never would have thought to use LIKE ISNULL, but that's a stellar option - definately seems like a better option than the dynamic SQL that I posted earlier. Although...
March 4, 2004 at 8:09 am
This sounds like a dynamic SQL situation. What you may have to do is build the SQL statement on the fly and use an EXEC command to run it. If...
March 3, 2004 at 4:57 pm
In short, it "enables you to eliminate repeated occurrences of key column prefix values". I've not used it before, I've only read about it, but when you have a concatenated...
March 3, 2004 at 4:43 pm
You would do it with a statement like this one:
------------------------------------------
select sum(CASE year
WHEN 2002 THEN sales
ELSE null
END) as y2002,
sum(CASE year
WHEN 2003 THEN sales
ELSE null
END) as y2003,
sum(CASE year
WHEN 2004 THEN sales
ELSE null
END)...
March 3, 2004 at 3:48 pm
Couldn't you use the "AFTER" modifier on the trigger to specify that it runs after the update/insert/delete has happened? I'm not too familiar with triggers, but it seems like...
March 3, 2004 at 3:33 pm
Maybe the points should be limited to one point per thread instead of a two points per post. This might encourage people to leave a quick "That sounds good" on...
March 3, 2004 at 12:03 pm
As far as I know, there is no equivelent index switch for SQL Server that would accomplish this. It's a nice Oracle feature, and I wish I could use it...
March 3, 2004 at 10:59 am
What kind of a server contains this table? Could indexing or otherwise optimizing the table be a better solution than partitioning it? I don't know what the current index configuration...
March 3, 2004 at 10:02 am
My company had the same sort of problem, but the way we resolved it (can't claim it's the most efficient, but it works) is by writing a VB app using...
March 3, 2004 at 9:59 am
It seems like this would actually be a pretty simple database setup, only requiring a few tables. I would recommend against having serparate columns for different semesters, though, for a...
March 3, 2004 at 9:51 am
Maybe the number of followup posts should exclude both author posts and Frank's posts in order to get an accurate count. I think that generating some interest in a topic...
March 3, 2004 at 8:54 am
Viewing 15 posts - 16 through 30 (of 37 total)