Forum Replies Created

Viewing 15 posts - 316 through 330 (of 860 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...

    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...

    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...

    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...

    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...

    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...

    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...

    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...

    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...

    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...

    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...

    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...

    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...

    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...

    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...

    May 14, 2012 at 12:49 pm

    #1487330

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