Forum Replies Created

Viewing 15 posts - 1,486 through 1,500 (of 8,731 total)

  • RE: Question about indexing

    itmasterw 60042 - Monday, March 13, 2017 9:41 AM

    Hi,
    I am trying to learn about indexing.
    I have looked all over and cannot get...

    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 13, 2017 at 10:27 am

    #1932908

  • RE: Importing data - want to reject data into a table using tsql code in a SP

    lkennedy76 - Friday, March 10, 2017 12:01 PM

    I am looking for some tsql code to help me on a nightly import job....

    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 10, 2017 at 12:29 pm

    #1932781

  • RE: How to write if condition

    I believe that you're looking for functionality given by precedence constraints. These are the arrows that define the order of the tasks (you can double click on them).

    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 10, 2017 at 8:39 am

    #1932726

  • RE: need help writing the codes for this

    sergehermane - Thursday, March 9, 2017 9:10 PM

    I already did this but i got stucked in the middle
    please help

    Why did...

    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 10, 2017 at 8:27 am

    #1932719

  • RE: Encapsulating complex logic without using a scalar UDF

    jcelko212 32090 - Thursday, March 9, 2017 3:35 PM

    >> As the complex CASE statement [sic] is executed in multiple places, 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

    March 10, 2017 at 7:44 am

    #1932708

  • RE: Encapsulating complex logic without using a scalar UDF

    Aaron N. Cutshall - Thursday, March 9, 2017 12:14 PM

    Phil,
    This is intriguing, but doesn't this present the same issue as 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 9, 2017 at 12:30 pm

    #1932591

  • RE: Encapsulating complex logic without using a scalar UDF

    Something like this?
    I included an option with an inline table-valued function and one direct option. The function won't have a performance impact.

    CREATE FUNCTION dbo.YearsDifference(...

    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 9, 2017 at 10:12 am

    #1932558

  • RE: Help - How to Efficiently Split a Column of Data

    Here's an option. Make sure that you understand this and ask any questions that you might have. You can find the code for the function in this article.

    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 9, 2017 at 9:02 am

    #1932528

  • RE: T-Sql Query Logic.

    This works for your sample data. Make sure it works for more data and different scenarios.
    The CROSS APPLY is there to prevent repeating the same condition several times.

    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 9, 2017 at 7:11 am

    #1932500

  • RE: Table Schema with Search

    The suggestion about AdventureWorks was to help you design your database. Currently, your problem is on the design, not the 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

    March 8, 2017 at 11:21 am

    #1932372

  • RE: How to parse this, 'F0-B20170225131636437{A^CM.INIT}'

    NineIron - Tuesday, March 7, 2017 12:22 PM

    What is the best way to parse out 'CM.INIT' from 'F0-B20170225131636437{A^CM.INIT}'?

    Can you explain the rules?

    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 7, 2017 at 12:32 pm

    #1932132

  • RE: cursor issue

    savibp3 - Tuesday, March 7, 2017 11:50 AM

    I have stored procedure which has cursor.That procedure executes fine during all times except Monday...

    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 7, 2017 at 12:10 pm

    #1932120

  • RE: Script the table structure ( create table or alter table) for all the tables in the database

    This might help: https://www.sqlservercentral.com/Forums/Topic751783-566-1.aspx

    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 7, 2017 at 11:19 am

    #1932100

  • RE: Table Schema with Search

    What I mean is that the usage of an index is only possible when you search for the beginning of a string. Check some examples in here: http://www.sqlservercentral.com/articles/T-SQL/130558/...

    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 7, 2017 at 9:19 am

    #1932071

  • RE: Table Schema with Search

    No index will help for this. You'll probably want to search inside the strings, so that would make the queries non-SARGable. Full Text Search would work great for the CompleteDescription...

    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 7, 2017 at 8:18 am

    #1932051

Viewing 15 posts - 1,486 through 1,500 (of 8,731 total)