Forum Replies Created

Viewing 15 posts - 571 through 585 (of 8,731 total)

  • RE: Small numbers in the cube shown as zero in excel - rounding error?

    Negmat 18367 - Monday, April 23, 2018 2:46 PM

    Hi Luis,

    I'm very new to SSAS.

    Where would I change the format?

    I've looked around the...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    April 23, 2018 at 2:58 pm

    #1987943

  • RE: Small numbers in the cube shown as zero in excel - rounding error?

    Negmat 18367 - Monday, April 23, 2018 12:06 PM

    Hi all,

    I've created a Tabular SSAS Cube recently.  Certain numbers within the cube are...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    April 23, 2018 at 12:30 pm

    #1987931

  • RE: Converting a MS Access query to SQL

    By the way, I strongly recommend that you add the week day number column to your Dates table, as well as other relevant attributes (year, month, week, fiscal year, etc)

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    April 23, 2018 at 11:21 am

    #1987922

  • RE: Converting a MS Access query to SQL

    ordnance1 - Monday, April 23, 2018 9:10 AM

    I am attempting to move a database from MS Access to SQL Server. For the...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    April 23, 2018 at 9:31 am

    #1987907

  • RE: How to update with new ID

    vijay_uitrgpv - Monday, April 23, 2018 6:29 AM

    Thank you very much this is working as expected

    Have you read the article I...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    April 23, 2018 at 6:35 am

    #1987876

  • RE: How to update with new ID

    You should probably scratch what I mentioned and read what I wrote on this article:
    http://www.sqlservercentral.com/articles/set-based+loop/127670/

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    April 23, 2018 at 6:21 am

    #1987871

  • RE: How to update with new ID

    Depending on the logic, there are 2 options. Be sure to understand them as they're very different.

    Declare @a table ( id int, id_2 int)
    Insert into...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    April 23, 2018 at 6:19 am

    #1987870

  • RE: Removing stored procedures to move to cloud

    Jason A. Long - Thursday, April 19, 2018 11:12 PM

    Keven Boles is far more eloquent than I am, so I'll just...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    April 22, 2018 at 2:57 pm

    #1987807

  • RE: How to check sql 2000 compatibility on sql server 2012 or above?

    sgmunson - Friday, April 20, 2018 6:30 AM

    Just to add some specific content to this thread, here's some things SQL 2000 can...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    April 20, 2018 at 11:37 am

    #1987723

  • RE: Can we do Parse JSON file in SQL server 2014 version?

    Lynn Pettis - Monday, April 16, 2018 12:35 PM

    Luis Cazares - Monday, April 16, 2018 11:06 AM

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    April 20, 2018 at 9:49 am

    #1987693

  • RE: Splitting a string after the first space after the 10th character?

    Sean Lange - Thursday, April 19, 2018 12:37 PM

    ... I can't come up with a reason that makes any sense at...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    April 20, 2018 at 9:46 am

    #1987691

  • RE: Sql Loader - oracle

    sgmunson - Thursday, April 19, 2018 6:09 AM

    Oh, okay... didn't know we were talking about going in the opposite direction from...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    April 19, 2018 at 8:49 am

    #1987539

  • RE: How to check sql 2000 compatibility on sql server 2012 or above?

    ChrisM@Work - Thursday, April 19, 2018 6:48 AM

    Yes:

    https://docs.microsoft.com/en-us/sql/t-sql/statements/alter-database-transact-sql-compatibility-level?view=sql-server-2017
    Remember to change it back afterwards

    That won't work for 2012+...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    April 19, 2018 at 7:53 am

    #1987522

  • RE: The SQL Joke Thread

    - Master, why am I not good at SQL?
    - Have you seen the sunset from the mountain?
    - Yes, master
    - Have you seen a bird...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    April 19, 2018 at 7:34 am

    #1987514

  • RE: Convertion of integer to Datetime format

    hamed.alzubide - Thursday, April 19, 2018 2:37 AM

    Lowell - Tuesday, August 18, 2009 6:11 AM

    Dave...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    April 19, 2018 at 6:35 am

    #1987494

Viewing 15 posts - 571 through 585 (of 8,731 total)