Forum Replies Created

Viewing 15 posts - 751 through 765 (of 859 total)

  • RE: Does anyone have a table of College Majors?

    Each college has their own names and requirements for majors. is there a specific college your looking at or just in general. if in general that is near...

    For faster help in answering any problems Please read How to post data/code on a forum to get the best help - Jeff Moden[/url] for the best way to ask your question.

    For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]

    Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
    Jeff Moden's Cross tab and Pivots Part 1[/url]
    Jeff Moden's Cross tab and Pivots Part 2[/url]

    March 30, 2012 at 4:30 pm

    #1467242

  • RE: Data in tthe same order in which it is inserted

    Jeff Moden (3/30/2012)

    As a side bar, it's always amazed me that people find importance in the order of the data in a file without actually having something in the file...

    For faster help in answering any problems Please read How to post data/code on a forum to get the best help - Jeff Moden[/url] for the best way to ask your question.

    For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]

    Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
    Jeff Moden's Cross tab and Pivots Part 1[/url]
    Jeff Moden's Cross tab and Pivots Part 2[/url]

    March 30, 2012 at 4:10 pm

    #1467236

  • RE: Data in tthe same order in which it is inserted

    PaulB-TheOneAndOnly (3/30/2012)

    opc.three (3/30/2012)

    The only way to ensure the data is not scrambled when inserting into a table is to reduce the "bacth commit size" to 1. Whether bcp, SSIS or...

    For faster help in answering any problems Please read How to post data/code on a forum to get the best help - Jeff Moden[/url] for the best way to ask your question.

    For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]

    Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
    Jeff Moden's Cross tab and Pivots Part 1[/url]
    Jeff Moden's Cross tab and Pivots Part 2[/url]

    March 30, 2012 at 2:12 pm

    #1467180

  • RE: syntax error

    hbtkp (3/30/2012)

    hi

    whats wrong with this exp

    =iif(trim(cstr(Fields!Total.Value ="")),"?",iif(trim(cstr(isnothing(Fields!Total.Value))),"?",Fields!Total.Value))

    plz help

    this is int field

    thats not sql? what program are you using for this. its probably a syntax error as you suggest...

    For faster help in answering any problems Please read How to post data/code on a forum to get the best help - Jeff Moden[/url] for the best way to ask your question.

    For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]

    Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
    Jeff Moden's Cross tab and Pivots Part 1[/url]
    Jeff Moden's Cross tab and Pivots Part 2[/url]

    March 30, 2012 at 2:02 pm

    #1467178

  • RE: FK referencing PK in *same* table

    a.jean89 (3/30/2012)

    This can be kind of common...

    If you have a table 'person'

    in which you store Father and Mother who points on an other row in the Table.

    There is a lot...

    For faster help in answering any problems Please read How to post data/code on a forum to get the best help - Jeff Moden[/url] for the best way to ask your question.

    For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]

    Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
    Jeff Moden's Cross tab and Pivots Part 1[/url]
    Jeff Moden's Cross tab and Pivots Part 2[/url]

    March 30, 2012 at 1:58 pm

    #1467175

  • RE: Subtotals in t-sql

    MyDoggieJessie (3/30/2012)

    Jeff Moden (3/30/2012)

    MyDoggieJessie (3/30/2012)

    You could try this, works pretty wellSELECT

    Pin,

    CDate,

    btn,

    callduration,

    charge

    FROM #gmreport

    ORDER BY pin

    COMPUTE SUM(callduration), SUM(charge) BY pin

    Careful now... that's actually been deprecated not to mention that it will...

    For faster help in answering any problems Please read How to post data/code on a forum to get the best help - Jeff Moden[/url] for the best way to ask your question.

    For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]

    Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
    Jeff Moden's Cross tab and Pivots Part 1[/url]
    Jeff Moden's Cross tab and Pivots Part 2[/url]

    March 30, 2012 at 12:46 pm

    #1467146

  • RE: FK referencing PK in *same* table

    Lowell (3/30/2012)

    we have that in a few tables;

    it's usually something like an Entity and need to to identify the "prime" entity,

    an example might be a table of bank...

    For faster help in answering any problems Please read How to post data/code on a forum to get the best help - Jeff Moden[/url] for the best way to ask your question.

    For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]

    Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
    Jeff Moden's Cross tab and Pivots Part 1[/url]
    Jeff Moden's Cross tab and Pivots Part 2[/url]

    March 30, 2012 at 12:44 pm

    #1467144

  • RE: load data and foreign keys

    opc.three (3/30/2012)

    capn.hector (3/30/2012)

    here in my shop we have a history table that we have no PK on. we just have FK's to the pertinent data and just insert to...

    For faster help in answering any problems Please read How to post data/code on a forum to get the best help - Jeff Moden[/url] for the best way to ask your question.

    For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]

    Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
    Jeff Moden's Cross tab and Pivots Part 1[/url]
    Jeff Moden's Cross tab and Pivots Part 2[/url]

    March 30, 2012 at 11:52 am

    #1467120

  • RE: sql server scheduled job fails if double quote around db name

    Using [MMG-Events] makes for better code portability than relying on quoted identifiers being on.

    For faster help in answering any problems Please read How to post data/code on a forum to get the best help - Jeff Moden[/url] for the best way to ask your question.

    For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]

    Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
    Jeff Moden's Cross tab and Pivots Part 1[/url]
    Jeff Moden's Cross tab and Pivots Part 2[/url]

    March 30, 2012 at 11:49 am

    #1467119

  • RE: Stored Procedure Error

    it may also be DBO.sp_name not DDO. may try that before bugging the dba but if thats not it i think that is the only course of action.

    For faster help in answering any problems Please read How to post data/code on a forum to get the best help - Jeff Moden[/url] for the best way to ask your question.

    For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]

    Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
    Jeff Moden's Cross tab and Pivots Part 1[/url]
    Jeff Moden's Cross tab and Pivots Part 2[/url]

    March 30, 2012 at 11:44 am

    #1467117

  • RE: load data and foreign keys

    here in my shop we have a history table that we have no PK on. we just have FK's to the pertinent data and just insert to it.

    since it...

    For faster help in answering any problems Please read How to post data/code on a forum to get the best help - Jeff Moden[/url] for the best way to ask your question.

    For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]

    Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
    Jeff Moden's Cross tab and Pivots Part 1[/url]
    Jeff Moden's Cross tab and Pivots Part 2[/url]

    March 30, 2012 at 10:55 am

    #1467094

  • RE: best way to load data

    Duplicate post, Please continue discussion in http://www.sqlservercentral.com/Forums/Topic1275106-392-1.aspx

    For faster help in answering any problems Please read How to post data/code on a forum to get the best help - Jeff Moden[/url] for the best way to ask your question.

    For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]

    Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
    Jeff Moden's Cross tab and Pivots Part 1[/url]
    Jeff Moden's Cross tab and Pivots Part 2[/url]

    March 30, 2012 at 10:54 am

    #1467092

  • RE: Imapct on indexes if schema updated

    PaulB-TheOneAndOnly (3/29/2012)

    amita.gham (3/29/2012)

    I have indexes on a table. I now need to Alter the table to add 2 columns, Is there any impact on indexes, Can i alter the table...

    For faster help in answering any problems Please read How to post data/code on a forum to get the best help - Jeff Moden[/url] for the best way to ask your question.

    For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]

    Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
    Jeff Moden's Cross tab and Pivots Part 1[/url]
    Jeff Moden's Cross tab and Pivots Part 2[/url]

    March 29, 2012 at 10:08 pm

    #1466729

  • RE: TOP 1 in an INNER JOIN query

    Lynn Pettis (3/29/2012)

    Or, just use DISTINCT:

    SELECT DISTINCT

    bo.BackOfficeId,

    u.ID,

    u.UserName,

    u.Email

    FROM

    dbo.BackOffice bo INNER JOIN

    ...

    For faster help in answering any problems Please read How to post data/code on a forum to get the best help - Jeff Moden[/url] for the best way to ask your question.

    For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]

    Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
    Jeff Moden's Cross tab and Pivots Part 1[/url]
    Jeff Moden's Cross tab and Pivots Part 2[/url]

    March 29, 2012 at 11:23 am

    #1466525

  • RE: sql query group by weekend

    dweil (3/29/2012)

    Here is the scenario.

    I want to write a query to find out which employees have preformed a service on the weekend over a quarter period. They get one...

    For faster help in answering any problems Please read How to post data/code on a forum to get the best help - Jeff Moden[/url] for the best way to ask your question.

    For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]

    Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
    Jeff Moden's Cross tab and Pivots Part 1[/url]
    Jeff Moden's Cross tab and Pivots Part 2[/url]

    March 29, 2012 at 11:18 am

    #1466518

Viewing 15 posts - 751 through 765 (of 859 total)