Well, if you happen to be using Sql Server you can do that sort of thing in T-Sql. In Oracle, you can also accomplish the same thing using pl/sql. Either way i'd do it in a stored procedure.<BR ...

As a bonus, the following tools aren't limited to stored procedures -- they'll work with any SQL Select statement. Assuming that your stored procedure is just returning an integer result (for example, ...

Read this SQL tutorial to learn when to use SELECT, JOIN, subselects and UNION to access multiple tables with a single statement.

Hi I need some help with a select statement in MS SQL. I have a table that need to check if there duplicate items there. The problem is that each items is based off of 4 fields in the table. Here ...

PROC SQL allows you to specify the ORDER BY clause in the CREATE VIEW statement. Every time a view is accessed, its data are sorted and displayed as specified by the ORDER BY clause. This sorting on ...