Search results for query: *

I am looking for some assistance in accessing the Outlook 2000 "Save as Web Page" Calendar feature via code. I am attempting to programatically save a public calendar to a web page (or in this case a number of web pages) that can then be accessible (read-only) from a web site. I have...

Yes, that does appear to do what I want... thanks! CREATE PROCEDURE [SP_SEARCH] AS declare @selectclause nvarchar(500) declare @whereclause nvarchar(500) declare @orderbyclause nvarchar(500) declare @sqlclause nvarchar(1500) set @selectclause ="SELECT * FROM ATTENDEE&quot...

Is it possible to pass the WHERE clause to the SELECT statement as a global variable or parameter? If so, what syntax would I use? For example: CREATE PROCEDURE [SP_SEARCH] AS declare @whereclause varchar(255) set @whereclause = " lastname = 'SMITH' " SELECT * FROM...

Many thanks for all the great answers! All three work as expected. Is there a consensus as to which one may be the most efficient? When executing the code against my actual data, I find the UNION to be the slowest and the other two to be very comparable...

I am having difficulty trying to put together a query (Oracle 8i) that would give me all records from one table and the corresponding records from another table in which the value is specified. I have tried various subqueries with left joins etc and haven't had any luck. For example, list...