It may be necessary to verify that you client and remote server are using the same version. I used to have the same problem until I updated my client...

Nice! It is amazing what a 0 can do. Thanks for the quick response.

I was curious how you would do this with the STUFF function. I tried testing it with the following:

SELECT...

If I understand correctly you are trying to update a specific employee record for a specific date. You mention that empid is a FK in the selection table to...

When you say exporting a to CSV through SQL Report do you mean through DTS or the export wizard?  If so, there is a check box on the Text File...

Hi BentleyGadget,

I had to do something similiar recently.  I am including a version of my stored procedure I used to resolve the problem.  I have changed many of the variable...

I have had to do this a several times and have found the RIGHT function to be very effective.  For example, for a two character column you could do the...

I agree with you that it is not intuitive when you have a workflow property on a step.  This happened to me on a DTS package I was given to...

Hmmm.  That is weird.  Usually if something is being filtered it appears in my PMM Mimesweeper mailbox.  I guess I will ask the email peeps.    Thanks for the replies.

My email is a work address.  I used to get the newsletter but it has stopped recently.

As Ninja's RGR'us stated, you need to have execute on the sp_sdidebug procedure.  This is the first step.  You may also want to verify that your local version of SQL and server...

I think that Baseline article is pretty scary when you think about the implications.  Every company is starting to base products and rate they offer you based on previous history. ...

I also do not see any dupes in your above sample.  As Kenneth said:

936,12, ,985

936,13, ,985

that isn't what you want to receive?  The DISTINCT clause based on your sample...

Well it seems that my issue has since been resolved.    I'm now receiving my newsletter on time. Thank you.

Sam T, I'm not sure if this is your problem exactly but maybe it can help.  I ran into a similiar problem trying to use the MAPI mail client in...