Forum Replies Created

Viewing 15 posts - 301 through 315 (of 3,221 total)

  • RE: Select All Rooms Available for Given Date Range

    You may want to look at:

    http://www.sqlservercentral.com/Forums/Topic267061-176-2.aspx#bm1135582

    It is the so called Island and Gaps solution.

    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]

    September 8, 2012 at 4:09 pm

    #1535424

  • RE: Are the posted questions getting worse?

    I didn't expect anything in return for helping. I felt it was the right thing to do, especially since I was walking down that way any way. It was sad...

    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]

    September 7, 2012 at 7:54 pm

    #1535364

  • RE: What exactly happend when i am inserting a row into the table?

    SQL* (9/7/2012)

    Hi All,

    I have posted the question in General discussion, but i did not find any answer so i am posting her:

    http://www.sqlservercentral.com/Forums/Search1-0-2.aspx?SessionID=zs2dileulupx3g201ykafs30&SortBy=2&SortOrder=1

    thanks

    Clicking on the above link returned 111 posts,...

    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]

    September 7, 2012 at 7:06 am

    #1535037

  • RE: how to add hours to day

    Is this what you require ?

    CREATE TABLE #T(Hr INT,D DATE,S INT)

    INSERT INTO #T

    SELECT 0, '2012-09-05', 10 UNION ALL

    SELECT 1, '2012-09-05', 20...

    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]

    September 6, 2012 at 7:26 pm

    #1534812

  • RE: Calculating date

    First item the time you say you need to pick is

    8/6/2012 12:10:33

    that time does NOT exist in the data you have listed. That said is this...

    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]

    September 6, 2012 at 7:03 pm

    #1534809

  • RE: APPLY - 1

    WayneS

    Hugo - thanks for the great clarifications / explanations that you do so frequently with the QOTDs. Things just wouldn't be the same without you on these every day, providing...

    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]

    September 6, 2012 at 1:34 pm

    #1534732

  • RE: How do I determine the full backup file's name?

    Rod at work (9/5/2012)

    . But how do I determine the newly created backup file's name? It's kind of a long thing, so I don't know how to go about...

    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]

    September 5, 2012 at 8:08 pm

    #1534209

  • RE: Fiscal Dates

    These two articles might give you a method of doing what you desire.

    http://www.sqlservercentral.com/articles/function/67046/

    http://www.sqlservercentral.com/articles/function/68323/

    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]

    September 5, 2012 at 6:13 pm

    #1534192

  • RE: Are the posted questions getting worse?

    Time for me to toot my own horn ... braging HECK yes.

    My 73rd QOD has been scheduled for 06 Sep 2012 - 07 Sep 2012

    Should be available shortyly after 10...

    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]

    September 5, 2012 at 10:55 am

    #1534011

  • RE: Table Variable

    Nice question - make sure one knows the basics

    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]

    September 3, 2012 at 8:17 pm

    #1533096

  • RE: List of Known issues

    Go to Microsoft's Connect site - for a quick guide of what you can do and what you can uncover try reading:

    http://blog.hoegaerden.be/2012/01/04/posting-an-issue-to-microsoft-connect/

    The Connect site can be accessed via:

    https://connect.microsoft.com/

    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]

    September 3, 2012 at 6:58 am

    #1532950

  • RE: Table Variable

    L' Eomot Inversé (9/2/2012)

    Hugo Kornelis (8/31/2012)

    bitbucket-25253 (8/31/2012)

    sknox (8/31/2012)

    bitbucket-25253 (8/30/2012)

    Nice question on the basics

    ...A better supporting document/respected DBA is this blog posting by Steve Jones

    http://www.sqlservercentral.com/blogs/steve_jones/2012/08/03/identity-insert-and-table-variables-connect-issue/

    Agreed. Also, if you haven't voted...

    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]

    September 2, 2012 at 5:09 pm

    #1532782

  • RE: Table Variable

    See next post

    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]

    September 2, 2012 at 5:01 pm

    #1532781

  • RE: Creating a global temp table in a stored procedure

    ChrisM@Work (8/31/2012)

    Potso (8/31/2012)

    Thanks I knew it was something simple and dumb i was just not thinking about. And i am dropping the table everytime after the stored procedure is run...

    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 31, 2012 at 8:17 am

    #1532412

  • RE: Table Variable

    sknox (8/31/2012)

    bitbucket-25253 (8/30/2012)

    Nice question on the basics

    ...A better supporting document/respected DBA is this blog posting by Steve Jones

    http://www.sqlservercentral.com/blogs/steve_jones/2012/08/03/identity-insert-and-table-variables-connect-issue/

    Agreed. Also, if you haven't voted on the Connect submission for this...

    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 31, 2012 at 6:28 am

    #1532344

Viewing 15 posts - 301 through 315 (of 3,221 total)