Forum Replies Created

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

  • RE: Convert number stored as text to number

    If you're doing this to display in Excel then I wouldn't bother putting the thousand separators in at all.  Just spit out the numbers, and let Excel handle the...

    January 26, 2017 at 5:47 am

    #1925027

  • RE: Error converting data type nvarchar to numeric

    lskidgel - Wednesday, January 25, 2017 9:20 AM

    John Mitchell-245523 - Wednesday, January 25, 2017 8:49 AM

    January 25, 2017 at 9:37 am

    #1924902

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

    Rehan Ahmad - Wednesday, January 25, 2017 9:15 AM

    Thanks John for the referred article , i will try it. I am...

    January 25, 2017 at 9:21 am

    #1924898

  • RE: Error converting data type nvarchar to numeric

    lskidgel - Wednesday, January 25, 2017 8:38 AM

    I am at my wits end.  I have a stored procedure that gives me the...

    January 25, 2017 at 8:49 am

    #1924890

  • 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

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