Forum Replies Created

Viewing 15 posts - 346 through 360 (of 3,221 total)

  • RE: Are the posted questions getting worse?

    Lynn Pettis (8/6/2012)

    rodjkidd (8/6/2012)

    Koen Verbeeck (8/6/2012)

    opc.three (8/5/2012)

    WayneS (8/3/2012)

    Steve Jones - SSC Editor (8/3/2012)

    FYI, since some of you submit questions. I'm no longer accepting images of code.

    Please feel free to debate...

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

    August 6, 2012 at 8:55 am

    #1522098

  • RE: SQL-The log file for database is full

    Try this

    http://msdn.microsoft.com/en-us/library/ms175495.aspx

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

    August 5, 2012 at 8:55 pm

    #1521803

  • RE: How to count the total sales prior's 4 weekend if user give the weekend date.

    2011-12-182011-12-192011-12-202011-12-212011-12-222011-12-232011-12-24

    Sunday Monday Tuesday WednesdayThursdayFriday Saturday

    Now let me ask...

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

    August 5, 2012 at 8:44 pm

    #1521801

  • RE: How to count the total sales prior's 4 weekend if user give the weekend date.

    Is this what you are looking for:

    DECLARE @d DATETIME

    SET @d = '2011-12-24' -- user passed value

    SELECT SUM(Salesweek)...

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

    August 5, 2012 at 4:36 pm

    #1521793

  • RE: 0 is equal to zero length string. Can someone explain how this can be?

    JasonRowland (8/4/2012)

    Ok, I think I understand why this is. There is an implicit conversion from varchar to int and you might think that when converting '' to int it would...

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

    August 5, 2012 at 8:01 am

    #1521763

  • RE: How do I to convert varchar datatype to datetime

    As previously stated you can use CAST or CONVERT. But like many items in T-SQL "It depends". As an example ... be aware of your system date...

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

    August 5, 2012 at 7:39 am

    #1521759

  • RE: Are the posted questions getting worse?

    WyaneS

    I'm curious... how many Threadizens here would be interested in forming a QotD team to verify the questions?

    +1 Me

    And forget about my E statement was made tongue in cheek ..

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

    August 4, 2012 at 6:36 am

    #1521699

  • RE: Are the posted questions getting worse?

    Steve Jones - SSC Editor (8/3/2012)

    FYI, since some of you submit questions. I'm no longer accepting images of code.

    Please feel free to debate me.

    A. I consider the QOD as...

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

    August 3, 2012 at 7:36 pm

    #1521677

  • RE: Are the posted questions getting worse?

    WayneS

    I was checking SQLSat156 (Providence, RI) to see if the speakers had been selected yet, and I count 5 Threadizens that have submitted for it. Sure would be nice if...

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

    August 3, 2012 at 7:22 am

    #1521375

  • RE: DATETIME 2

    I am rather surprised at the low percentage of correct answers.

    Correct answers: 37% (76)

    Incorrect answers: 63% (129)

    Total attempts: 205

    And the implications this could have to those designing...

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

    August 2, 2012 at 6:09 am

    #1520749

  • RE: Print The Calender 2

    Nice thanks added it to my SANDBOX for future use

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

    August 1, 2012 at 7:38 pm

    #1520611

  • RE: Error/Exception handling in sql server 2000

    Try reading this to see if it helps you, if NOT come on back and someone can give you further assistance

    http://msdn.microsoft.com/en-us/library/ms188790.aspx

    Although the link is to a reference to sQL 2005,...

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

    August 1, 2012 at 6:57 pm

    #1520608

  • RE: Backup Compression

    Nice easy question to start the week ...

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

    July 30, 2012 at 9:14 pm

    #1519505

  • RE: Primary Keys

    L' Eomot Inversé (7/28/2012)

    Nice easy unambiguous question.

    A restful finish to to the week (for some), and a pleasant start to the week for others.

    Published a little before its...

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

    July 29, 2012 at 6:47 am

    #1518929

  • RE: NULLIF 1

    Rose Bud

    Thanks

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

    July 28, 2012 at 5:37 am

    #1518861

Viewing 15 posts - 346 through 360 (of 3,221 total)