Wayne West scribed: "It's the only way to be sure that the business rules will be enforced -- put it all in the database. Take a clue-by-four upside the head...

OH, I don't know. Where I'm working right now, I'm basically a "sql developer". I know enough in general about some of the DBA's sql oversight roles, as well as...

Yeah, but the drive magnets in it are probably neodymium magnets (i.e., curiously strong). probably a good idea to trash the platters, though. Why not just a hot oven to...

You'd want to do something like this:

select top 1 t.*

from mytable t join (select min(some_field) first from mytable) f on t.some_field = f.first

or

select top 1 t.*

from mytable t join...

plus, prefixes on object names defeat the UI of various tools (i.e., Enterprise Mgr, isqlw) when looking for specific objects, which is why I tend to abhor prefixes. More specifically,...

yes. there are some DTS dlls that you need to install and register (regsvr32 p:/ath/to/some.dll), but then you can invoke them via VBA after you then register the library.

I'm sorry...

At least at the company I'm working at, Sarb-Ox already is forcing my company to delineate those divisions of responsibility and such already.

OK, I'll invoke the Calendar table that another poster mentioned. In other circles, this is attributed sometimes to Joe Celko, and a "Celko is an Idiot!" flamefest ensues... But in...

...and you're implying that "business" and "intelligence" are often highly correlated together, which most of us would probably argue is not the case, unless you're a CxO/SVP padding your stock...

It is an interesting idea. The problem with it is that unless different fields like names, social security numbers and some random salt are hashed together, then some idiots out...

It's still not as good as TOAD or TOra for Oracle, but it's loads better than Enterprise Mgr. One thing that seems to be missing, though... if you do...

Try saving most of the Access queries in MSQuery queries...

The Excel users might also need to have the exact same ODBC dsn's defined on their computers as the people who...

Yes, if only it could be that big AND be 100-pixels per inch. What would that make that resolution though...8000x4000?

How about car analogies?

"Using Windows is like driving a Model T."

People initially had to be able and willing to change tires in knee-deep mud (bad roads; first pneumatic tires were...

So SS2005 gets a bit closer to functionality (and, in this particular case, syntax) Oracle has been using for some time...