Forum Replies Created

Viewing 15 posts - 886 through 900 (of 8,731 total)

  • RE: Select Statement

    bmg002 - Friday, October 20, 2017 11:25 AM

    Luis Cazares - Friday, October 20, 2017 11:07 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

    October 20, 2017 at 11:33 am

    #1964552

  • RE: How to do this results table - Change Report (not a report though result set)

    Well, I won't do all the process to render the html. Can you post something easier to read? You could just get a SELECT with the results you need.

    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

    October 20, 2017 at 11:12 am

    #1964544

  • RE: Select Statement

    bmg002 - Friday, October 20, 2017 10:55 AM

    One will return all of the columns and data from table1, the other will return...

    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

    October 20, 2017 at 11:07 am

    #1964543

  • RE: Having trouble displaying a date in a certain format...

    Jeff Moden - Friday, October 20, 2017 10:50 AM

    jcelko212 32090 - Friday, October 20, 2017 10:35 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

    October 20, 2017 at 11:01 am

    #1964541

  • RE: Sum of last 9 records

    Thom A - Friday, October 20, 2017 9:07 AM

    SQL Server 2008 Luis/Chris. 😉

    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

    October 20, 2017 at 10:58 am

    #1964539

  • RE: Are the posted questions getting worse?

    Hugo Kornelis - Friday, October 20, 2017 4:55 AM

    Sean Lange - Thursday, October 19, 2017 3:30 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

    October 20, 2017 at 10:49 am

    #1964534

  • RE: Trying to speed up this 'GetWorkingDays' function.

    Here's a sligthly faster version than the original one. I'm not sure what happens if we add a proper holidays table.
    I tried by adding a filtered index to...

    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

    October 20, 2017 at 10:43 am

    #1964531

  • RE: Sum of last 9 records

    A simpler solution, assuming that you can only get zeros and ones.

    WITH SampleData AS (
    SELECT * FROM (VALUES
    (1, 62, 0),(2,...

    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

    October 20, 2017 at 8:58 am

    #1964506

  • RE: Data in a row is being updated somewhere else during a stored procedure

    EDIT: This is a worse version of Lynn's code. I didn't see it before posting.

    How about preventing any updates done to table_a by other connections?

    [code...

    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

    October 19, 2017 at 1:13 pm

    #1964413

  • RE: Handling string column with dates

    Here's another possible solution, pure brute force.

    WITH
    E(n) AS(
      SELECT n FROM (VALUES(0),(0),(0),(0),(0),(0),(0),(0),(0),(0))E(n)
    ),
    E2(n) AS(
      SELECT a.n FROM E a, E b

    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

    October 18, 2017 at 2:24 pm

    #1964291

  • RE: Handling string column with dates

    GrassHopper - Wednesday, October 18, 2017 1:56 PM

    starts to show data and before completing, this error comes up:

    The conversion of 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

    October 18, 2017 at 2:10 pm

    #1964286

  • RE: Handling string column with dates

    GrassHopper - Wednesday, October 18, 2017 8:22 AM

    I imported a csv file that has a column with dates.  The column is 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

    October 18, 2017 at 1:38 pm

    #1964277

  • RE: Help in finding events in two-week period

    dhanekulakalyan - Tuesday, October 17, 2017 7:08 PM

    Hi Luis,
    I think I understand this but the way you used LAG function for...

    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

    October 18, 2017 at 7:11 am

    #1964199

  • RE: Help in finding events in two-week period

    dhanekulakalyan - Tuesday, October 17, 2017 2:32 PM

    It is working for me, Thank you for keeping this reply.

    Thank you for the feedback....

    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

    October 17, 2017 at 3:39 pm

    #1964107

  • RE: Something interesting about patindex

    Did you find a real-world problem with this functionality? Or were you experimenting?

    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

    October 17, 2017 at 1:50 pm

    #1964100

Viewing 15 posts - 886 through 900 (of 8,731 total)