Forum Replies Created

Viewing 15 posts - 1,711 through 1,725 (of 8,731 total)

  • RE: User defined variable value is not being updated in the Script Task

    1. How are you populating your variable? If the variable is not populated correctly, it will always show 0 (or the initial value that you have set).

    2. The warnings 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

    December 28, 2016 at 10:47 am

    #1919907

  • RE: An evaluation copy of SQL 2016?

    Doctor Who 2 (12/27/2016)

    That might be what I've done wrong. Or put differently, what I've not done. I don't think I enrolled in the Visual Studio Dev Essentials program. How...

    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

    December 27, 2016 at 4:00 pm

    #1919797

  • RE: Exclude the data starts with ING

    Some examples based on your last post.

    SELECT ID,

    SUBSTRING(ID, 4, 8000),

    STUFF(ID, 1, 3, ''),

    CASE WHEN ID LIKE 'ING%'

    ...

    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

    December 27, 2016 at 2:19 pm

    #1919780

  • RE: Missing user defined variable in the Script Task Editor

    Check the scope of the variable.

    To keep it safe, I usually keep the scope of all the variables as package wide.

    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

    December 27, 2016 at 2:01 pm

    #1919775

  • RE: Exclude the data starts with ING

    Chris.McCarty (12/27/2016)

    Hello,

    how to write a query - to exclude the field that starts with ING

    select * form table where ID NOT LIKE 'ING%' ?

    I want to exclude ING from 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

    December 27, 2016 at 1:57 pm

    #1919772

  • RE: Exclude the data starts with ING

    Have you tried the query that you posted? Did it return the expected results? If not, what's the problem?

    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

    December 27, 2016 at 1:42 pm

    #1919768

  • RE: Are the posted questions getting worse?

    Carrie Fisher is now one with the force.[/url] :crying:

    Can 2016 end already?

    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

    December 27, 2016 at 11:17 am

    #1919740

  • RE: An evaluation copy of SQL 2016?

    This should show if it's developer or evaluation edition.

    SELECT @@VERSION

    Maybe you were contacted as a follow up from a CTP or some other version previous to the final release.

    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

    December 27, 2016 at 11:05 am

    #1919739

  • RE: IMPORT FILE TXT USING VISUAL STUDIO 2015

    If you're new to this, I'd suggest you to use the Import/Export wizard and review the results.

    There are also a lot of tutorials either written or on video. The process...

    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

    December 27, 2016 at 7:58 am

    #1919697

  • RE: How can I query it fast ?

    Why are you doing this in batches? It's usually faster to do a single load than multiple ones.

    Are the columns indexed?

    Are you really trying to return a million rows result...

    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

    December 27, 2016 at 7:25 am

    #1919692

  • RE: Very Large Transaction Causing Error 'Attempting to set a non-NULL-able column's value to NULL'

    If you're inserting into a non-nullable column from a value that could be null, ALWAYS use ISNULL() or COALESCE().

    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

    December 16, 2016 at 10:15 am

    #1918450

  • RE: The inline TVF

    TomThomson (12/15/2016)

    The quasi-BNF for inline TVFs at the CREATE FUNCTION (Transact-SQL) page is quite amusing: it gives you four options for the parentheses: have both, have neither, have just 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

    December 15, 2016 at 10:36 am

    #1918247

  • RE: Must declare the scalar variable appears in SSMS and not in VS (SSDT)

    Would this do the same thing?

    It's hard to know if there's no sample data and no code for the function.

    INSERT INTO [RES-DW].[ROW].LogEntry (LogGUID, LogDatetime, MilliSeconds, LogType, LogAction, LogResult, AppGuid)

    SELECT l.[rowGUID],

    ...

    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

    December 15, 2016 at 10:31 am

    #1918246

  • RE: The inline TVF

    Sean Lange (12/15/2016)

    george.p (12/15/2016)

    Sean Lange (12/15/2016)

    george.p (12/15/2016)

    I missed the title so I assumed it meant Scalar functions 🙁

    You're one of those people that puts all of the details in 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

    December 15, 2016 at 9:38 am

    #1918233

  • RE: Results to new table

    Jeff Moden (12/15/2016)

    {EDIT} Went from 0 replies to all those in the time it took me to type my answer.

    Gail, Lowell and I posted almost at the same time....

    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

    December 15, 2016 at 8:58 am

    #1918217

Viewing 15 posts - 1,711 through 1,725 (of 8,731 total)