|
I have a script that needs to extract data temporarily to do extra operations on it, but then doesn't need to store it any further after the script has run. I currently have the data in question in a series of temporary local tables (CREATE TABLE #table...
Started by Margaret on
, 6 posts
by 6 people.
Answer Snippets (Read the full thread at stackoverflow):
This is using SQL Server, I am not sure how consistent the different... .
AFAIK all the tables are treated the same on disk, they just happen to go but temp tables reside in the tempdb, which is stored on disk.
Creating the temporary table.
|
|
I'm working on a project which is similar in nature to website visitor analysis. It will be used by 100s of websites with average of 10,000s to 100,000s page views a day each so the data amount will be very large.
Should I use a single table with websiteid...
Started by Nir on
, 6 posts
by 6 people.
Answer Snippets (Read the full thread at stackoverflow):
You could use MySQL's MERGE storage engine to do SELECTs across the tables broken a huge table into many....
However if you write enough scripting you can do it with multiple tables.
All websites having multiple tables is a pain.
|
|
I have two tables that have the exact same structure.
Table MasterList Acct_id(9) Name (25) Address (35) City(15) State(2) ZipCode(5)
and
Table NewMasterList Acct_id(9) Name (25) Address (35) City(15) State(2) ZipCode(5)
I need a query that will display...
Started by Keniwan on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
Assuming acct_ID is the primary key:
SELECT COALESCE(ml.acct_ID, nml.acct_ID) AS AccountID , COALESCE(ml.name, nml.name) AS Name FROM MasterList ml FULL OUTER JOIN NewMasterList nml ON nml.Acct_ID=ml.Acct_ID WHERE nml.acct_ID IS NULL OR ml.acct_ID IS ... .
|
Ask your Facebook Friends
|
I am joining three tables (performing a full outer join) so that I can retrieve all the records from all the tables. Problem that I am facing is with the order in which I join tables.
Table Information
(1) If I join tables in TABLE1, TABLE2, TABLE3 sequence...
Started by MOZILLA on
, 4 posts
by 4 people.
Answer Snippets (Read the full thread at stackoverflow):
What you need is to add an additional match condition .
Can use as many tables as you need.
|
|
Hi, I have a fairly huge database with a master table with a single column GUID (custom GUID like algorithm) as primary key, and 8 child tables that have foreign key relationships with this GUID column. All the tables have approximately 3-8 million records...
Answer Snippets (Read the full thread at stackoverflow):
This should improve the performance of the change the tables to modify the old value to the....
This can the tables and recreate after you are done.
The updates of the child tables in batches (one reason not to use cascading updates).
|
|
I want to create a table that stores values from two different tables;
From table 1: cust_id (varchar2), invoice_amt (float)
From table 2: cust_id (from table 1), payment_date
My table should have 3 fields:
cust_id, invoice_amt, payment_date
I tried the...
Started by novice on
, 4 posts
by 4 people.
Answer Snippets (Read the full thread at stackoverflow):
The underlying tables as well as the view)..
|
|
What is the best way to export data from multiple tables in MySQL. I'm basically working with product details. Say a product has 150 attributes of data. How can I export that in a single row and then export it to a flat file in CSV or tabdelimited format...
Answer Snippets (Read the full thread at stackoverflow):
It is a bit more difficult to create the queries as all the trigger, which is joining several... .
You should be able to come down to 4-6 tables (2-3 entity tables with their attributes).
Extensible, and reduce how many tables you need.
|
|
Hi folks
I have a situation where i have 20 Access databases. Each has the same 15 tables, but with different data. (The name and schema is identical for each table across the 20 databases).
I want to make a new database with the same structure, and populate...
Started by Max Williams on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
To make it shorter I'll call your 20 databases like... .
Basic sql would be a "insert into select" statement.
With that you can use a GUI and wizards to transfer the data .
If you have SQL server available you could use SQL Server Integration Services (SSIS) .
|
|
The university I work at uses Oracle for the database system. We currently have programs we run at night to download what we need into some local Access tables for our testing needs. Access is getting to small for this now and we need something bigger...
Started by Clint Davis on
, 4 posts
by 4 people.
Answer Snippets (Read the full thread at stackoverflow):
Could you just copy the Oracle tables and then set them up as linked tables in MS Access? This way.
|
|
I'm attempting to create a contacts application that has two main entities - person and company. A person can have many emails, numbers, and addresses. A company can also have many emails, numbers, and addresses. I'm trying to determine the proper design...
Started by Amit on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
You then Create Person.
And Entity type, then you can have your Address, Email tables link to that one.
|
