Forum Replies Created

Viewing 15 posts - 2,401 through 2,415 (of 8,731 total)

  • RE: Object Explorer Details & undocumented system stored procedures

    Running profiler against the server then navigating through the object explorer details tab, generates different dynamic sql calls.

    AFAIK, that would mean that there's no stored procedure and those are ad-hoc...

    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

    August 1, 2016 at 12:42 pm

    #1893034

  • RE: Service pack info

    SQL-DBA-01 (8/1/2016)

    Strange. I selected the right answer but I declared me that my choice was wrong!

    SELECT SERVERPROPERTY('productversion') as ProductVersion, SERVERPROPERTY('productlevel') as ProductLevel, SERVERPROPERTY('edition') as Edition, SERVERPROPERTY('ProductMajorVersion') as ProductMajorVersion, SERVERPROPERTY('ProductMinorVersion') as...

    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

    August 1, 2016 at 11:51 am

    #1893020

  • RE: Powershell script for SSIS 2012 build and deployment

    Gary Varga (7/29/2016)

    robert.sterbal 56890 (7/20/2016)

    Posted 5/13/2016 2:06:20 PM

    by

    latitiacasta

    Group: General Forum Members

    Last Login: 5/13/2016 4:34:38 PM

    Points: 47, Visits: 153

    and they never came back.

    Were we too mean?

    Given that your reply...

    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

    August 1, 2016 at 10:32 am

    #1893005

  • RE: Datediff not recognised

    Use the SSIS syntax.

    DATEADD("dd", DATEDIFF("dd", (DT_DATE) "1900-01-01", GETDATE()) - 1, (DT_DATE) "1900-01-01")

    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

    August 1, 2016 at 9:01 am

    #1892974

  • RE: Strange insert time

    Have you tried using SSIS? It's great for this sort of things.

    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

    August 1, 2016 at 7:56 am

    #1892952

  • RE: ISNULL function does not allow concatenating CHAR's in SQL 2008R2 or earlier

    tskelley (8/1/2016)

    Yes, and thank for your pointing out the sarcasm. I have removed it from my reply. I was a little frustrated on this one, and found 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

    August 1, 2016 at 7:51 am

    #1892949

  • RE: How do we avoid junk in the VARCHAR fields ?

    Maybe like this? Why do you have different validations for names and other values?

    UPDATE [MEMBER].[IMP_MEMBER_INT]

    SET

    [ContactLastName] = CASE WHEN LEN(LNAME) >...

    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

    August 1, 2016 at 7:31 am

    #1892946

  • RE: Select Names Based In Ids

    To do what you're asking for, you need to split the values and store them in individual rows. Of course, you can split them and join them again in 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

    August 1, 2016 at 7:20 am

    #1892943

  • RE: Select Statement SubQuery in the From Clause

    You don't have a Code column in your derived table (subquery). Either you add it to the query or remove it from the join clause.

    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

    August 1, 2016 at 7:09 am

    #1892938

  • RE: Reading from JSON

    Here's probably the best option for versions 2014 or lower: https://www.simple-talk.com/sql/t-sql-programming/consuming-json-strings-in-sql-server/

    Although, my suggestions would be to stop storing JSON in SQL Server and normalize the data.

    In SQL Server 2016 there's...

    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

    August 1, 2016 at 7:03 am

    #1892935

  • RE: Service pack info

    The lack of mention of the Service Pack when querying @@Version might not be a bug from 2014, but one depending on the way it was installed.

    My local installation of...

    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

    August 1, 2016 at 6:53 am

    #1892927

  • RE: ISNULL function does not allow concatenating CHAR's in SQL 2008R2 or earlier

    tskelley (7/31/2016)

    Thank you Inspector Holmes. It's actually the SQL from a view being created that is part of a large deployment script.

    You know? Sarcasm isn't a good idea when...

    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

    August 1, 2016 at 6:35 am

    #1892918

  • RE: ISNULL function does not allow concatenating CHAR's in SQL 2008R2 or earlier

    It's working as designed. If you try to concatenate a string with a NULL value, the result will be a NULL value.

    Check the following example:

    SELECT field,

    field...

    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

    July 29, 2016 at 2:19 pm

    #1892720

  • RE: Update all fields in a record except incoming NULL values?

    Since Lowell already posted something, I'll just post the short version.

    update Table1

    SET Field1 = ISNULL( @Field1, Field1),

    Field2 = ISNULL( @Field2, Field2),

    Field3...

    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

    July 29, 2016 at 12:54 pm

    #1892711

  • RE: Are the posted questions getting worse?

    ChrisM@Work (7/29/2016)

    Sean Lange (7/29/2016)

    ChrisM@Work (7/29/2016)

    Sean Lange (7/29/2016)

    ChrisM@Work (7/29/2016)

    Sean Lange (7/29/2016)

    Good grief...the spammers are out in force today.

    Reported as spam

    Sweet!!! Maybe I can get banned!?!?!?!?!

    It's Friday, you can get anything you...

    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

    July 29, 2016 at 10:02 am

    #1892684

Viewing 15 posts - 2,401 through 2,415 (of 8,731 total)