Forum Replies Created

Viewing 15 posts - 16 through 30 (of 3,221 total)

  • RE: FINDING THE DATE WHICH IS NEAREST TO CURRENT DATE

    With no sample(s) of your current data all I can suggest is that you look at using the built in function GETDATE.

    For example:

    SELECT GETDATE() executing 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]

  • RE: Help finding an old post

    Could this be the article:

    Group Islands of Contiguous Dates (SQL Spackle)

    By Jeff Moden, 2013/10/04 (first published: 2010/12/07)

    http://www.sqlservercentral.com/articles/T-SQL/71550/

    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]

  • RE: getDate(), each database is for different timezones

    Sounds like you should look up the function GETUTCDATE (Transact-SQL) at

    http://technet.microsoft.com/en-us/library/ms178635(v=sql.100).aspx

    This value represents the current UTC time (Coordinated Universal Time).

    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]

  • RE: SSAS: Tabular vs Multi Dimensional

    Koen Verbeeck (1/26/2014)


    2 points for such an easy question. W00t! 😎 :w00t:

    +2

    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]

  • RE: View vs sp vs functions

    Sounds like you are asking for answers to a homework question.

    Use GOOGLE to search for your answers. If you do, the following are typical of the answers you will...

    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]

  • RE: Replication

    Hany Helmy (1/11/2014)


    Not familiar with this particular feature as never had to use it before, that`s why must do some R&D before answering.

    +1

    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]

  • RE: Need a sample table with Height and Size values for people

    Use GOOGLE searching for "weight and height chart" and select from the responses (I got About 27,700,000 results in (0.22 seconds))

    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]

  • RE: QOd Survey - Apr 2008

    Click on the link Result:

    This Survey has been deactivated by the owner.

    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]

  • RE: Memory-optimized table indexes in SQL 2014

    Nice question - learned something new today Thanls

    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]

  • RE: Are the posted questions getting worse?

    There have been times that I've gone to lunch with a group just to build better relationships... I called it work, and in my opinion this falls under the same...

    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]

  • RE: Merry Christmas Everyone :)

    For those that want to hear what I want for Christmas ....

    http://www.songfacts.com/detail.php?id=9570

    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]

  • RE: Date in date range

    Are you aquatinted with BETWEEN operator available in SQL ?

    BETWEEN returns TRUE if the value of test_expression is greater than or equal to the value of begin_expression...

    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]

  • RE: Problems to learn...

    In the left most column of a this page, as you read my response click on the word Stairways and you will be rewarded with a series of links...

    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]

  • RE: notfication service

    Try this site for download

    http://www.microsoft.com/en-us/download/details.aspx?id=15748

    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]

  • RE: Today's Random Word!

    whereisSQL? (12/11/2013)


    Revenant (12/11/2013)


    Sparks

    Fly

    Swat

    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]

Viewing 15 posts - 16 through 30 (of 3,221 total)