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 ...

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 ...

The ENTRYTYPE= option in the SELECT statement works like the ENTRYTYPE= option in the PROC UPLOAD statement. For a complete list of entry types and for detailed information about how to use the ...

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 ...