I have a similar query that works but this one is not:
SELECT DISTINCT org_location.loc_Name, org_location.*, organization.org_Name
FROM org_location
LEFT JOIN organization ON org_loca...
Hello folks,
Anyone ever come across an error like this:
Application popup: DTSRun.exe - Application Error : The instruction at "0x414e4e54" referenced memory at "0x414e4e54". The memory...
How do I create a dblink in an Oracle 10g database to an Informix database?
Can someone tell me if I can use ntbackup to backup my MSSQL database.
I have an Xml date stored in a Long date type col. in an Oracle(8i) database.
This field may contain more then 32,767 characters.
How can i search sub strings ,using Oracle functions, in thi...
I booted a prod sql server over the weekend that hadn't been restarted for more than a year and a half. I also changed the service to run under a domain account instead of the localsystem acc...
Hi
We're a company of around 50 people. Currently we have no sort of HRIS database to track employee info. does anyone use a cheap (ish) database they can recommned? We don't need to pro...
I have two (sometimes more) processes that sometimes may perform the same operation at the same time. To prevent this, I am writing a "busy" flag as a databse field (using MySQL but may change...
Looking for great reference to Database Star Schema Design/Normalization/Denormalization
Looking for the best internet links
500 points max A grade would give more
My company is embarking on the design of an enterprise-wide solution. A kind of ERP in large machine shop sector. We would like to make a database selection based on several criteria, and then...
When I tried to update a table by using code:
UPDATE G1 SET G1.[EXERCISED SHARES] = (SELECT SUM(E1.[EXERCISED SHARES]) FROM E1 GROUP BY E1.[option number]) INNER JOIN E1 ON G1.ID=E1.ID;
...
okay guys I need a sql query that will trim off the last digit from the value of a column if the length of the string in the column is equal to 12 digits and since theres about 7000 records I ...
Hi i am using following query
select sum(cast(TE.Quantity * TE.Price as numeric(18,2)))
as Price ,sum(cast(TE.SalesTax as numeric(18,2))) SalesTax from Mytable TE
i want third column as sum...
I am getting a message when I use SQL Server Enterprise manager for SLQ Server 7
Has anyone came across this?
I have created an Access Database and I have 3 main tables. There is an insert statement that generates an auto number in the first table, but I would like this value to also be inserted into ...
I have a GIF image and a JPG image. Using Paint Shop Pro-X I've erased the background to transparent but when I insert the image on my Access Form it shows white??? Am I missing something???
1. Are there any JAVA/JSP examples to utilize pagination with DB2 resultsets? I'm working with JSP to display a certain number of pages on a web screen and its my 1st JSP assignment.
My small manufacturing company is using a very old database to do our job costing, and we really need to upgrade or migrate to something new, but I don't know in which direction I should be lo...
Hi,
I am wondering how I go about getting an rdf into filemaker. As it will only import xml it seems.
I have downloaded the file "catalog.rdf" from http://www.gutenberg.org/feeds/
It sa...
Hi all
i am experiencing status Code: 134 unable to process request because the sever resources are busy, this informational message happen frequently the status will cause the job to re...
Question,
I have a list of numbers (around 502) that are in a comma seperated file created by excel, question is this, is there a way to query my database
in a statement like this...
I am writing a script in Perl that verifies existence of tnsnames.ora and then parses it throug to ensure certain records are present. The script will work on multiple Microsoft Windows opera...
Will using DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70
in a subform control's OnExit event save the record on the subform or just the record on the main form?
...
Oracle is not a free software, but why I can download it from the website ?
If that is a DEMO version, what is the limitation ? Number of days ? Functionality ?
Because I read in many tu...
Dear Expert,
I have an oracle sql script where I try and create a materialized view. The syntax is correct, but I get the following oracle error:
"schema Name.viewname" unsupported afte...
