front end tools
Using multiple tools is an option, however, if you are a smaller company or the warehouse is just starting out, I would recommend MS SQL Server 2008. This gives you all of the front end tools in one bundle, and is much more affordable than some of the other enterprise class tools like Oracle, SAS, [...]

View Answer   |  April 12, 2009  3:16 PM
Data warehouses, Data warehousing applications, Microsoft Access, OLAP/OLTP

Trying to learn – How to filter dates…
There are many ways to do that anyway you may try with a DATE BETWEEN like <b>SELECT * WHERE MYDTFIELD BETWEEN #01/01/2009# AND #02/01/2009#</b> Another way to improve performance is to add an index or multiple indexes. If you often use multiple fields in your query, create an index that groups those fields together. You [...]

View Answer   |  April 11, 2009  6:08 PM
Access Database, Access Database Filters, Access Database Format, Microsoft Access

VB6 retrieving MSAccess all records in VB6 ComboBox
Please provide a little more information: - Do you know how to connect to the database ? are you able to do it ? - Do you know how to retrieve data from the database ? - Are you going to use a data control or do you want to do this programmatically ? Please [...]

View Answer   |  April 11, 2009  12:40 PM
ComboBox, Microsoft Access, Microsoft Access ComboBox, VB 6, VB 6.0, Visual Basic

query function that results in latest date
Did you try a <b>SELECT MAX(MyDateField) </b> ? ———- Something like this: select *, (select max(date) from second_tab as st where st.address=ft.address) from first_tab as ft

View Answer   |  April 11, 2009  8:32 AM
Database

Where to place the tempdb log file?
This depends on the kind of load that you will be putting the tempdb database under. If you are using all very small transactions then you won’t get much benefit from putting it on it’s own drive. However if you are doing lots of large transactions and moving lots of data into the tempdb at [...]

View Answer   |  April 11, 2009  6:56 AM
MDF, NDF, SQL Server, TempDB

Looping,Array On Procedure MYSQL
<pre>SELECT comb FROM ( SELECT model, concat( substring( model, a, 1 ) , substring( model, b, 1 ) , substring( model, c, 1 ) ) comb FROM ( SELECT ’123′ AS model )X CROSS JOIN ( SELECT 1 a UNION ALL SELECT 2 UNION ALL SELECT 3 )fst CROSS JOIN ( SELECT 1 b UNION [...]

View Answer   |  April 10, 2009  9:34 PM
MySQL, MySQL Stored Procedures

implement large database application in network environment
Know your requirements and find the solution that best fills those requirements. We may be able to give you some suggestions if you provide more details of your requirements and systems.

View Answer   |  April 10, 2009  7:40 PM
Database, Database approach, Database architectures

design a strategy for implementing various applications in one database
There are many ways to make sure your database is (almost) conflict-free. It doesn’t matter how many applications use the database, it’s more how many transactions are running against it and what are these transactions doing. So to reduce contention in the database you should follow few rules: * Transactions as short as possible * [...]

View Answer   |  April 10, 2009  4:11 PM
Database, Database administration, Database approach, Database archiving, Database Storage

Access 2003, calculating dates
These are the formulas where B1 is the DateReceived field and the rest are one row below.: DateReceived: 5/2/08 DueRO: =DATE(YEAR(B1),MONTH(B1)+5,DAY(B1)) ReportDueFFC: =DATE(YEAR(B2),2+MONTH(B2),1)-1 DaysLate: =B3-NOW() ———- DueRO: =DateAdd(“m”;5;[DateReceived]) ReportDueFFC: =DateAdd(“d”;-Day(DateAdd(“m”;1;DateAdd(“m”;6;[DateReceived])));DateAdd(“m”;1;DateAdd(“m”;6;[dateReceived]))) DaysLate: =DateDiff(“d”;[ReportDueFFC];Date())

View Answer   |  April 9, 2009  7:25 PM
Access 2003, calculating dates

BULK COLLECT and FORALL in PL/SQL
I found the answer on my own and here is the code I wrote: -- ts_to_td.sql -- -- This script is called by Q3.sql -- and runs after the scripts: -- 1.) ts_insert_table.sql - creates the TS_INSERT_TABLE -- and its index; -- 2.) ts_update_table.sql - creates the TS_UPDATE_TABLE -- and its index. -- create or [...]

View Answer   |  April 19, 2013  8:04 AM
BULK COLLECT statement, FORALL statement, Oracle PL/SQL, PL/SQL

Database connection with OLE DB
To update the backend database you need to run the INSERT commands from your program. It works just the same as connecting to the database and doing a SELECT; just change the SELECT statement to your INSERT statement.

View Answer   |  April 9, 2009  7:34 AM
Database connectivity, Database programming, Object Linking and Embedding, OLE, OLE DB

Microsoft Access Date
Let me update for clarification. I am following the example at <a href=”http://www.databasedev.co.uk/report_date_parameters.html”>http://www.databasedev.co.uk/report_date_parameters.html</a> I have my user date entry fields on the same page as my records. I have been able to fix my Today button by switching ‘Date’ to ‘Now’ The question is, How do I change the others (Week and Month) to reflect [...]

View Answer   |  April 8, 2009  6:57 PM
Access 2003, Access Functions, Microsoft Access

Database Repository
I’m not pretty sure that I understood your question but I’ll try and do my best. If you’re talking about ASP and database a good place to start is <a href=”http://www.asp101.com/samples/index.asp”>Asp101</a>. If instead you’re talking about a pure SQL tutorial you can refer to <a href=”http://www.w3schools.com/sql/”>W3Schools</a> ————————— You can try an open source database called [...]

View Answer   |  April 8, 2009  2:17 AM
Database, Functional databases

Do all versions of Microsoft SQL Server 2005 support database mirroring?
Database mirroring is supported only in Standard (with some limitations) and Enterprise editions. Have a look at the following page: <a href=”http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx?PHPSESSID=0324345d45ef1bf1f764044e03584cd0″>SQL Server 2005 Features Comparison</a>

View Answer   |  April 8, 2009  12:21 AM
Database mirroring, SQL Server 2005, SQL Server Database Mirroring

Bundling MySQL Community Edition
Distribute it shouldn’t be a problem but if your software is making some kind of business I suggest you to <a href=”http://www.mysql.com/about/contact/”>contact them</a>

View Answer   |  April 7, 2009  1:59 PM
GPL, MySQL, MySQL Community Edition, MySQL License, Open source software

Microsoft Access 1997 emailing
You will need a third party PDF generation tool for this (with Access 97, you’d normally use a PDF printer). In addition, you’ll need amend the email generation routine in order to save the pdf at a temporary location before sending it out as an attachement. hope this helps!

View Answer   |  April 7, 2009  12:24 PM
Access 1997, Microsoft Access, Microsoft Access 1997

Which multimedia database can be used with VB.NET
You can use SQL Express or MySQL seen that these are the most frequently used ones and support images but I suggest you the Microsoft one. For connection try and Google it or refer to <a href=”http://www.homeandlearn.co.uk/NET/nets12p4.html”>this simple tutorial</a>.

View Answer   |  April 7, 2009  12:22 PM
Application development, Image databases, Multimedia database, VB.NET, Visual Basic .NET

rdbms and dbms
You can find an <a href=”http://itknowledgeexchange.techtarget.com/itanswers/comparision-of-dbms-and-rdbms/”>answer here</a>

View Answer   |  April 6, 2009  7:34 PM
DBMS, Oracle 9i, RDBMS

Need help with this Oracle Query
I’m not sure if I understood correctly the logic/meaning of the desired output. Could you please explain it, with words ? How exactly do you identify what is the OUT record for a given IN record ? what is the criteria ? I’m guessing that a step_id=71 means IN, and a step_id=73 means OUT, and [...]

View Answer   |  April 6, 2009  2:39 AM
Oracle queries, Oracle Query, Query optimization

How do I write a SQL statement to get all data from a table called subscrib?
SELECT * FROM subscrib;

View Answer   |  April 6, 2009  1:42 AM
SELECT statement, SQL, SQL queries, SQL statements