Re: [SQL] Putting an INDEX on a boolean field?

2005-06-18 Thread Erik Aronesty
In my database, the sites table is large, and the usersites table has only a few sites per userid - so it should be looked in first. I'm surprised that I had to juggle my query around (below), rather than trusting the optimizer to figure this out for me. Should I start looking to figure out why

[SQL] datediff script

2004-04-21 Thread Erik Aronesty
This is a not-quite complete implementation of the SY/MS sql datediff. The months_between function can be extrapolated from it as well. I looked for it on forums, etc. and all I found were people complaining about the lack of an example. Please post fixes/changes or a link to a better one... if