I have two tables: Professors and Articles.
I need to classify the lessons given by the professors and their
articles using the following information:
- Levels and Grades are as follows:

I have a stored procedure with 3 statements in a transaction:
1) TRUNCATE TABLE myTable
2) INSERT INTO myTable ...
3) EXEC master..xp_cmdshell 'DTSRun /S MYSERVER /E /N "My DTS Package"'

I have a adjacency list model on a table.
The table's script is;
CREATE TABLE [dbo].[REPORT_LINE](
[ID] [int] IDENTITY(1,1) NOT NULL,

I have a varchar type column which stores data like below.
(sample values for 7 rows)
(@2857 + @2858 + @2859 + @2860 + @2861 + @2862)
(@2894 + @2895 + @2896)

In a stored procedure, in addition to doing other things I am using a
variable @ABC simply to hold sum of a column yr_2004  as follows:
declare @ABC int
select @ABC = sum(yr_2004) from PROJ_POPSELECT

To retrieve records from a table with a simple PK we know we can use WHERE
NOT IN.. or WHERE NOT EXISTS or the LEFT OUTER JOIN ON field = null
eg.
Select * from Customers where CustomerID NOT IN (2, 34, 23)

I created linked server (access) in sql 2005.
I can read data like this query.
select * from LinkedServer...ATable
I need to create the table and drop the table using linked server.

I have make this query  any i have all variable declared but this query don't
work.
Whay ????
Please heil me

When you have groups of numbers in a column e.g.
SomeColumn
---------
101

Excuse my English, my native language is Spanish.
I want make a comma delimited list but can not get to work within a
'SELECT'. Alone get it to work but when put into another 'SELECT' no.
Thank you very much in advance.

Does anyone have instructions on how to use the 'processing-
instruction' directive in the FOR XML PATH statement?  I've
looked in many places but can't find guidance on how to use
this.

I recieve the syntax error when tring to link a sp to Crystal reports 8. The
sp runs fine to query analyzer. The sp was originally written to run for a
specific client, but I took all the code referring a specific client to run
for all and now I get the Syntax error. Any help would ...

An old technique for this is to use a temporary table to hold the results of
the stored procedure,  an INSERT EXEC statement to execute the procedure and
save results. Once the results held in the temporary table they could be
used like any other table data.

I have written a cursor to fetch user id from the employee table and I want
to fetch details of those user from users table.  Cursor is as below. But it
is not returning required data. Please correct me where I have went wrong.
DECLARE @UserName NVARCHAR

[SQL2005 SP2]
I see the below message in the SQLServer log shortly after the service gets
started:
" 2009-07-29 00:09:28.590 Server A self-generated certificate was