Forum Replies Created

Viewing 15 posts - 451 through 465 (of 567 total)

  • RE: Are the posted questions getting worse?

    jasona.work (1/24/2013)


    Badgers?

    BADGERS?

    We don' need no steenkin BADGERS!

    😀

    (OK, the link to the Youtube video didn't work, so here it is: http://www.youtube.com/watch?v=gx6TBrfCW54)

    You get to drink from the FIRE HOSE!!!!

    Jason Wolfkill

  • RE: Reportserver Engine changing non-unicode to unicode

    sqldba_newbie (1/18/2013)


    I am experiencing this exact issue as mentioned here . I do have a work around. I was wondering is there a setting on the report server or some...

    Jason Wolfkill

  • RE: IN clause for xml datatype

    winmansoft (1/21/2013)


    I have xml something like below in my sql server table

    <z>

    <a>

    <b>1</b>

    <c>2</c>

    </a>

    <a>

    <b>4</b>

    <c>5</c>

    .

    .

    .

    so many tags similar to above

    .

    .

    </a>

    </z>

    I wanted to remove some particular <a> node and it's child node where <b>...

    Jason Wolfkill

  • RE: Are the posted questions getting worse?

    SQLRNNR (1/23/2013)


    Koen Verbeeck (1/23/2013)


    wolfkillj (1/22/2013)


    When I was doing a lot of SSRS development, I wasted so much time closing BIDS and reopening it because often that was the only way...

    Jason Wolfkill

  • RE: Are the posted questions getting worse?

    jasona.work (1/22/2013)


    . . .

    Next up: Tackling teaching myself SSRS...

    😀

    Jason

    Whew - have fun with THAT, especially if you are going at it from the report development side. The admin side...

    Jason Wolfkill

  • RE: How to match a UNICODE NULL character within an nVarchar(128) string?

    mrTexasFreedom (1/17/2013)


    Lowell,

    Sadly, this isn't matching any rows:

    select id, name

    FROM my_user_table

    WHERE CHARINDEX(name,CHAR(0),1) > 0

    No rows returned. Likewise, the replace operation doesn't touch any of the rows. Ideas?

    Thank you very much...

    Jason Wolfkill

  • RE: Get date not working

    anthony.green (1/17/2013)


    Ed Wagner (1/17/2013)


    If your field is a datetime data type, then you're comparing the datetime result of GetDate() against the datetime value of the field. So, nothing's going...

    Jason Wolfkill

  • RE: Difference between Money and (Float or Decimal) Datatype

    nagesh.prasad (1/16/2013)


    What is the difference between Money and (Float or Decimal) Datatype. If we use Float or Decimal instead of Money, will we loose any functions..?

    Money and Decimal are...

    Jason Wolfkill

  • RE: Are the posted questions getting worse?

    Evil Kraig F (1/17/2013)


    Was ill for a week, miss anything of import?

    MS announced that SQL Server 2012R2 will be released in late 2014 and will officially support both DBCC TIMEWARP...

    Jason Wolfkill

  • RE: Better Way to Perform this Query

    dwain.c (1/15/2013)


    wolfkillj (1/15/2013)


    I've been working on a set-based T-SQL solution to determine the Damerau-Levenshtein Distance between two strings. (DLD distance is just like LD - the number of changes required...

    Jason Wolfkill

  • RE: T-SQL 2012 #2

    L' Eomot Inversé (1/15/2013)


    KWymore (1/14/2013)


    Thanks for the 2012 question. I'm not sure why I would ever use CHOOSE. I would usually join to a reference table, or use a case...

    Jason Wolfkill

  • RE: Better Way to Perform this Query

    ChrisM@Work (1/15/2013)


    Alan.B (1/14/2013)


    Jeff Moden (1/10/2013)


    Alan.B (1/10/2013)


    This morning before work for example, after a lot of effort, I finally figured out how to get the Levenshtein Edit Distance between 2 strings...

    Jason Wolfkill

  • RE: Are the posted questions getting worse?

    SQLRNNR (1/14/2013)


    wolfkillj (1/14/2013)


    SQLRNNR (1/14/2013)


    jasona.work (1/14/2013)


    /stoned voice

    Dude! I can smell colors now!

    Can you feel them too?

    Is it like a rainbow explosion?

    Well, if you can taste the rainbow, you're just eating...

    Jason Wolfkill

  • RE: Are the posted questions getting worse?

    SQLRNNR (1/14/2013)


    jasona.work (1/14/2013)


    /stoned voice

    Dude! I can smell colors now!

    Can you feel them too?

    Is it like a rainbow explosion?

    Well, if you can taste the rainbow, you're just eating Skittles.

    Jason Wolfkill

  • RE: T-SQL 2012 #2

    SQLRNNR (1/12/2013)


    Glad we have this feature added.

    But are the CHOOSE function and its also-new-to-SQL-Server-2012 buddy IIF anything other than syntactical sugar for Visual Basic coders writing T-SQL? The CHOOSE function...

    Jason Wolfkill

Viewing 15 posts - 451 through 465 (of 567 total)