Forum Replies Created

Viewing 15 posts - 316 through 330 (of 859 total)

  • RE: UPDATE with CASE Statement not updating all Records

    roryp 96873 (6/28/2012)

    I don't know if you want this behavior or not, but since your last two cases don't have elses, it will set those fields to null if Field2...

    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]

    June 28, 2012 at 10:37 am

    #1506743

  • RE: Create database DDL VS creating a database in SSMS

    After much testing and looking at VLF sizes and rerunning every query i found the create script created 16 VLF's and all the sizes we tried to shrink to were...

    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]

    May 17, 2012 at 2:36 pm

    #1489366

  • RE: Last day of last year

    riya_dave (5/16/2012)

    hi,

    i want last day last year,what is the function for that.

    example if i put date 02/29/12 the i should get 12/31/11.

    if 03/31/2011 then it should be 12/31/2010

    riya_dave (5/17/2012)

    hi,

    select...

    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]

    May 17, 2012 at 2:01 pm

    #1489342

  • RE: incremental Load

    can you post the Create table script for the 3 tables (DDL) and some sample data you would be loading. it most likely can be done by SSIS 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]

    May 16, 2012 at 3:45 pm

    #1488717

  • RE: Question: Immediate Exit of Stored Procedure?

    Lynn Pettis (5/16/2012)

    capn.hector (5/16/2012)

    mtassin (5/16/2012)

    Brandie Tarvin (5/16/2012)

    Okay, now you've peaked my interest. How do you do the help entry? Does it just do a PRINT? Or a SELECT? Or is...

    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]

    May 16, 2012 at 1:50 pm

    #1488654

  • RE: Question: Immediate Exit of Stored Procedure?

    mtassin (5/16/2012)

    Brandie Tarvin (5/16/2012)

    Okay, now you've peaked my interest. How do you do the help entry? Does it just do a PRINT? Or a SELECT? Or is there some other...

    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]

    May 16, 2012 at 1:30 pm

    #1488647

  • RE: Question: Immediate Exit of Stored Procedure?

    mtassin (5/16/2012)

    capn.hector (5/16/2012)

    in any of my procedures that are user accessible i have a block at the beginning something like this:

    IF @Input <> (good input)

    BEGIN

    SELECT 'you have bad input'

    RETURN

    END

    kills 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]

    May 16, 2012 at 9:25 am

    #1488485

  • RE: parse string

    Sean Lange (5/16/2012)

    OMG :w00t:

    Jeff Moden posted a loop.

    There is only darkness now, there is no sunshine. The mayans were correct.

    Parden me, I must send out an email blast...

    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]

    May 16, 2012 at 9:22 am

    #1488479

  • RE: Must declare the scalar variable

    one issue with this procedure is it is using global temp tables (##TempExportData) if 2 people are running the report at the same time they will contaminate each others...

    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]

    May 16, 2012 at 9:10 am

    #1488467

  • RE: Question: Immediate Exit of Stored Procedure?

    Brandie Tarvin (5/16/2012)

    Really? The RETURN statement will stop a proc in mid execution?

    I'm looking over BOL on that and don't see any statements to that effect. That's why I posted...

    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]

    May 16, 2012 at 8:53 am

    #1488457

  • RE: Create database DDL VS creating a database in SSMS

    opc.three (5/14/2012)

    capn.hector (5/14/2012)

    opc.three (5/14/2012)

    durring the server trace i could not find any differences in the T-SQL being executed between the create database script vs SSMS Create DB Wizard.

    Thank goodness. I...

    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]

    May 14, 2012 at 2:58 pm

    #1487405

  • RE: Create database DDL VS creating a database in SSMS

    opc.three (5/14/2012)

    durring the server trace i could not find any differences in the T-SQL being executed between the create database script vs SSMS Create DB Wizard.

    Thank goodness. I think 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]

    May 14, 2012 at 1:36 pm

    #1487360

  • RE: BULK INSERT with latin/chinese/japanese characters

    itzseema (5/14/2012)

    Hi,

    I am new to bulk import and I am facing the same issue. Which language files i need to install?

    this thread is over 2 years old. you 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]

    May 14, 2012 at 1:14 pm

    #1487350

  • RE: Restore master db from sql 2000 to sql 2008 R2

    ScottPletcher (5/14/2012)

    You should be able to restore the master db to a different db name, if you want to pull data from the old master db directly in the SQL...

    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]

    May 14, 2012 at 12:53 pm

    #1487334

  • RE: How Do You Verify Sequential Record Numbers.

    mcertini (5/14/2012)

    To ensure all of my data is complete.

    If you are using an identity column you will get gaps in the incrementing numbers. any time a record is deleted...

    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]

    May 14, 2012 at 12:49 pm

    #1487330

Viewing 15 posts - 316 through 330 (of 859 total)