As you can only have measures generated by the fact table I useually find that it's the measures I need that dictates which tables are Facts and which...

quote:

---

I'm going to agree with Keith. Stop using Access. You've fallen into a trap. Sql Server is not that expensive...

quote:

---

In a real world situation, you would have gotten at least that much from a programmer...you would hope anyway.

---

half the posts we were talking about have now been deleted, so confused .

edwin_fredrick: generally when I'm saying something I mean as a...

quote:

---

If you however reverse the proc like so

blah blah blah

if @@rowcount = 0

return 0

if @@error <>...

... if the procedure is changed in this way 

But it wasn't, and the question clearly stated return rather than output variables, and your...

Like this one:

http://www.sqlservercentral.com/forum/topic.asp?TOPIC_ID=16204&FORUM_ID=131&CAT_ID=11&Topic_Title=MS+Access+versus+SQL+Server&Forum_Title=Microsoft+Access

Keith Henry

DBA/Developer/BI Manager

Try using the crosstab wizard

Keith Henry

DBA/Developer/BI Manager

Yeah. If you're using Access, stop it now. If you need cheap use MSDE. Access should never be used by more than one user at...

PS: and one more thing. Who is going to write this tool then? Any offers?

Keith Henry

DBA/Developer/BI Manager

This would be a very useful tool. We run MSSQL pretty much to its' limit and out there the bits and byte of the storage really do...

quote:

---

I don't know about other people's production databases, but our's NEVER shrink in size, especially leaving > 25% of the file unused...

Site = MS SQL

Forum = Question of the Day

Why the hell would you ask a PL/SQL question?

Keith Henry

DBA/Developer/BI Manager

If you want people to use EM then give them only read rights. Look up SQL server security in BOL

To do it for one view...

quote:

---

I'm running Windows XP, not NT and it's running under my windows account with full administrator rights.

---