Multiple post - see http://www.sqlservercentral.com/Forums/Topic1509192-391-1.aspx

Multiple post - see http://www.sqlservercentral.com/Forums/Topic1509192-391-1.aspx

Multiple post - see http://www.sqlservercentral.com/Forums/Topic1509192-391-1.aspx

You've already got the pseudo code for these which is a good start.

My first question is, is the stored procedure the best place for doing this - would it be...

Have you checked the locale on the client PC (where the excel file is being opened)?

No problem - glad to see you are sorted.

You're welcome - I try to keep everything simple - it makes life easier for the next guy!

Try this :-

convert(CHAR(10), getdate() ,120)

I think it might suit what you're trying to do

ISNUMERIC returns 1 if the value could be interpreted as a number and 0 if it couldn't. The three examples in the QOTD gave 1...

Sorry Jeff - the best one I ever got was :-

Dear...

Hi,

I've had this problem too. The way that worked for me was to create another variable, populate this with you variable then use that for the email e.g.

declare @Message varchar(500)

set...

The reportserver data base execution log table shoud have the info you're after

Completely agree. Also I second the...

Reading between the lines of what is going on in my company, I may well be writing the training manual for a support company to take over my job. We...

John Mitchell-245523 (9/26/2013)

---

Maybe you could get the powers that be to have a look at the article I linked to? If I remember correctly, the thrust of the argument...