You did try it on sql 2005?

Only if the two tables have the same number of fields with compatable datatypes.

It doesn't compile because of this:

LEFT OUTER JOIN

  (SELECT COUNT(ID) AS NumberDue

   FROM tblMEMResellerOrders ResOrds

   WHERE (resords.Expiration <= '12/30/2005 23:59:59')

    AND (resords.Expiration >= '12/1/2005 00:00:00')

    AND (resords.PurchaseOption <>...

Impossible to test without table schemas and example data, but this should give you somewhere to start.

I moved the subqueries into the from clause so that the values returned...

Firstly, I would suggest a table redesign, if that's possble.

EmployeeSkills would be much, much better as below.

CREATE TABLE EmployeeSkillset (

 EmpID CHAR(8) NOT NULL,

 SkillID INT NOT NULL,

 IsPrimarySkill BIT NOT NULL...

JV: check the account that SQL Agent runs as. Make sure it has permission to access the file. Make sure you use full paths, not relative paths

Regarding permissions for...

Just bear a few security issues in mind. A fairly high priviledged account is required to use xp_cmdshell. Check Books online for the exact details

Commands run from xp_cmdshell run as...

Um, her test, actually

I didn't think of the subquery, thanks for that idea.

I was...

Won't work. I had a similar issue the other day. Once you've created a column alias with the same name as a column in the table there's no way (that...

why would you want to call a DTS package in a trigger? Trigger code should be as short as possible and do as little as possible.

What are you trying to...

Select TableA.Col1 FROM TableA WHERE TableA.ID = 1;

Select TableB.ColA FROM Table B WHERE TableB.ID = 2

Put that as the commandtext for your .net SQLCommand. It will return 2 recordsets.

That, or write...

EXECUTE AS LOGIN = 'TestDomain\TestUser'

 -- run testing code here

REVERT

You need impersonate rights on the login that you're impersonating.

See ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/tsqlref9/html/613b8271-7f7d-4378-b7a2-5a7698551dbd.htm in the SQL 2005 books online

A varchar will store spaces if they're part of the string that's put in the variable/field. It just won't pad with spaces to full length like char does.

Note that LEN...

And for dynamic sorts...

CREATE PROCEDURE SortedPerson

 @SortField VARCHAR(30) = 'Surname'

AS

SELECT title, first_name, surname

 FROM Person

 ORDER BY CASE @SortField WHEN 'First_Name' THEN first_name

  WHEN 'Title' THEN title

  ELSE Surname

 END

Here's another way

create procedure FindPeople

@Firstname varchar(30) = '',

@LastName varchar(30) = '',

@Title varchar(5) = ''

AS

Select title, first_name, surname

from person

where first_name LIKE ISNULL(@FirstName,'') + '%'

  and last_name LIKE ISNULL(@LastName,'') + '%'

  and title LIKE ISNULL(@Title,'') +...