Whether it is possible to pass a parameter for a procedure , so that inside the procedure body i will sort based using the parameter ( using order by Clause ) , becoz in many reports procedures , f...
http://www.experts-exchange.com/Database/Miscellaneous/Q_20573880.html
Zones:
DatabasesDate Answered: 02/19/2004 Rating: 7.0 Views: 0
Help,
I need to know if there is a command that will tell oracle to disregard the rest of an sql statement, I know the -- command tells oracle the disregard
the rest of a line, is there ...
http://www.experts-exchange.com/Database/Oracle/Q_22069798.html
Zones:
OracleDate Answered: 11/22/2006 Rating: 9.4 Views: 0
We have a single denormalized table with a lot of blank fields data..
We'd like to generate a report listing all the distict categories (MOE_Code) and the number of blank InternalValue records for...
http://www.experts-exchange.com/Programming/Languages/SQL_Syntax/Q_24380153.html
Zones:
SQL SyntaxDate Answered: 05/05/2009 Rating: 9.0 Views: 0
I have SQL code where the field [Category2] below displays a 1 a 2 or a 3. What I would like is to display is a more clear description of each. Ex: Test1, Test2 or Test3.
How do I do that?
WHEN...
http://www.experts-exchange.com/Programming/Languages/SQL_Syntax/Q_24651542.html
Zones:
SQL SyntaxDate Answered: 08/13/2009 Rating: 8.4 Views: 0
Can the code below be expressed in plain SQL?
if ( numberVariable > 0 && numberVariable <= 1000 ) {
letterVariable = 'A';
} else if ( numberVariable > 1000 && numberVariable < 2000 ) {
...
http://www.experts-exchange.com/Database/Miscellaneous/Q_20386499.html
Zones:
DatabasesDate Answered: 09/10/2003 Rating: 7.2 Views: 0
Hi all,
I have just recently decided to upgrade my Database from Access 2000 to SQL Server 2000.
But before updating I want to know what I will need to change in my code..... Will it be ...
http://www.experts-exchange.com/Programming/Languages/Visual_Basic/VB_DB/Q_21087966.html
Zones:
VB DBDate Answered: 08/11/2004 Rating: 7.6 Views: 0
How do I convert this select statement into VB Code in Access.
SqlStr = “SELECT OrderDetails.PartNumber, Sum(OrderDetails.Quantity) AS SumOfQuantity
FROM OrderDetails
GROUP BY OrderDetails.Par...
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_21101252.html
Zones:
MS AccessDate Answered: 12/13/2004 Rating: 8.0 Views: 0
This is a SQL question, but it is in my asp code, so I will post it here.
In my asp code, an include file is called to insert rows into the database. A new row has been added to this table, the va...
http://www.experts-exchange.com/Database/Oracle/Q_21174627.html
Zones:
OracleDate Answered: 10/20/2004 Rating: 7.6 Views: 0
What does it mean when asked "Is all code inline sql in your application?" I am building a VB.NET application that stores into MS Access, and has not queries.
http://www.experts-exchange.com/Programming/Languages/.NET/Q_21419073.html
Zones:
.NETDate Answered: 05/10/2005 Rating: 9.8 Views: 0
I have problem with this query the column calendar is a datetime field how do i modify this query?
select calendar_dt , calendar_yr , calendar_mth , calendar_dy
, ( case ( calendar_dt % ...
http://www.experts-exchange.com/Database/Miscellaneous/Q_21422054.html
Zones:
DatabasesDate Answered: 05/12/2005 Rating: 9.0 Views: 0
