Forum Replies Created

Viewing 15 posts - 3,856 through 3,870 (of 8,731 total)

  • RE: SQL Column update with comparison with another table

    Probably this will return the expected rows?

    Select dbo.R_ResrvStock.Vin,

    R_Txt_Temp.Vinnumber,

    R_Txt_Temp.Model_Code

    from dbo.R_ResrvStock

    inner join R_Txt_Temp on Right (RTRIM(dbo.R_ResrvStock.Vin),LEN(R_Txt_Temp.VinNumber))=R_Txt_Temp.VinNumber

    Without DDL and Sample data as 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

    November 11, 2015 at 8:50 am

    #1839141

  • RE: Suggested training for accidental DBAs

    webrunner (11/11/2015)

    Hello experts,

    Does anyone have advice about what training might be good for an accidental DBA? I have a good deal of hands-on experience at this point (~7 years)...

    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

    November 11, 2015 at 8:45 am

    #1839138

  • RE: Blanking Out On How Joins Work

    jarid.lawson (11/10/2015)

    I've never had a left join react like that for me.

    Whenever using this syntax it will happen. You might have been very lucky for not encountering this problem before....

    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

    November 11, 2015 at 8:37 am

    #1839133

  • RE: SQL Pivot Table Nulls

    Or try the alternative using cross tabs.

    SELECT [Station_ID],

    [Case_No],

    [Date],

    ...

    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

    November 11, 2015 at 7:50 am

    #1839109

  • RE: Blanking Out On How Joins Work

    The [font="Courier New"]Where TCC.Cntac_Dt >= Cast(Convert(Varchar,GetDate()-120,101) As DateTime)[/font] clause is changing the LEFT JOIN into an INNER JOIN.

    I usually code it like this:

    Select TCH.Cas_ID

    ,TCCL.Cl_ID

    From dbo.TCas_History TCH

    Inner...

    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

    November 10, 2015 at 1:13 pm

    #1838955

  • RE: Are the posted questions getting worse?

    Grant Fritchey (11/10/2015)

    Steve Jones - SSC Editor (11/10/2015)

    jasona.work (11/10/2015)

    Anyone feel like stopping by to help me paint some rooms in my house Thanksgiving weekend? There'll be left-over turkey and...

    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

    November 10, 2015 at 12:51 pm

    #1838946

  • RE: Are the posted questions getting worse?

    Jack Corbett (11/10/2015)

    Is anyone receiving forum notification emails? I'm not.

    I received a notification for your post.

    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

    November 10, 2015 at 12:29 pm

    #1838942

  • RE: DataType Conversion

    ScottPletcher (11/10/2015)

    David Rich (11/9/2015)

    While going through execution plan i observed this warning

    Type conversion in expression (CONVERT_IMPLICIT(varchar(255),[e].[abc],0)) may affect "CardinalityEstimate" in query plan choice

    and this is getting converted to nvarchar(255)....

    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

    November 10, 2015 at 11:56 am

    #1838933

  • RE: WHERE Clause in PROC Inquiry

    From Books Online:

    The full syntax of the SELECT statement is complex, but the main clauses can be summarized as:

    [ WITH { [ XMLNAMESPACES ,] [ <common_table_expression> ] } ]

    SELECT select_list...

    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

    November 10, 2015 at 11:54 am

    #1838932

  • RE: I miss SQL Server!!!!

    I feel your pain.

    I was in a similar dark place too, but came back to the light side of the force.

    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

    November 10, 2015 at 11:30 am

    #1838923

  • RE: Today's Random Word!

    jasona.work (11/10/2015)

    DonlSimpson (11/10/2015)

    Luis Cazares (11/10/2015)

    jasona.work (11/10/2015)

    anthony.green (11/10/2015)

    crookj (11/10/2015)

    djj (11/10/2015)

    anthony.green (11/10/2015)

    Ed Wagner (11/10/2015)

    anthony.green (11/10/2015)

    Ed Wagner (11/9/2015)

    #MyHead

    Bobblehead

    Dashboard

    tableau

    Picture

    Perfect

    Sublime

    Submarine

    yellow

    Blue

    NO! Red!

    (aaaaahhhhh!)

    UNO!

    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

    November 10, 2015 at 9:37 am

    #1838905

  • RE: Today's Random Word!

    jasona.work (11/10/2015)

    anthony.green (11/10/2015)

    crookj (11/10/2015)

    djj (11/10/2015)

    anthony.green (11/10/2015)

    Ed Wagner (11/10/2015)

    anthony.green (11/10/2015)

    Ed Wagner (11/9/2015)

    #MyHead

    Bobblehead

    Dashboard

    tableau

    Picture

    Perfect

    Sublime

    Submarine

    yellow

    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

    November 10, 2015 at 9:21 am

    #1838898

  • RE: Problems with INSERT INTO OPENROWSET

    It seems that the PostgreSQL server is closing the connection or limiting the resources. You might need to change some settings. I'm sorry that I can't help you with much...

    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

    November 10, 2015 at 9:15 am

    #1838895

  • RE: complicated sorting parent and child records

    Luis Cazares (11/10/2015)

    Can you define "not working" and post expected results based on the new sample data?

    P.S. Your new sample data doesn't have the same DDL as the previous one.

    If...

    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

    November 10, 2015 at 8:54 am

    #1838885

  • RE: Are the posted questions getting worse?

    jasona.work (11/10/2015)

    Anyone feel like stopping by to help me paint some rooms in my house Thanksgiving weekend? There'll be left-over turkey and I'll even spring for a case 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

    November 10, 2015 at 8:45 am

    #1838880

Viewing 15 posts - 3,856 through 3,870 (of 8,731 total)