Forum Replies Created

Viewing 15 posts - 31 through 45 (of 371 total)

  • RE: Table Variable

    I didn't know we could have an identity column in a table variable.

    And that it can't be reset. I was expecting it wouldn't be possible to truncate the table though.

    I...

    Best regards,

    Andre Guerreiro Neto

    Database Analyst
    http://www.softplan.com.br
    MCITPx1/MCTSx2/MCSE/MCSA

    August 17, 2012 at 7:18 am

    #1527074

  • RE: Varchar Exceeding 8000 characters

    Hi.

    What is the exact error message you're receiving?

    Best regards,

    Andre Guerreiro Neto

    Database Analyst
    http://www.softplan.com.br
    MCITPx1/MCTSx2/MCSE/MCSA

    August 17, 2012 at 5:44 am

    #1527038

  • RE: BIT Conversions

    Excellent question, Wayne.

    Thank you.

    Best regards,

    Andre Guerreiro Neto

    Database Analyst
    http://www.softplan.com.br
    MCITPx1/MCTSx2/MCSE/MCSA

    August 14, 2012 at 4:59 am

    #1525426

  • RE: SELECT - CASE - GROUP BY

    Nice. That's almost the same thing without using a derived table.

    I tend to use it whenever possible (or even CTEs) to make the code more readable. 🙂

    Have a great week!

    Best regards,

    Andre Guerreiro Neto

    Database Analyst
    http://www.softplan.com.br
    MCITPx1/MCTSx2/MCSE/MCSA

    August 13, 2012 at 8:03 am

    #1525059

  • RE: SELECT - CASE - GROUP BY

    Does this work?

    SELECT ta.ErrorID, tab.ErrorType, tab.DateLogged,

    CASE WHEN total = 1 THEN tab.PolicyNumber ELSE 'MULTIPLE' END

    FROM (SELECT tblErrors_ER.ErrorID, tblErrors_ER.ErrorType, tblErrors_ER.DateLogged,

    ...

    Best regards,

    Andre Guerreiro Neto

    Database Analyst
    http://www.softplan.com.br
    MCITPx1/MCTSx2/MCSE/MCSA

    August 12, 2012 at 5:04 pm

    #1524884

  • RE: SELECT - CASE - GROUP BY

    I'm on a computer that don't SQL Server installed but you could try to use COUNT in an inner SELECT and then in an outer SELECT you could use something...

    Best regards,

    Andre Guerreiro Neto

    Database Analyst
    http://www.softplan.com.br
    MCITPx1/MCTSx2/MCSE/MCSA

    August 12, 2012 at 4:58 pm

    #1524883

  • RE: "Question of the Day" is about:

    Hugo Kornelis (8/4/2012)

    My personal answer is a combination. In the role of answering questions, the value of the QotD to me is a combination of judging my knowledge and learning.

    +1

    Best regards,

    Andre Guerreiro Neto

    Database Analyst
    http://www.softplan.com.br
    MCITPx1/MCTSx2/MCSE/MCSA

    August 4, 2012 at 4:03 pm

    #1521729

  • RE: Commenting in Dynamic query

    Thanks for a straightforward question.

    I found it quite easy because it's one of the opened doors for SQL injection.

    Best regards,

    Andre Guerreiro Neto

    Database Analyst
    http://www.softplan.com.br
    MCITPx1/MCTSx2/MCSE/MCSA

    August 3, 2012 at 9:00 am

    #1521448

  • RE: "Question of the Day" is about:

    The QotD is not also about judging our skills?

    Best regards,

    Andre Guerreiro Neto

    Database Analyst
    http://www.softplan.com.br
    MCITPx1/MCTSx2/MCSE/MCSA

    July 30, 2012 at 11:18 am

    #1519315

  • RE: Rename column

    Got it wrong and I'm satisfied because it was a very interesting question.

    Microsoft always makes QotD harder than it should be because many things don't work the way we logically...

    Best regards,

    Andre Guerreiro Neto

    Database Analyst
    http://www.softplan.com.br
    MCITPx1/MCTSx2/MCSE/MCSA

    July 27, 2012 at 5:21 pm

    #1518810

  • RE: How well do you know MAX?

    harsh.lapashiya (11/15/2011)

    good twister

    To get third highest salary

    select MAX(salary) from Employees where salary <(select MAX(salary) from Employees

    where salary <(select MAX(salary) from Employees))

    I know this is a year old post but I...

    Best regards,

    Andre Guerreiro Neto

    Database Analyst
    http://www.softplan.com.br
    MCITPx1/MCTSx2/MCSE/MCSA

    July 22, 2012 at 3:57 pm

    #1516021

  • RE: How To Write An Interview Winning Resume

    John.Sansom (7/19/2012)

    In my own experience, both as a candidate and a hiring manager, I have found that the additional effort spent on a resume is always a worthwhile investment.

    Thank you...

    Best regards,

    Andre Guerreiro Neto

    Database Analyst
    http://www.softplan.com.br
    MCITPx1/MCTSx2/MCSE/MCSA

    July 19, 2012 at 9:59 pm

    #1515274

  • RE: Perfomance Tuning

    I guess there are no default recipes and most of the people will say "it depends". 🙂

    Best regards,

    Andre Guerreiro Neto

    Database Analyst
    http://www.softplan.com.br
    MCITPx1/MCTSx2/MCSE/MCSA

    July 19, 2012 at 9:26 pm

    #1515271

  • RE: Should I go ahead with 70-432

    At some point, I will apply for the three exams required for me to upgrade my MCITP to MCSE. But right now I've been wondering "is it the right decision"....

    Best regards,

    Andre Guerreiro Neto

    Database Analyst
    http://www.softplan.com.br
    MCITPx1/MCTSx2/MCSE/MCSA

    July 19, 2012 at 9:12 pm

    #1515269

  • RE: DBCC CHECKDB WITH TRY/CATCH

    Thank you for such interesting question.

    Best regards,

    Andre Guerreiro Neto

    Database Analyst
    http://www.softplan.com.br
    MCITPx1/MCTSx2/MCSE/MCSA

    July 19, 2012 at 10:57 am

    #1515013

Viewing 15 posts - 31 through 45 (of 371 total)