Forum Replies Created

Viewing 15 posts - 1,936 through 1,950 (of 7,187 total)

  • RE: T-SQL - Adjusting Payments Against Invoices and Calculate Balances

    drew.allen - Wednesday, January 25, 2017 8:37 AM

    The following article discusses something similar to this.

    January 25, 2017 at 8:41 am

    #1924883

  • RE: Urgent Help - How to start SQL Server Service

    ramana3327 - Wednesday, January 25, 2017 8:25 AM

    What will happen to the SQL Server if they restart the system?

    It'll stop when the...

    January 25, 2017 at 8:31 am

    #1924876

  • RE: Merging timeseries data to a timeseries(FromDate, ToDate) table

    But if, as you said, the data in the second table is data that was missing from the first table, there won't be any duplicates.  Unless I'm missing something else,...

    January 25, 2017 at 8:24 am

    #1924873

  • RE: Merging timeseries data to a timeseries(FromDate, ToDate) table

    I'm almost certainly missing something here, but could it be as simple as this?

    INSERT INTO SymbolHistory_tbl (
        SymbolTypeID
    ,   SymbolValue
    ,   FromDate
    ,...

    January 25, 2017 at 8:12 am

    #1924866

  • RE: Urgent Help - How to start SQL Server Service

    ramana3327 - Wednesday, January 25, 2017 7:32 AM

    Currently, I can't able. Not able to RDP.
    I tried to start the agent but it...

    January 25, 2017 at 7:44 am

    #1924857

  • RE: Urgent Help - How to start SQL Server Service

    Do you have any way of connecting to the server's event log to see what's happening on the server?  If not, ask your server admin to help you.

    John

    January 25, 2017 at 7:26 am

    #1924849

  • RE: Expired subscription clean up Agent job failing

    Alex

    It sounds as if it may be the cause, but then I wonder why a lot more people don't have this problem.  Are you on the latest...

    January 25, 2017 at 7:04 am

    #1924839

  • RE: Urgent Help - How to start SQL Server Service

    If you can run queries, the service is running.  What is the exact nature of your problem?

    John

    January 25, 2017 at 7:01 am

    #1924837

  • RE: Combining 2 different datasets

    Trybbe - Wednesday, January 25, 2017 5:30 AM

    Thanks John, I was hoping that there is an alternative approach but it looks like...

    January 25, 2017 at 5:35 am

    #1924819

  • RE: Expired subscription clean up Agent job failing

    alex.palmer - Wednesday, January 25, 2017 4:56 AM

    Hi

    The "Expired subscription clean up" agent job, which is part of the merge replication running...

    January 25, 2017 at 5:06 am

    #1924816

  • RE: Combining 2 different datasets

    I can't think why you'd want to do this, but assuming there's a good reason, there are two things you need to do.  First, make the number of columns...

    January 25, 2017 at 4:41 am

    #1924814

  • RE: Upgradation and MIgration

    Narine M - Wednesday, January 25, 2017 2:34 AM

    Hi All,
    What is the difference between migration and upgradation in SQL SERVER. Can any...

    January 25, 2017 at 2:47 am

    #1924807

  • RE: User Permission to view Only View not base tables

    Rechana Rajan - Tuesday, January 24, 2017 11:53 PM

    So the permission chain will break if the owner of the objects is...

    January 25, 2017 at 2:32 am

    #1924805

  • RE: Get rid of duplicated timestamp

    Daniel

    My guess is that you ran your INSERT statement three times, and the triplication originates in your numbers table.  I ran the code you posted and I...

    January 24, 2017 at 9:51 am

    #1924666

  • RE: User Permission to view Only View not base tables

    Rechana Rajan - Tuesday, January 24, 2017 4:28 AM

    Thanks Again John.

    Please find the  result  below

    class_desc    Grantee    permission_name    state_desc    ObjectName    InSchema    minor_id
    DATABASE    TEST    CONNECT    GRANT    NULL    NULL    0
    OBJECT_OR_COLUMN    TEST    SELECT    GRANT    View_1    dbo    0

    I don't know what's going on, then....

    January 24, 2017 at 4:42 am

    #1924590

    • Viewing 15 posts - 1,936 through 1,950 (of 7,187 total)