Tip Bank

DevX - Software Development Resource

Leaving Messages on the Server

Question: I have upgraded from Outlook Express to Outlook 98. Previously I was able to leave messages to a particular e-mail recipient on the server. With Outlook 98 I no

DevX - Software Development Resource

Outer Join Problem

Question: I am having trouble getting the following type of join to work. I have three tables: Application, College_hist, and School_Info. Application has student ID numbers that identify the person

DevX - Software Development Resource

Parameter Setting

Question: I need to know how to write SQL to ask for a date range and run the query on that range. Can you help me? Answer: I think it

DevX - Software Development Resource

Losing Decimal Places While Updating a Column

Question: I have two columns in a table called “bak”: distance, and trig. The distance value is equal to 1/trig. When I perform the following query: update bakset distance =

DevX - Software Development Resource

Doing a GROUP BY Statement

Question: How do I do a “group by” SQL statement? I want to return all rows and columns with ** records. Here is the data sample: columnA columnB columnCAAA 2334

DevX - Software Development Resource

Pulling Values Together from Two Fields

Question: How do I merge two values from separate fields using SQL? An example would be taking the LastName field and placing it before the FirstName field like this: “LastName,

DevX - Software Development Resource

VB5-to-SQL 7.0 Connection Problem

Question: I need your assistance to solve the following: I am using an RDO connection to connect to a SQL 7.0 database, and I am using the server-side cursor technique

DevX - Software Development Resource

Training Management Companies

Question: I am with a large Fortune 500 company looking for a training management solution to produce CBT courses, organize, and report on skill-based courses and instructor-led courses on our

DevX - Software Development Resource

Moving a SQL Database to Another Server

Question: I have a SQL database on our production NT server and need to move the database to another NT server. I used the Database/object transfer in Enterprise Manager to