Forum Replies Created

Viewing 15 posts - 736 through 750 (of 8,731 total)

  • RE: Pivot Row to Columns

    I'd recommend that you read the following articles:
    Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - SQLServerCentral
    Cross Tabs and Pivots, Part...

    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

    January 10, 2018 at 6:08 am

    #1975256

  • RE: Weird Character

    drew.allen - Tuesday, January 9, 2018 1:13 PM

    I copied and pasted the character from your post and I got that it was...

    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

    January 9, 2018 at 1:29 pm

    #1975168

  • RE: Weird Character

    That's probably because you need to handle the character as part of a unicode string. It's not the same to have '_--' than to have N'_--'. You should also use...

    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

    January 9, 2018 at 1:06 pm

    #1975159

  • RE: SELECT all negative values, that have a positive value

    Unless anyone has a better idea.

    DECLARE @data TABLE(
      id int,
      grp int
    );
    INSERT INTO @data
    VALUES ( 100,1), ( 101,1), ( 102,1), (...

    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

    January 9, 2018 at 11:14 am

    #1975139

  • RE: How to Pivot Financial Data Rows Into Dynamic Columns

    YSLGuru - Tuesday, January 9, 2018 8:40 AM

    I realize your last reply is 2 years past but I'm revisiting this and...

    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

    January 9, 2018 at 10:09 am

    #1975124

  • RE: Selecting records where column contains specific integer in specific position

    If you're looking for valid dates and you're using SQL Server 2014, you could simply try to convert them.

    SELECT TRY_CONVERT( date, CONVERT( char(8), SomeDateInteger), 112)

    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

    January 9, 2018 at 9:51 am

    #1975111

  • RE: SQL Not working in QlikView

    What about removing the temp table from the code?

    LOAD *;
    SQL
    SELECT de.pate_tempor,
       de.prod_codigo,
       concepto = Convert(char(50),'FOB Fruta Exportacion'),...

    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

    January 9, 2018 at 7:14 am

    #1975070

  • RE: Convert from datetime to varchar to int

    Drop the "var", just use char(8).

    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

    January 8, 2018 at 10:30 am

    #1974937

  • RE: Wrong regional settings (decimal point)

    GilaMonster - Monday, January 8, 2018 9:53 AM

    Change it via the machine's Control Panel

    Thank you. But it didn't work. I have no...

    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

    January 8, 2018 at 10:26 am

    #1974936

  • RE: Searching strings

    richardmgreen1 - Monday, January 8, 2018 2:58 AM

    Sorry folks, can't even add in a computed column (persisted or otherwise).
    I know this is...

    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

    January 8, 2018 at 6:51 am

    #1974888

  • RE: How to fix my datetime seconds

    team.bernard - Friday, January 5, 2018 1:41 PM

    Hello,

    I have the list of hours part allowed :

    08:00:00:00.000
    10:00:00:00.000
    12:00:00:00.000
    14:00:00:00.000
    16:00:00:00.000
    18:00:00:00.000

    I want to fix datetime in my...

    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

    January 5, 2018 at 1:58 pm

    #1974769

  • RE: How to fix my datetime seconds

    team.bernard - Friday, January 5, 2018 1:06 PM

    Hello,

    I have an application with a list of agenda.
    One person can assign meetings to someone...

    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

    January 5, 2018 at 1:32 pm

    #1974764

  • RE: Searching strings

    Why do you have IDs that are that long? If an ID is 1509 characters long, it might have lost its purpose.
    Instead of going for Full Text Search, which...

    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

    January 5, 2018 at 7:41 am

    #1974687

  • RE: Dividing partial count by total count

    Here's a different way. It might be better or worse, so you should test.

    WITH CTE AS(
      SELECT class, COUNT(item_id) Item_count
      FROM jc_item_class
     ...

    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

    January 4, 2018 at 1:48 pm

    #1974544

  • RE: Generate script

    gary1 - Thursday, January 4, 2018 10:59 AM

    HI,
    We have 100 databases and need to take tail back up. I'm trying to generate...

    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

    January 4, 2018 at 11:45 am

    #1974512

Viewing 15 posts - 736 through 750 (of 8,731 total)