As we saw in the last article, the SQL SELECT statement has the widest variety of query options, which are used to control the way data is returned. ... The WHERE clause in a query is one example.

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

I'm doing this in a stored proc using SQL Server.<BR><BR>Basically, I'm executing 1 SELECT statement and if that returns any rows then I want to do a SELECT INTO #Temp With criteria A.

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