Home Forums SQL Server 2008 T-SQL (SS2K8) [T-SQL] Question involving Job,Cursors, SP and DBMail RE: [T-SQL] Question involving Job,Cursors, SP and DBMail

  • Many, many thanks. Humiliating enough (for me) it was that simple. I think I tried almost everything else apart from that.

    The only change I did (which of course you couldn't know) is the rdate had to be used with time in 24h format so I did the conversion like this :

    CONVERT(nvarchar(25),@Rdate,120)

    Cheers,

    Alex