I have three tables which are joined by a common field CS_Survey_rec ID.
How do I delete records from all tables where cs_Survey_RecID >17. This is
the first time I am deleting, so please help I don't want to delete the wrong
records

Any recommendations on implementing a password field in a table. I want to
use it for log in by a an ASP application. I could just handle it all in the
ASP code but I wondered if there are any good techniques used in SQL
TIA

I am currently using SQL Server 2005 Express Edition and SSMSE.  I have
developed a unit testing suite for my stored procedures.  The way it works
is, all of my tests (stored procedures on the database that call the actual
stored procedures to determine if they return the correct ...

I need to read my table and pull back values based upon criteria within the
fields parsed.
CREATE TABLE territories (
customer NVARCHAR(10),

I have the following store procedure to execute a xp_cmdshell statement to
export an view to a text file. Everything is working fine except I do not
want it to overwrite the existing file. Currently the export file name is
static. The file name is restricted to max 8 characters ...

i want to know how can i password protect my sql server 2005 express
instance so thatnobody can go and play with database or even view it?

I am doing three separate INSERT...SELECT FROM statements to write to three
related tables. The first table has an IDENTITY column the value of which
must go into the seond 2 tables.
Each insert will insert multiple rows.

I am trying to build a UDF to generate an employee ID and to make sure it is
unique.  Our employee ID's consist of first initial of first name + first
initial of last name + 38 (our location) + Last 4 of SSN.  An example is,
dd381234.

I have the following cte in which I am attempting to take two tables,
combine them and FOR EACH distinct date that is listed, return only one date,
the amount of only the last AdminAdjustment for that date, only the last
DateAdjusted date, etc.  I included the data it is ...

I am working with the SSRS catalog database to create a report and got stuck
on this query.  The subquery is bringing back more than one row - so it
errors out.
Basically I want to return report names (Type=2) with the associated Parent

According to help this can have value of 0, 1 or null
Why then when I display the select results do I see value of -1?
And in Management Studio table display I see True or False
Also, help says I can refer to 0 or 1 as FALSE or TRUE yet I dont see these

Getting:
Msg 4104, Level 16, State 1, Procedure ESIMonthlyNC, Line 207
The multi-part identifier "P.ParentId" could not be bound.
(note it says BOUND and not FOUND)

OK,
SO, I want to get BOTH the any error codes that might have been thrown AND
if the statement is successful, how many records were updated.
Sounds like a simple request but it seems like I can only get one or the

Is this code valid in a proc?
<Some SQL statement>
If @@Error <> 0
   Begin

I have an sp that selects data at a detail level. Can I create an sp to
summarize the data in the detail sp (by calling it), or do I need to create
a single sp that selects and summarizes the data?
Essentially, can one sp call another sp?