Karl, could I take it a step further and somehow code it to be used for varying lenghths? Some of my expected value lengths may be 10, but others are...

Thanks, guys! It looks like I'll be creating a parameter/values table. Thanks for the help

Justin

Neel, you have to be more specific in what you want to accomplish. If there are 2 records that have empid 3, how do you know which one to delete?

Try this. You'll obviously have to change the values.

exec master.dbo.xp_sendmail

  @recipients='email@address.com',

  @subject='Here are my results',

  @attachments = 'Filename.txt',

  @query='Select * from table where blahblahblah',

  @attach_results = 'TRUE'

I use xp_sendmail all the time to send emails and results. I've never attached a file other than a result set, but looking in BOL, it appears that you can.

xp_sendmail...

Not sure if this will help or not...

If the MSSQLServer Service startup account is set to the local system account, xp_startmail fails with the following error message:

When you get to the Transformation, you can edit the statement by adding + 9000 (or whatever the numebr is). See below for example:

Function Main()

 DTSDestination("YourField") = DTSSource("YourField") + 9000

 Main =...

Barbara,

Are you familiar with using DTS? This can easily be done by using the DTS wizard and select "Usa a query to specify data to transfer". Once you select your...

Phil, that solved my problem. Thanks to everybody who helped me out

Thanks Jonathan that's just what I needed!

Do you have any example code that you've used before?

Thanks for the tip. The A,B,C was just an example so the missing letter thing won't be an issue, but unfortunately the real Codes are alpha-numeric and I can't change...

Will do.  Thanks!

Here's an example for 1 product (1 have 12, total)

SELECT * FROM Column WHERE 1=1

AND ColId not in ('1351','1353','1387','1388','1389','1390','1391','1625','1626','1628','1629','1630','1633','961','962')