Scenerio, I have 100 records. From the stored proc (SQL 2000), I want to pull 10 records at a time in a date order. I want to mark these records so they are not pulled a second time. Th...
I need to be able to determine the percent of growth or decline from one year to the next. I have a group based on year and a summary field for the figure that I am totaling. How do I get th...
Hi,
Please kindly assist how can we have a nested case statement.
i.e.
select case when Col > 1 then 'Greater' else case Col =2 then 'Equal' else 'Less' end
Thanks.
In ODBC Administrator, when I try to configure an existing data source that is using the Microsoft Access Driver, I get the following message:
"The setup routines for the Microsoft Access D...
I have a Business Objects *.REP file with multiple queries I need to look at. The problem is I don't have Business Objects. Is there a viewer, or some other method whereby I could view the *...
I need the code in Teradata that I would place in my select statement that would take the first four digits of a column that is formated like this:
2005-02-02
I also will need the code ...
Hi:
Does anyone have a good tutorial on Data Flow Diagrams?
I am working on a problem in which I have to contruct a level 1 DFD.
Hi,
I'm trying to pull some data from active directory, but I can't figure out what the field names are that I'm looking for. The person who originally set up our active directory is no lo...
Hi,
I have a customer table, it has one DATETIME field called "REGISTERDATE".
I want to select all data which has REGISTERDATE before March 31, 2005.
So, REGISTERDATE = April 1, 2005 ...
What is the difference between oracle clause "Exists" and "in "
hi friends
How to convert a date into dd/mm/yyyy fashion directly through SQL.
i know the functions day,month,year.
but is there any other format function which can directly give me a date ...
I am testing a simple code using Dynamic Cursor. But it gives this run time error.
SQL> @Tr1.sql
WHERE STATUS IN ('I','N')
*
ERROR at line 34:
ORA-06550: line 34...
Hi,
I have Linux machine (Debian) that runs several databases.
when I doing "du -h /var/lib/mysql" I see that some of my database direcories have big logs files (log.MYD).
How can I fl...
I have two almost similiar tables in sql server. I want to run a query to compare those two tables and to find out those rows that are not common. here are the columns for the two tables
Ta...
Hello everyone.
I'm a newbie here...so go easy on me. I have the following code in a .cmd file ( sdv.cmd ). I run it from a command prompt like this c:\sdv.cmd >h:\projects\sdv.txt. It r...
I have a number of programs that will not connect to the internet. I have a new computer running Win2K Pro, no firewall and a dial-up internet connection. My filesharing programs, Kazaalite (w...
How to change the increment value of an identity column. Current values for seed and increment is 1,1. Need to change this value to 1000,10.
Hi all,
i have a rather urgent problem with gathering statistics from a sql server table.
I would need to gather the median and the interquartile range for the records in the table that f...
Is there a way in SQL server to set the default date format to dd/mmm/yyyy ?
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 am looking for a best practice method for desiginng a social networking database schema similar to linked in. Your direction would be greatly appreciated
experts, i'm in need of urgent help
users are getting this error when connecting to the database
ORA-00257: Archiver error. Connect internal only, until freed
there is plenty of room on b...
I have a problem in a client application which began occurring after an Oracle database installed Oracle 8.1.7. Once the software installation has completed, to configure the Oracle Net8 clie...
How can I insert PDF file into DB2 BLOB field using PHP and SQL?
Hi,
I need to import a text file (fixed-length) into the table.
I have created a DTS package to automate the process, but now i want to do it programmatically from the web application.
...
