Forum Replies Created

Viewing 15 posts - 3,496 through 3,510 (of 8,731 total)

  • RE: converting the nvarchar value 'MSalreadyhavegeneration' ?

    A view is nothing else than a saved query. It has no compilation by itself and it's not aware of the values stored in the underlying tables.

    That said, somewhere in...

    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

    January 22, 2016 at 9:56 am

    #1853845

  • RE: Temp Table column suddenly becomes NOT NULL ???

    Eirikur Eiriksson (1/22/2016)

    Luis and Jack, you are both right in the terms of suppressing the problem, preventing it is in my mind a better approach.

    😎

    Fixing the whole code would 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

    January 22, 2016 at 9:11 am

    #1853830

  • RE: converting rows to columns

    vinod.joshi040 (1/22/2016)

    Hi folks,

    I'm facing problem while using cross tab, what my problem is:

    sample data:

    DCI_SNODCI_COMPOUNDDCI_BLOCKDCI_PARAMETERDCI_DESCRIPTIONDCI_UNIT

    1 U1001AI1 AI010301PNT...

    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

    January 22, 2016 at 9:06 am

    #1853829

  • RE: Today's Random Word!

    whereisSQL? (1/22/2016)

    crookj (1/22/2016)

    Ed Wagner (1/22/2016)

    Villain

    Joker

    Laugh

    last

    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

    January 22, 2016 at 8:33 am

    #1853813

  • RE: Temp Table column suddenly becomes NOT NULL ???

    You're using sysname as datatype for your columns. Sysname is by default NOT NULL.

    You're effectively not inserting any null values explicitly, but you were missing the column in your insert...

    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

    January 22, 2016 at 8:00 am

    #1853803

  • RE: Help constructing a complex query

    Now, either you build a query with all possible columns or you build a dynamic query to get the columns available.

    I'll suggest that you go for the first option 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

    January 21, 2016 at 1:08 pm

    #1853628

  • RE: Today's Random Word!

    djj (1/21/2016)

    Ed Wagner (1/21/2016)

    crookj (1/21/2016)

    Igor Micev (1/21/2016)

    Ed Wagner (1/21/2016)

    DonlSimpson (1/21/2016)

    Igor Micev (1/21/2016)

    Grumpy DBA (1/21/2016)

    Ed Wagner (1/21/2016)

    djj (1/21/2016)

    BL0B_EATER (1/21/2016)

    Stuart Davies (1/21/2016)

    Ed Wagner (1/20/2016)

    Ray K (1/20/2016)

    djj (1/20/2016)

    Roasted

    Chicken

    Ribs

    Spare

    Tyre

    Tired

    Sleep

    Insomnia

    AlwaysOn

    Availability

    Phone

    Cell

    Red (blood)

    White

    Blue

    France

    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

    January 21, 2016 at 1:05 pm

    #1853627

  • RE: Get rid of path in Tabs

    What version of SSMS are you working with? I don't have that problem with version 11.0.2100.60 which is basically a version of 2012.

    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

    January 21, 2016 at 11:43 am

    #1853599

  • RE: What is recursion?

    MMartin1 (1/21/2016)

    Chris Wooding (1/21/2016)

    To answer the original question; this

    http://www.sqlservercentral.com/Forums/Topic1752249-1292-1.aspx

    is recursion.

    I would also call that an infinite loop. A Recursive function should have a cut off point. 😛

    There is one,...

    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

    January 21, 2016 at 11:37 am

    #1853596

  • RE: T-SQL CASE WHEN take latest value

    Any questions, comments or improvements?

    WITH CTE AS(

    SELECT m.date,

    CASE WHEN EXISTS( SELECT * FROM #mytable c

    ...

    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

    January 21, 2016 at 11:29 am

    #1853593

  • RE: Help constructing a complex query

    It seems that you have an EAV design which can be a problem with queries and you might want to change it to a properly normalized model.

    To query this designs,...

    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

    January 21, 2016 at 10:17 am

    #1853562

  • RE: Help constructing a complex query

    From the other thread:

    Luis Cazares (1/21/2016)

    You just need to use 2 joins in your query.

    There's an example at the bottom of this page: http://www.sql-join.com/

    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

    January 21, 2016 at 9:48 am

    #1853544

  • RE: T-SQL CASE WHEN take latest value

    Are you looking for something like this?

    SELECT m.date,

    CASE WHEN m.date < '20000530' AND m.industry = 'Corporate'

    THEN...

    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

    January 21, 2016 at 9:26 am

    #1853537

  • RE: Find foreign alphabet characters in a column

    Do you want each character? Or the rows that contain the foreign characters?

    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

    January 21, 2016 at 8:45 am

    #1853521

  • RE: Help constructing a complex query

    Duplicate thread. Please reply in here: http://www.sqlservercentral.com/Forums/Topic1754550-392-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

    January 21, 2016 at 8:31 am

    #1853508

Viewing 15 posts - 3,496 through 3,510 (of 8,731 total)