When using IfNull in my SQL, records are ignored
I know my data table has nulls in it. If my select statement doesn’t include those fields, I get hundreds of records. If I include those fields with an IfNull, it skips all but 4 records. Here’s my testing snippet: C/Exec sql C+ DECLARE C1 CURSOR FOR C+ SELECT C+ accountID, C+ ifNull(address,’ ‘) C+ [...]

Answer Question   |  December 24, 2010  12:10 AM
AS/400, AS/400 Records, Data Tables, RPG, SQL

Access 2003 – command button to show query in pivot format
I have a form with a comman button.  I want the user to be brought to a query when they press the button.  The query is built in a pivot table format, but when accessed by the command button, it appears as a datatable instead.  What am I doing wrong?

Answer Question   |  September 28, 2010  2:54 PM
Access 2003, Access query, Data Tables, Pivot tables, VB Code, Visual Basic

Adding column to existing table in a database
When I add column in existing table. it contains null values in older records. it is possible to assign a value when add column so older records are modified with value

Answer Question   |  August 18, 2010  4:59 AM
Data Tables, Database management, Sunrise

INSERT INTO TABLE1 (SELECT * FROM OTHER DB.TABLE1)
INSERT INTO TABLE1 (SELECT * FROM OTHER DB.TABEL1)  

Answer Question   |  July 18, 2010  6:23 AM
Data Tables, Visual Basic

Filter & sort data tables in excel 2007
When I create a table in excel with data from an external data source using MS query, the resultant excel table doesn’t allow me to filter or sort the data (the menu options are greyed out) If I add columns with formulae to the right of my data table, it seems to view the two [...]

Answer Question   |  April 26, 2010  12:59 PM
Data Tables, Excel 2007, filter, MS Query

Large table in ASE 15.0.3
Hello - I’ve got a process that loads 56million rows daily (via bcp) into a table, maintaining this data for 30days.  Our company is too cheap to pay for semantic partitioning so i’m wondering if anyone has any ideas on how to make queries respond in a semi-timely manner.  There’s one date column, and two other [...]

Answer Question   |  March 19, 2010  8:21 PM
Data Tables, Database, Database query

Mysql syntax
Hi Have a table: budget When I try this: MySql: insert into budget values (’Department A’,1,2,200) Department A represents:A Department called A 1 represents: a courseno from table course 2 also represents: a courseno from table course It doesnt work … Any suggestions…. ?

Answer Question   |  November 4, 2009  9:59 PM
Data Tables, MySQL, tables

Effective ways for retrieving millions of records from a table?
I have two tables – [em]Users[/em] and [em]UserAddress[/em] — with 30 million records in each.

Answer Question   |  November 4, 2009  8:48 PM
Data Tables, Microsoft SQL Server, SQL tables

Add a row from DataTable to second DatTable
Hello, I have a DataTable that gets new data in loop, each time the data is changed I want to enter the new row to second DataTable (that in the end of the loop will contain the whole data). Here is my code and my problem is in the end: //ReminderDetail – the DataTable that [...]

Answer Question   |  June 10, 2009  5:05 PM
Data Tables