Forum Replies Created

Viewing 15 posts - 646 through 660 (of 8,731 total)

  • RE: Datatype Change

    VastSQL - Tuesday, March 6, 2018 3:08 AM

    Thanks Luis,

    Data get inserted using Linq query and we tried creating a new nvarchar...

    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

    March 6, 2018 at 7:02 am

    #1982073

  • RE: Error when having 2 CTEs

    You're also either missing the closing parenthesis for the first CTE or having an extra opening parenthesis after the WHERE clause.

    EDIT: Did I mention that you have several...

    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

    March 5, 2018 at 12:42 pm

    #1982002

  • RE: Error when having 2 CTEs

    jeffshelix - Monday, March 5, 2018 12:34 PM

    This code results in
    Msg 102, Level 15, State 1, Line 29
    Incorrect syntax near ','.   ...

    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

    March 5, 2018 at 12:40 pm

    #1982001

  • RE: Datatype Change

    VastSQL - Monday, March 5, 2018 5:42 AM

    Changed one of the existing column datatype from varchar(250) to nvarchar(250) but the column still...

    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

    March 5, 2018 at 6:33 am

    #1981932

  • RE: CTE Crazy: Sums, Counts and Pivots I'm missing something here

    Bravo! You really out did yourself, Joe.
    I wonder if anyone can make sense of your post.

    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

    March 1, 2018 at 11:11 am

    #1981689

  • RE: Rounding issue

    PSB - Thursday, March 1, 2018 10:20 AM

    How do I round

    0.85415 to 1 ?

    I am getting a...

    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

    March 1, 2018 at 10:26 am

    #1981671

  • RE: FORMAT that string

    Jedak - Thursday, March 1, 2018 7:52 AM

    The correct answer should be E. None of the above.  Store postal codes as string...

    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

    March 1, 2018 at 9:06 am

    #1981648

  • RE: How to handle very large dataset

    Something that might slow down inserts, but could really help is to add a bit column to the table to identify the most recent row. This column needs to be...

    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

    March 1, 2018 at 8:49 am

    #1981640

  • RE: converting values from single column to comma separate string based on other columns

    XML Path is usually the fastest way to create comma-separated lists. However, you shouldn't store them in a table and you shouldn't be concatenating all those values at once.

    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

    March 1, 2018 at 8:35 am

    #1981637

  • RE: union with constant values

    sgmunson - Wednesday, February 28, 2018 2:37 PM

    I noticed that your query does not identify the data type of the @Grouping variable. ...

    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

    February 28, 2018 at 3:18 pm

    #1981568

  • RE: union with constant values

    You should change your UNION to UNION ALL

    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

    February 28, 2018 at 10:58 am

    #1981511

  • RE: union with constant values

    Is it possible that you have a group that is called everyone? The numbers are different on your results.

    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

    February 28, 2018 at 10:55 am

    #1981509

  • RE: CTE Crazy: Sums, Counts and Pivots I'm missing something here

    drew.allen - Wednesday, February 28, 2018 8:42 AM

    Luis Cazares - Wednesday, February 28, 2018 7:41 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

    February 28, 2018 at 8:50 am

    #1981478

  • RE: CTE Crazy: Sums, Counts and Pivots I'm missing something here

    Your query looks so overwhelming when it can be so simple:

    SELECT CAST( td.CallDateTime AS DATE),
       COUNT(CASE WHEN td.CallTypeId = 1 THEN 1 END) AS [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

    February 28, 2018 at 7:41 am

    #1981458

  • RE: Are the posted questions getting worse?

    jasona.work - Tuesday, February 27, 2018 1:02 PM

    GilaMonster - Tuesday, February 27, 2018 12:34 PM

    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

    February 27, 2018 at 1:06 pm

    #1981352

Viewing 15 posts - 646 through 660 (of 8,731 total)