Antonio,

Based on the supplied test data and the stated desired outcome if you added C1.ParentRev <> C2.ParentRev then you would not get any results because ParentRev is 0 in each...

lersner (4/9/2008)

---

It was failing every time with a message about not being able to handle multiple trues in the where clause with an OR. The where in clause works...

I have run the query you provided with only one change.

In the derived table query you reference table T1 which does not exist that needs to be Table1. Here...

After running both it looks like Ryan's solution is slightly more efficient so will scale a little better.

This is basically the same solution Ryan posted without a CTE

--Create temporary table that holds Parent and Children records.

IF OBJECT_ID (N'tempdb..#Children', N'U') IS NOT NULL

DROP TABLE #Children;

CREATE TABLE #Children

(

ParentNo...

When using a script component you need to enter the package variables you want to use in the custom properties section of the script screen. Then within the script...

PW is right, it is hard to tell without knowing the SQL and the database structure, etc... Over all the plan is not that bad. It is using...

Man Matt, am I glad you are around to clean up behind me!

I would put the Conversion in the Select for the source. You did not specify the type of datasource so I gave SQL Server syntax your source's conversion function...

You have not assigned the schedule to the job. You need to run sp_attach_schedule so your code should look like this:

USE NetLicenses;

GO

CREATE PROCEDURE sp_CheckLicenseStatus

AS

BEGIN

...

Sorry. Replace the Table1.* and Table2.* with T1.* and T2.*. I copied and pasted your original code, modified it and forgot to change those to the Aliases I...

If the stored procedure was not re-compiled after the addition of the index it is not guaranteed to use the index. Did the execution plan change? Try running...

When you use the char or nchar data type the string is right padded with spaces so 'Customer1' (Char(9)) and 'Customer1 ' (Char(10)) are different. Thus you need to...

Matt Miller (4/8/2008)

Oh don't feel bad. You're right that I shouldn't have used the "Regex syntax" term, since it only supports ranges and range exclusions and not all of...

In the subquery put TABLE.File_Name instead of File_Name as File_Name is a function.

Antares' questions are also valid.