Hi there
I'm currently having trouble with group by clause. Here is my table tbl_History
Partner_ID Paid Date Report_ID
1 40 01.01.2007 ...
Hello Experts, I am creating a SQL query in Crystal Reports to run against a Sybase db. My select statement is
SELECT
ad.line1
case
when en.firm is not NULL then en.firm
else e...
Hallo Experts.
Someone told me once that I should now and then rebuild the index-tables in oracle for god performance.
Is this true and howto do this?
We have an Oracle 8.05 database with 2...
I have two tables in Access that have the exact same columns but different data. I want to query Table A and Table B to find all records with duplicate values in Column A (lets say there are C...
I have a stored procedure (listed at bottom in full) that I am trying to add an IF statement to to allow the code to call the stored procedure to either 'select top x' rows or select all rows ...
I am having trouble getting the top 10 rows in Teradata.
This is been complicated by a couple things:
1. I don't have permissions to create a temporary table.
2. I am using a group by ...
can i have statement like this:
insert into table2
....
..
select (... ,.., , from table1, table3 where table1.id = table3.id)
Thanks a lot for your help
I've created a simple test table with the sql statement:
create table player (PID char(15), Name char(15), Clan char(15), PRIMARY KEY (PID) );
How can I change the primary key from PID ...
I am able to use the Relations link on my ERD diagram that I created in Visio and tell it one-to-many, etc., but how can I get the actual one-to-many and other symbols to show on the actual li...
Hello -
I am attempting to migrate some DTS packages from SQL 2000 to SQL 2005. I have used the wizard and migrated them to a dtsx file and I am attempting to use xp_cmdshell when i run the...
I want to run an update query after a command is clicked on a form. This update query will update all dates to match another date field. What code would I put in to run an update query after...
Hi there! Is it possible to disable transaction logging for a particular query? I have a couple stored procs that do some inserts/deletes from some temp tables that aren't too important - bu...
Hello,
How do I change a user password in DB2? I have the db2admin password but I don't have the password of one of the users.
Thanks
Platform:
W2K SP3
Oracle 8.16
9iAS 1.0.2.2.2a (Apache web server in https, forms / reports server 6i)
Problem:
I keep getting that error listed above, which says: Your connection to...
ORA-19815 :WARNING :DB_RECOVERY_FILE_DEST_SIZE OF 2147483648 BYTES IS 100% USED AND HAS 0 REMAINING BYTES AVAILABLE.
ABOVE MESSAGE COME WHILE I TAKE HOT BACKUP.
PLS DO WRITE ME THE SOLUTI...
Orion here onec again...
can u plze help me 2 solve this error
ORA-01810: format code appears twice
update MF_QA set OFFR_DUE_DT = to_date (to_char(OFFR_DUE_DT,'MM/DD/YYYY')||(substr(OF...
Experts,
Just wonder how to integrate SQL Server 2005 with Visual SourceSafe (VSS)?
Thanks a lot.
Someone completely deleted my SQL Server 7 database. I retrieved the .LDF and .MDF files from a network backup. Now I am trying to attach the database. I have tried this without creating an...
Hi, I am having a problem:
ORA-09817: Write to audit file failed.
Linux Error: 28: No space left on device
ORA-09945: Unable to initialize the audit trail file
Linux Error: 28: No space ...
I'm trying to do a comparison between a field in the database and a field on my data entry form. It contains some new line and return characters. In the text box, those characters are appear...
Dear EE community,
I've tried searching this site and Google for related solutions although I have yet to find one that works for me. So it's just as easy to write a new question I guess.
...
Has Google published details of what their back end Database technology is? Is their database based on a standard RDBMS (Oracle/DB2?) or a proprietry indexing system?
I am working with opt...
How to disable mouse wheel in Access?
Does anyone know how to disable mouse wheel. In Access 97 I have problem: if mouse wheel is turned even once form shows data sequentially at amazing sp...
Hello everyone,
I seem to have gotten myself stuck on a query I am creating and I am hoping someone can help me out. Here is the query I am using:
SELECT Act_Run_Labor_Hrs + Act_Setup...
Is there a way in SQL server to set the default date format to dd/mmm/yyyy ?
