Forum Replies Created

Viewing 10 posts - 1 through 10 (of 10 total)

  • RE: Not receiving daily newsletters

    I exchanged a couple of emails earlier this week with a very helpful lady called Melanie at SSC. They were already aware of a problem, and were working to...

  • RE: Can't figure out this error: text, ntext, ...

    Like2SQL - you may find that the exercises you are working with are designed for something like MS Access, where, I believe, the TEXT datatype is something different to SQL...

  • RE: Insert Commas Into Number String

    Hi Ryan,

    One observation - it doesn't handle negative values.

    This fixes that problem, but at the expense of some readability:

    SELECT REPLACE(CONVERT(varchar(24), floor(abs(CONVERT(money, @S))) * sign(convert(money, @S)), 1),...

  • RE: Adoption

    We still use 2000 here. We'll probably migrate to 2008 later this year - although rumours of a 2010 release for the next version make me wonder whether we...

  • RE: FileStream Partitioning Scheme

    I'm guessing the problem is that your ROWGUIDCOL isn't actually defined as unique in its own right. Your UNIQUE clause incorporates the PartKey column as well.

    Try removing PartKey from...

  • RE: sp_send_dbmail - non-ASCII Characters in Email Subject

    Hi Ken,

    Thanks, that was worth checking - but unfortunately we're using both Outlook 2003 & 2007, in Unicode mode. The strange thing is that if I send an email...

  • RE: sp_send_dbmail - non-ASCII Characters in Email Subject

    Hi Ken, thanks for the response.

    I was pretty confident that I was passing the accented characters as Unicode, as they showed up as expected within sysmail_sentitems. And having looked...

  • RE: insert arabic values to db

    Having just looked into this issue myself, I think it should be possible. In the example you give, I think all you are missing is the N in...

  • RE: Bug in Replace function?

    Here's the explanation, which I found on the MS website...

    Regardless of whether or not the second string is contained in the first string, if you pass NULL as any argument...

  • RE: Bug in Replace function?

    I'm not sure there are too many occasions where you'd deliberately use a null value in this way - it was a mistake in the code that brought the problem...

Viewing 10 posts - 1 through 10 (of 10 total)