What I have is a table with two fields with employeeid and managerid... I want to find if an employeeid has a manger id if is also an employeeid in...

Guess I'm in the wrong area... using Microsoft SQL Server 2008

Management Studio10.0.1600.22 ((SQL_PreRelease).080709-1414 )

Microsoft Data Access Components (MDAC)2000.085.1132.00 (xpsp.080413-0852)

Microsoft MSXML2.6 3.0 4.0 5.0 6.0

Microsoft Internet Explorer7.0.5730.13

Microsoft .NET Framework2.0.50727.3615

Operating...

No problem... it's one of my favorites too. I have it saved on at least 4 different flash drive;...

I have been using the following code for a long time... the original version created a procedure and I modified it to be a basic execution I could run on...

Wonderful; I'm hopeful that's it; I didn't make the linked connection or the access db for this project and will go back thru it myself and if I were a...

At the step 2 is where I get the pop up asking for profile.  And there's an advanced button that has a check box to set...

Sure this will be amusing, but what is "CDO?"  I did try logging in as the SQL agent and creating the package/job and it's profile is the same before submitting...

Yes.  That's it.  I notice you're Co-author and I have multiple SQL 2005 servers and can use the SISS but don't really now much about exchange/email and how to make...

I ran your example as a select statement:

SELECT * ,

     Mult    = CASE

               WHEN d.bewtp in ('R', 'K','Q') and shkzg = 'H' THEN '-1'

               WHEN d.bewtp in ('R',...

What your saying seems very logical; I don't have a clue to be very honest.  It seems I'm in a delema on this messed up job;  I'm not advanced enough...

I thought of a few work arounds, I could make an extra pkg just for the file check to on fail quit with success but didn't want to packages for...