I agree with all of Steve's choices with the editoral, but must admit I have found new choices of music(rock) that I don't have to worry about what my kids...

This doesn't answer your question, but I wanted to add that it would be great to have a SQL SIG reference document on this site.  Location and possibly contact person...

Jonathan - I really like this idea!  It's quick and it does the job.  Thank you for sharing.

I know this isn't part of the question, but for performance (I'm not sure how many records you have in your view...)  How about:

if exists (select top 1 * from...

Thank you everyone for your replies.  I have ordered the first book listed and am checking into the other resources provided.

Thanks again.

Shawn

I'll give that a try, thanks again for all your help.

Thanks for the link.  It has some excellent suggestions.  I'm doing a stored proc and using a global variable as a parameter, which works well to get the data.

This process...

You know, I never questioned that since it was generated (the code) by DTS.  I will take the spaces out of the transformation code and try it.  Thanks for the...

The customer id is being set with a global variable which I am supplying with the \A parameter on DTSRun.  It's working since I see the value in the email...

Here is the transformation code:

'**********************************************************************

'  Visual Basic Transformation Script

'************************************************************************

'  Copy each source column to the destination column

Function Main()

             if DTSGlobalvariables("Customerid").value = "3245" then

  DTSDestination("note                                                            ") = DTSSource("note")

 end if

 Main = DTSTransformStat_OK

End Function

Here...

Thank you for the reply.  I tried this and it doesn't like that the column doesn't exist in the destination file.  For one customer the column will exist and all...

I always use as an attachment instead of the body of the email.

@attach_results = 'true'

Try the @Width= 'your size here'  parameter.

I had this same problem once and it ended up being we had an older version of MDAC on the server than I had on my Desktop where I created the...

My .02 worth...I always (at my previous

employer) used a prefix. tb_ for tables,

usp_ for stored procs and vw_ for views.

Comes in handy when you do a sp_help and

list all...