Forum Replies Created

Viewing 15 posts - 26,236 through 26,250 (of 59,099 total)

  • RE: BCP Help

    jerome.morris (8/10/2013)

    So if I make a table all strings then import this into that table using the bcp command, can I then move what I need another table and convert...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    August 10, 2013 at 11:44 am

    #1640375

  • RE: parent Child Recursive count and distribution in sql server.

    akshay9986 (8/9/2013)

    thanks Sean Lange,

    The 500 tasks are will be allocated to most top parents...

    i m thinking that this 500 tasks can be stored in emp table itself...

    These tasks will get...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    August 10, 2013 at 12:06 am

    #1640352

  • RE: SSRS: way to add 100 columns in tablix,

    I don't know much about it because I don't use SSRS but I believe that what you're looking for is called a "matrix" in SSRS. I also believe (IIRC...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    August 10, 2013 at 12:02 am

    #1640351

  • RE: Bulk Insert text file into SQL table

    Can you attach the file that you're trying to import without breaking any privacy or proprietary concerns?

    Also, take up a collection to pay someone beat the hell out of the...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    August 9, 2013 at 9:36 pm

    #1640346

  • RE: simple select - error

    Minnu (8/9/2013)

    Hi Team,

    am using below select statement, but getting error

    SELECT id, name, Count(id) AS T FROM testtest

    Error:

    Column 'testtest.id' is invalid in the select list because it is not contained...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    August 9, 2013 at 9:30 pm

    #1640344

  • RE: SQL Query

    sundayose (8/9/2013)

    when I run this code I get an output but for some vouchers, the CB and District output are wrong.

    HOW are they wrong? How did you determine they...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    August 9, 2013 at 9:28 pm

    #1640343

  • RE: How to find the SQL Server databse Last used by db users ?

    charipg (4/10/2012)

    How to find the SQL Server databse Last used by db users ?

    Are you including SELECTs in your "last used"?

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    August 9, 2013 at 9:26 pm

    #1640342

  • RE: Converting an Oracle trigger to SQL Server 2008

    rodgersem (8/9/2013)

    Hello -

    I'm new to SQL Server and this forum. I'm trying to convert a simple Oracle trigger to SQL Server 2008. I know the BEFORE needs to be converted...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    August 9, 2013 at 9:17 pm

    #1640341

  • RE: How to Join the two table

    ramanathan.raman88 (2/2/2013)

    Table 1

    ABCDF

    A1B1NULLNULLNULL

    A2B2NULLNULLNULL

    A3B3NULLNULLNULL

    A4B4NULLNULLNULL

    A5B5NULLNULLNULL

    Table 2

    LocName

    A1White

    A2Black

    A3Red

    A4Orange

    A5Blue

    B1Green

    B2Yellow

    B3Gold

    B4Rose

    B5Silver

    The absolute best way would be to normalize Table 1. 😉

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    August 9, 2013 at 8:38 pm

    #1640338

  • RE: Is profiler only one toool ..

    There's also the default trace which also logs certain DDL events like dropping a table.

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    August 9, 2013 at 8:28 pm

    #1640337

  • RE: BCP Help

    jerome.morris (8/9/2013)

    doh! ^^

    bcp SLADB.dbo.AlarmDetTB format nul -T -n -f ProdData-n.fmt -S localhost\DEV

    works fine, thanks a lot.

    My Next question is using that file is it possible to specify the format...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    August 9, 2013 at 8:19 pm

    #1640336

  • RE: BCP Help

    Koen Verbeeck (8/9/2013)

    Not an expert in bcp format files, but you can use a query in BCP, so I would do the formatting there.

    You can only use a query to...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    August 9, 2013 at 8:16 pm

    #1640334

  • RE: What is your favorite "I didn't know that" moment in T-SQL?

    L' Eomot Inversé (8/9/2013)

    Eureka moment (I'm getting on topic after having responded to far too many off topic messages above).

    Back in 2002 (I think; it may have been later) I...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    August 9, 2013 at 8:13 pm

    #1640333

  • RE: Balloons and Data

    L' Eomot Inversé (8/9/2013)

    Jeff Moden (8/9/2013)

    Steve Jones - SSC Editor (8/9/2013)

    Jeff Moden (8/8/2013)

    Right sizing log files and datafiles for the FULL recovery model is a far bigger PITA than TempDB...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    August 9, 2013 at 8:07 pm

    #1640332

  • RE: Can you please any one explain?

    techmarimuthu (8/9/2013)

    Difference between CAST and Convert functions in SQL SERVER??

    My recommendation would be to get into SSMS and press the {f1} key. There's a whole lot of good information...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    August 9, 2013 at 7:58 pm

    #1640331

Viewing 15 posts - 26,236 through 26,250 (of 59,099 total)