Search results

Can you explain what is meant by normalizing? The query I am using is ultimately built on tables that use, say, Branch and Area id's ChrisO : Apologies but it seems to not work. I'll try to study the code and see what it's doing, though.

I mean I already have a query that links it all together (Branch and its corresponding Area), but how would I accomplish what I want, here?

Because later on I need to be able to quickly create autofilter criteria for a worksheet where I am exporting different rows to different sheets. Say I have a file, Source.xls, that has the following rows in Col A: Fresno Los Angeles New York City I first create an array of which Areas I am...

Say I have a table like so (Branch, Area column names): California, Los Angeles California, San Francisco California, Fresno Colorado, Denver New York, New York City New York, Buffalo Pennsylvania, Philadelphia And I want to basically convert this table into an array, where something like...

Yeah I have the one table, but now I am concerned about how to properly index it to optimize speed

I have a really, really massive table (over 160 million rows) -- but I want to make some indexes to optimize this thing. I have three columns, User ID (number/int), Badge ID (number/int), and WinDate (Date/Time) There may be duplicate values in each column, but each row is unique in itself...

What kind of Indexes should I make and how? (clustered, nonclustered, xml, spatial etc)

Oh no I imported the tables from Access into SQL Server so they aren't linked (as far as I can tell, anyway) -- now I'm just trying to fuse these 6 tables into 1 now that i don't need to use a bunch of Access backends

They are all unique records, but there is lots of repetition across all three columns I've got User ID, Badge ID, and BadgeDate (Number, Number, and Datetime, respectively) Would I do this: SELECT * INTO AllBadges FROM ( SELECT UserID, BadgeID, WinDate FROM UserBadges1 UNION ALL SELECT...

I managed to install SQL server. I basically have six tables here, now properly under 10 GB in size. How can I combine these into one huge table with proper indexes?

It only seems to support 10 GB -- my tables add up to like 15 GB, and the SQL Server software isn't installing properly

What I mean is that I have be1.mdb, be2, be3, etc, with one table each. I have a frontend, fe.db, where I plan to have a massive union query that pulls from all the backend tables, but the ultimate result should be like 250 million records and somewhere around 17 gb in size. My question is if...

Is this possible? For a personal project I have about 250 million records worth of data, and I am inserting them into separate backends (about 10 of them) because each Access backend has a 2 GB limit. But in my frontend, if I were to do operations on the aggregate union of all these backend...

Okay so what I am trying to do: Export the entire query to one excel file and then, from that excel file, export rows into different files based on a row condition. This way I don't have to run the SQL multiple times. For instance, say I have this Excel output: (columns A, B, C named Branch...

This is a wonderful start but it's unfortunately quite slow for my use. This code requires that the query be executed for every Branch, which can be slow if the underlying query/table is huge. I'd ideally like to only execute once and then start chop-chop-chopping away from that.

Thanks for the link! I'll have to check this out and see how it works.

Say I have a query and one of the fields is State. How would I easily export this query into broken-up Excel files? For instance, one file containing every record where state="Atlanta," one where state="California," etc?

I mean it may get to that point where I just have to do it manually... there are so many databases, though, so I really didn't want to have to do that.

Using Citrix. And yes, they just installed Access but I think it's the wrong version (I was using version 12, while only version 11 is available on the reference list). Updating the links is fine as long as I can mass-automate it. For instance, be able to open up all my databases via a code...

Still having trouble with this if anyone is kind enough to shed some light! Thanks