Combined Address
I have one tblContacts that has "Home" and "Work" address included within it, I also have an option button 1="Work" and 2="Home". I need to prepare a mailling report, but only for the defaut address.Someone suggested that I create a calculated field. I tried this but all that it is doing is pulling...
Answer Question
| May 12 2008 5:29 PM GMT
| asked by
Thuzinec
SQL, Query, Microsoft Access
date functions using Oracle
Hi,I need to display the benefits paid for the current year using SQl,but the year is filtered using the year which is previous year for the current year.the date is in 'yyyymm' format.ex,select year_mnth,benefits_paidfrom tablenamewhere year_mnth in ('200603','200602','200601') note:it is in...
View Answer
| May 12 2008 6:59 AM GMT
| asked by
Maha
Oracle, Oracle SQL, SQL
Error when executing RUNSQLSTM from CL program
I am trying to use the RUNSQLSTM command. I get the error message "statement not allowed"Not really trying anything fancy.In CL program RUNSQLSTM SRCFILE(jwe/QCLSRC) SRCMBR(SQL1) + COMMIT(*NONE) In SQL1 I haveSELECT mstid, ...
View Answer
| May 6 2008 3:32 PM GMT
| asked by
Tcwalls
AS/400, SQL, RUNSQLSTM
SQL DB2 COBOL date reformatting
Hi and thanks in advance,I want to use DB2 SQL in COBOL to reformat a date from CCYY-MM-DD to MM-DD-YY. What is the simplest and most efficient way to do this?Christy
View Answer
| May 6 2008 3:26 PM GMT
| asked by
Ctrevino
COBOL, SQL, DB2
Embedded SQL in a Cobol program using a sub-select in the select clause
The following works fine in SQLPLUS: SELECT SOVLCUR_PIDM INTO :STDN-PIDM FROM SOVLCUR WHERE SOVLCUR_PIDM = :HOLD-STU-PIDM AND SOVLCUR_LEVL_CODE = 'UG' AND SOVLCUR_LMOD_CODE = ...
View Answer
| May 5 2008 6:58 PM GMT
| asked by
Warpmail
COBOL, Embedded SQL, SQLPlus
Linux vs Microsoft
what is the Linux equivalent for SQL Server? Also, what is the difference between the two?
View Answer
| May 5 2008 8:47 AM GMT
| asked by
Jaco
SQL, Linux, Linux databases
SQL linking to database in XP
First of all, I tried to create an ODBC connection to a local SQL database.It successfully created but it does not show up. I know it is there becauseI can link to it via Access or if I try to create the same one again, ittells me it is already there and if I want to overwrite it.In trying to...
View Answer
| May 2 2008 2:33 PM GMT
| asked by
Bigblew
Windows XP, SQL, ODBC
What are the pros and cons for log shipping vs. replication in SQL Server? When is one favored over the other?
What are the pros and cons for log shipping vs. replication in SQL Server? When is one favored over the other?
View Answer
| Apr 30 2008 5:21 PM GMT
| asked by
SQL Server Ask the Experts
SQL Server availability, SQL Server replication, Log Shipping
sql query
from this table i have to take those records that have common gridcode and then from these records i have to store the records having maximum area in another table...gridcode state area13013 rajasthan 5000013013 gujarat 4500013014 rajasthan 2500013014 gujarat 25000
View Answer
| Apr 30 2008 5:50 AM GMT
| asked by
Aanshi123
SQL, SQL queries
update a field from a file with a field from a selection from two files
Hi!When I try this:update fileD d set d.value = (select c.value from (select b.key, b.value from fileB b where b.key not in (select a.key from fileA a)) c where d.key = c.key)I get the message "Null values not allowed in column or variable VALUE."on the other hand, when I do this selection:(select...
View Answer
| Apr 29 2008 11:03 AM GMT
| asked by
Mr.
Update, SELECT, SQL
MOSS 2007 Server Installation and configuration problem
Need to know how I can get SharePoint to recognize a second partitioned drive on the same server where I've installed SQL server 2005 and want the SharePoint configuration database and everything held.Server (Mars) is set up with local C drive where I've installed Server 2003 OS. Then I have...
View Answer
| Apr 28 2008 3:09 PM GMT
| asked by
Mpolak27
SharePoint 2007, SQL, Installation
Critical error in event logs
Why do I get this message; "SQLVDI: Loc=CVDS::Cleanup. Desc=Release(ClientAliveMutex). ErrorCode=(288)Attempt to release mutex not owned by caller."?
View Answer
| Apr 28 2008 2:24 PM GMT
| asked by
Dbs13790
SQL, SQL Express, SBS 2003
Sql subquery
how can we use sql subquery in jsp?i am trying to write it but it gives me an error of missing operand?
View Answer
| Apr 28 2008 1:53 PM GMT
| asked by
Shruti
SQL, JSP, Web development
Moving a SQL database from one host to another
I need to help out in a move of a site coded in ASP/VBScript from one host we're having major problems with to another host that has been highly reliable for us. They both offer all the same features needed for this site, but we don't know how to move the SQL database along with the site.Can anyone...
View Answer
| Apr 28 2008 2:54 AM GMT
| asked by
Kwoodall
SQL, ASP, SQL database
IS It Possible to create Recusrive function using sql udf or stored procedures?
Hii have a scenario of n level tree structure.in order to traverse to my desired node i am using Recursive function until i get my desired node in my vb code but i am getting a performance issue.SO i reckon that this performance can be overcome by using sql udf or stored procedure.If so please...
View Answer
| Apr 26 2008 7:38 AM GMT
| asked by
Balajisairam
Recurive function, SQL UDF, VB
Coding for library in stored procedures
A reader wrote in with this SQL stored procedure question. Our AS/400 experts weren't as familiar with this topic. So, any SQL experts out there with an answer?Do I have to hard code the library in my stored procedure? I have my procedures in sqltblsrc and have to edit the library to create the...
Answer Question
| Apr 25 2008 3:38 PM GMT
| asked by
Leah Rosin
SQL stored procedure, SQL
SQL Error: Conversion of char data type to a datetime data type resulted in an out of range datetime value
A reader wrote in with this question, but it's not one that our AS/400 experts could answer. So any Microsoft SQL experts out there, please chime in:I am an SQL novice.......I am getting the following error message:[Microsoft][ODBC SQL Server Driver][SQLServer] The...
Answer Question
| Apr 25 2008 3:34 PM GMT
| asked by
Leah Rosin
SQL, DateTime
SQL 2005 error code = 80004003: Invalid Pointer
After (successfully???) attaching a database to a VM Ware instance of MS SQL Server 2005 and setting what appear to be appropriate access to the SQL server itself and the database involved, and making sure that sharing and security are properly set on the SQL server, I am receiving the following...
View Answer
| Apr 24 2008 9:21 PM GMT
| asked by
Pressler2904
Database, SQL, Servers
String Aggregate Function
I need a report that provides an aggregate of a string column - in this case a concatenation of the values in a comma separated string. There is no such DB2 aggregate function that does this. A stored procedure (or possibly a customer aggregate function?) seems the only likely way to accomplish...
Answer Question
| Apr 23 2008 7:39 PM GMT
| asked by
Mgemmill
AS/400, DB2/400, SQL
SQL 2005 Active/Active/Passive
We have a SQL cluster server running with SQL 2005 Enterprise Edition SP2 on Windows 2003 Enterprise Edition.Currently the cluster has 2 nodes with Active/Active. Now I need to add a new node as a Passive node. So after I have done it, the cluster will be a Active/Active/Passive cluster. Because...
View Answer
| Apr 23 2008 6:23 PM GMT
| asked by
Kjrichmond
SQL, SQL Server clustering, SQL Server 2005


