Forum Replies Created

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

  • RE: The Report Builder

    Great point!

    Totally agree on the developer's "lack of interest" in this tool, and this is understandable.

    Why would you spend time on something that you would not use yourself?...

  • RE: The Pitfall of "Not Equal To" Operator in Queries!

    SELECT s.* FROM Students s

    JOIN StudentExam se

    ON s.StID=se.StID

    WHERE se.ExamName<>'SQL Server'

    is definitely NOT the query to be used to retrieve:

    The students that has not taken "SQL Server" exam

    in the given data architecture......

  • RE: SQL Server 2005 for SQL2k Developer (Part 1)?

    Clean and clear demonstration of such a useful feature...

    Thank you

  • RE: The Zero to N Parameter Problem

    Looks cool, definitey useful in many report scenarios.

    I just 1 question...

    Is this approach SQL injection safe?

    I did not see any issues with your specific query at first sight, but...

  • RE: How To Mess Up An Interview

    Hahahahaaa,

    I am not lawfully qualified to advise a lawsuit, but I would think some of the gay candidates that Sean interviewed have some basis for a fat-ass discrimination lawsuit here... A written,...

  • RE: Reporting Services 2005

    Hi,

    I was wondering if the image issue of the reporting services have been resolved or not.

    We were unable to add a dynamic image to the report that is retrieved...

  • RE: Sound Matching and a Phonetic Toolkit

    Hi,  

    I downloaded the update, and replaced the dll's. I guess that's all I need to do...

    I have another issue (more like a confession), possibly out of NYSIIS and LEVENSHTEIN...

  • RE: Sound Matching and a Phonetic Toolkit

    An example:

    select dbo.udf_levenshtein('Yacht Sales', 'Yacht Charters International')--21

    select dbo.udf_levenshtein('Yacht Charters International', 'Yacht Sales')--22

    The first parameter issue for the udf's that are used in select clauses is a known issue. I don't...

  • RE: Sound Matching and a Phonetic Toolkit

    Another quick note:

    The user defined function udf_levenshtein is not symmetric. In other words,

    udf_levenshtein(a,b) is not always equal to udf_levenshtein(b,a)

    You might wonder "so what, why does it matter?"

    But if I use it to order...

  • RE: Sound Matching and a Phonetic Toolkit

    Thanks for the great article and toolkit. Works like a charm.

    I just wanted to share my experience, maybe someone else will make use of it .

    I have an average sized...

  • RE: Another DBA Whoops

    This is definitely one of the Software Architecture Whoops rather then a DBA whoop

    The datetime display format is definitely an UI issue...

    So the UI...

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