I have a SQL Server job, which runs mutiple steps.  One of the steps
(step 3) looks for a record in the database.  How can I explicitly fail
the SQL server job if the database record does not exist?

I'm reading a book 'Professional SQL Server 2000 Programming' by Robert
Vieira
there is a recommendation: "stay away from building views based on
views"

I have several stored procedures with parameters that are defined with
user defined data types.  The time it takes to run the procedures can
take 10 - 50 seconds depending on the procedure.
If I change the parameter data types to the actual data type such as

If i have two identical queries, with exception of top criteria
Select top 1 * from photos
Select top 8 * from photos
why does altering the top critieria alter the order of the returned

I need to query various SQL Server databases and am finding it quite
difficult as my SQL knowledge is lousy.
I'm pretty new to SQL and would require something to cover the basics but
also cover some of the more advanced stuff.

My update query updates about 50 columns and they all have the same
format: (Im using ADP to interact with the SQL Server)
UPDATE    dbo.GIS_EVENTS_TEMP
SET  VEH1TYPE =

Is there such a date/time?
I see the Created date on the list of stored procs, but really want a
Date Last Updated.  After changing code for 3 hours, I tend to forget
which procs I've worked on, and which need to be move to production.

hi all, hope someone can help....
i'm having trouble calling an SP where the ORDER BY operator is specified as
a parameter when the SP is called
my SP is.....

We've got some numbers stored as Reals which are returning values in
scientific notation that we need rounded down to 3 digits to the right
of the decimal.
ie 8.7499999E-2 needs to return 8.75.

SELECT ProblemType, Count(ProblemType) as ProbType
 FROM Problems
 WHERE RptDate >= @begDate and RptDate <= @endDate
 GROUP BY ProblemType

I am using a temp table called ##temp in an SProc but often get the
message that the table already exists. Could this be because the SProc
is being run by more than 2 webpages at the same time?
Or is it because the sProc has an error and is not getting to the drop

we have a problem with the Full Text Catalog Search.
We use the following SQL Statement for matching companies from a table:
select company, lastname, firstname, pkcustomers, fkcustomers,
location, title, fkFunktionen, TypeOfPosition

I have a tricky problem with Reporting Services 2000. We can't use URLs
to access reports for security reasons, so we have to use the web
service. This means I have to write a viewer control (I can't wait for
SQL 2005 either!).

under MSSQL8 doing this "create table tblA as ( select Name from tblB );"
results in error 156 (wrong syntax near AS keyword). What is my mistake?
thanks and regards
Mark

I am new to SQL and I am having a hard time trying to figure out the
following error:
Msg 2812, Level 16, State 62, Server PANCHO, Line 10
Could not find stored procedure 'deletej'.