I think Steve is giving you the right way to "derive" the ultimate structure. Meaning - you may need to do this iteratively, while you determine all of the...

JJ B (11/5/2007)

---

"Pay you now or pay you later." How about pay you never? I work in a place that can't afford real DBAs, not even as occasional...

It sounds like your connection account (what you used to set up the connection) doesn't have write permissions on SQLExpress. It may also be that you have no primary...

My experience tells me that no - it doesn't matter that it's in the "wrong" JOIN statement. It just makes it harder to read later on....

Mike - the result set you're outputting from the stored proc is based on a select somewhere within the SP. If you should simply structure the select statements outputting...

It looks to me that you're not reading up on what you can or cannot do in T-SQL. You're mixing procedural syntax into TransactSQL, which is getting you messed...

I take my doses of reality in short bursts, usually about 1/2 hour after the morning double expresso:).

I think Mr Moulinex (I mean Slicendice - hehe) touches on something, which...

TheSQLGuru (11/5/2007)

---

1) It is a common mistake to think that join clause conditionals and where clause conditionals will equate. But there is a vast difference in where the restriction...

Well actually Ramesh - a derived table IS a sub-query, just not one that is "re-run" for each record in the main table. That's what's called a Correlated sub-query.

And...

Select DISTINCT interview.test where homework=0....

Kevin -

Have you considered simply moving the tables into SQL Server, and modifying the Access front-end to smiply link to those tables? Would be the best of both...

Ewan Hampson (11/5/2007)

---

I think one problem is that guidance for the modern CV always talks about stating your specific (and reasonably recent) "achievements", which too easily gets interpreted as "boast...

I like Ward's analysis of "technical debt", which might help refine Jeff's rule to be Plan now, or pay later (with interest). The road to hell for DBA's and...

Wayne West (11/1/2007)

---

I understand Novell doesn't have this problem, apparently they serialize their time so the clock knows that it's off in regards to jobs and it either speeds up...

Mcloney -

as to your issues with functions... If your references don't match, your clients will have difficulties running certain functions. In other words - if your MDAC versions...