mdb Queries

  • Thread starter Thread starter Guest
  • Start date Start date
There's a SQL Server upsizing wizard available from Microsoft if you have a
look around for it. Note that it's not the greatest thing in the world, so
several queries won't be properly dealt with (including any queries that are
dependent on queries that fail).

Also, SQL Server 2000 doesn't support Crosstab queries at all (SQL Server
2005 will, though). If that's a big issue for you, there's a kludge of a
work around using the CASE statement in SQL Server...just browse the web for
"SQL Server" "crosstab", and you should find it.

If you have trouble finding these things, let me know and I'll see if I
can...this isn't the computer I use for all my SQL Server stuff, though, so
I don't have my resources handy.



Rob
 
Yeah, I looked at upsizing. I made the mistake of doing the tables without
the queries a while back. Now I guess I have to put them in a fake mdb with
no tables and up size them. Or I guess I could copy and paste each one into a
view, by hand.
Thanks for the heads up on the crosstab. So far, SQL Server has proven to
slightly less than totally useful.
 
if you're really missign the concept of a crosstab query in sql server 2000;
you can use olap pivotTables.. and it's a
LOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOT faster than sitting around waiting
for your database to churn through a million records

i really really really reccomend than anyone that loves sql but misses
crosstab-- look into olap.. olap is much more powerful than mdb crosstabs
 
I haven't yet had the chance to delve into anything outside basic SQL Server
functionality. Wanna point me in the right direction? Where does one find
OLAP's PivotTables? Will they work with an ADP front-end?



Rob
 
I don't know if ADP offers a direct support for SQL-Server Analysis Service
but as a start, you could install OLAP on your SQL-Server installation and
take a look on any good book on Analysis Services for SQL-Server. In all
cases, couldn't be a bad idea.
 
Back
Top