Viewing 15 posts - 76 through 90 (of 173 total)
Jeff Moden (1/26/2009)
Cursors violate the whole idea of a database but they continue to "live". 😉
One would think such an idea would be more appropriate describing vermin. Please leave...
January 26, 2009 at 8:48 pm
Gift Peddie (1/26/2009)
Update using the FROM clause violates JOINs are idempotent rule in relational algebra.
If that's true I should think a 'multi-row' trigger suffers the same fate. Perhaps...
January 26, 2009 at 8:35 pm
Lynn Pettis (1/26/2009)
I would also ask what exerience you currently have regarding IT?
I'm ok with Access 🙂
January 26, 2009 at 2:58 pm
GSquared (1/26/2009)
The other thing that can be done is work with non-profit/church/whatever groups as a volunteer.
I tried that with MS. No luck ;):)
January 26, 2009 at 1:35 pm
Jeff Moden (1/26/2009)
January 26, 2009 at 1:29 pm
GSquared (1/23/2009)
An object variable type that allowed table/column/etc names which could...
January 25, 2009 at 4:58 pm
What users here call 'RBAR' is simply a form of redundancy. In certain
situations the system isn't smart enough to use prior information and
starts the same process over and over again....
January 24, 2009 at 8:33 pm
GSquared (1/20/2009)
January 24, 2009 at 7:54 pm
Work smart not hard. Spend more time thinking about the problem and less time coding:)
Feed your data RAC:
Feed your head:
January 19, 2009 at 10:41 pm
Jeff Moden (1/17/2009)
I wonder if you'd do me a favor... I realize it's been about 4 months since the last post, but I need to ask... why did you need...
January 17, 2009 at 9:21 pm
Jeff Moden (1/16/2009)
Heh... Come on folks. "We don need no stinkin' CLR!" 😛 This is a simple problem and it doesn't need a CLR.
The Gartner...
January 17, 2009 at 6:19 pm
Chris (1/12/2009)
Lynn.. I have posted sample data this is the way i need it...
You could use the RAC utility to generate the columns.
Exec Rac
@transform='count(*) as cnt',
@rows='case when Ban>0 then...
January 13, 2009 at 1:10 am
gvsriramakrishna (1/11/2009)
Oops.. there seems to be an error in th SQL query at the over keyword.Incorrect syntax near the keyword 'OVER'.
You should read the words, not just sql code:) I...
January 11, 2009 at 6:51 pm
Jeff Moden (1/10/2009)
So, gvsriramakrishna... any feedback on this?
I think you deserve some:)
I guess Update is ok:) It's conceptually similar to using the rowindicator parameter in Rac which computes a rank...
January 11, 2009 at 6:34 pm
Jeff Moden (12/19/2008)
Heh... Just what you were hoping for, huh, Steve?
That strikes me as an interesting question. I'm not sure if it's the case that right now I don't have...
December 19, 2008 at 6:52 pm
Viewing 15 posts - 76 through 90 (of 173 total)