Forum Replies Created

Viewing 15 posts - 616 through 630 (of 859 total)

  • RE: trimming a string

    xenophilia (4/11/2012)

    Oh for the love of mankind it is still happening with the simple DDL I created. Apparently I'm not adopting Lynn's solution properly as it is happening here when...

    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]

    April 11, 2012 at 4:23 pm

    #1472302

  • RE: Index Key Order

    Gail's blog posts helped me out alot when i was trying to figure out my indexes on a table(Thanks Gail). read them and if you have any questions after...

    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]

    April 11, 2012 at 4:13 pm

    #1472300

  • RE: Are the posted questions getting worse?

    Lynn Pettis (4/11/2012)

    Lynn Pettis (4/11/2012)

    Not sure but I think this individual, xenophilia, should change their name to xenosqlia.

    Please, someone tell me why, just why do I keep helping someone who...

    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]

    April 11, 2012 at 4:10 pm

    #1472298

  • RE: To decide which is best solution for implementation of SQL sever and client for educational porpose

    Lynn Pettis (4/11/2012)

    SQLKnowItAll (4/11/2012)

    seesachinjadhav,

    note that it is not only bad etiquette in a forum to post your entire question in the subject line and nothing in the post itself, but...

    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]

    April 11, 2012 at 3:57 pm

    #1472292

  • RE: trimming a string

    xenophilia (4/11/2012)

    Hello Gail!

    So, that results in empty cells. I know I should post some ddl, but any ideas?

    so why dont you post what you know we will ask for?...

    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]

    April 11, 2012 at 3:30 pm

    #1472273

  • RE: Syntax help required

    http://msdn.microsoft.com/en-us/library/ms186734.aspx in case google is broken. also if you post DDL and sample data you will get tested code. we here like solving problems. it passes...

    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]

    April 11, 2012 at 3:28 pm

    #1472268

  • RE: Cursor help

    piotrka (4/11/2012)

    The self join is working just fine. Thanks for all your help.

    glad to hear we could help you out.

    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]

    April 11, 2012 at 3:24 pm

    #1472262

  • RE: how do you create place values for columns that may not have values in them

    Is this related to http://www.sqlservercentral.com/Forums/Topic1281810-392-1.aspx "how to sum up instances only 3 of the 4 values that can occur in a given column"

    If so it will be better 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]

    April 11, 2012 at 3:20 pm

    #1472259

  • RE: Steps for maintenence plan

    SQLKnowItAll (4/11/2012)

    Saggy (4/11/2012)

    hi....guys...

    we have to create a nightly maintenance plan for the database Adventureworks that does:

    1) Full database and transaction log backup

    2) Integrity check, rebuild index, recompute statistics.

    Backups should go...

    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]

    April 11, 2012 at 12:09 pm

    #1472104

  • RE: Modified DateTimeStamp - No Default on record creation

    i to prefer to eleminate as many nulls in the data as possible. however it has to make sense. a last modified date IMHO is the inserted date...

    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]

    April 10, 2012 at 4:30 pm

    #1471600

  • RE: Scheduling a job via T-SQL.

    richard.noordam (4/10/2012)

    Thanks!

    will go forth with distrust in my heart, and suspicion in my actions ;). am paranoid a bit when it comes to my data....

    what?? a...

    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]

    April 10, 2012 at 3:09 pm

    #1471540

  • RE: User/Login in Database Instance

    is your windows user part of a domain admin group? or some group that has the access you are seeing in the database? only way that would be...

    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]

    April 10, 2012 at 3:08 pm

    #1471538

  • RE: Scheduling a job via T-SQL.

    yep with something like the following to pull the next date.

    SELECT @NextDate = MIN([datecolumn])

    FROM [datetable]

    WHERE [datecolumn] > getdate()

    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]

    April 10, 2012 at 3:05 pm

    #1471536

  • RE: Scheduling a job via T-SQL.

    im fine with things scheduling themselves with in reason. the first is i have tested them in dev and been able to break them in dev doing things that...

    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]

    April 10, 2012 at 3:03 pm

    #1471534

  • RE: rows repeating

    Lowell (4/10/2012)

    hbtkp (4/10/2012)

    i am getting result like

    item1 item2 item3

    1 pen 34

    1 ...

    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]

    April 10, 2012 at 2:41 pm

    #1471518

Viewing 15 posts - 616 through 630 (of 859 total)