Forum Replies Created

Viewing 15 posts - 16,126 through 16,140 (of 26,486 total)

  • RE: MCJ - The Missing Link

    dma-669038 (4/5/2010)


    Lynn, would you mind sharing your feedback on questions on this link http://www.surveymonkey.com/s/HLR8V5S

    We plan to send it out to a wider audience perhaps via PASS or otherwise.

    Thanks.

    For anyone else...

  • RE: MCJ - The Missing Link

    dma-669038 (4/5/2010)


    Lynn Pettis (4/5/2010)


    Since we are refocusing, I'll begin.

    I think that the MCJ should be broken down into to certifications; MCJ DBA/Developer and MCJ BI. As you progress in...

  • RE: Dynamic SQL

    Looks like it works, but I made one slight change that may or may not be needed.

    CREATE TABLE dbo.LOOKUP (

    CHAR(2)

    ,COL1 CHAR(1)

    )

    INSERT INTO dbo.LOOKUP VALUES

    ('00','A'),('01','B'),('10','C'),('11','D')

    CREATE TABLE dbo.DATA (

    CHAR(2)

    ,A INT

    ,B...

  • RE: Adding zero's to int

    mosmits (4/5/2010)


    Hello and thanks ahead of time to all of your help.

    I have a column that is an integer and it is hours and minutes here's example

    1132

    234

    1

    23

    etc.

    I want to add...

  • RE: MCJ - The Missing Link

    Since we are refocusing, I'll begin.

    I think that the MCJ should be broken down into to certifications; MCJ DBA/Developer and MCJ BI. As you progress in your career field...

  • RE: UDF, Computed Column, Persisted, Determinism

    How many rows in the table you are querying that you use the UDF?

    Also, to learn a bit about scalar and in-line TVF, you might want to read the following...

  • RE: convert non ansi join

    Jeff Moden (4/5/2010)


    ritu.thatola (4/5/2010)


    Jason,

    I don' know the SQL well.

    Hmmmm... then why did they select you to resolve this particular problem? You need to read the writing on the wall......

  • RE: MCJ - The Missing Link

    I know the discussion right now is the review board, but I thought I'd interject one other aspect so it doesn't get lost. Should there be one MCJ or...

  • RE: No More NULL

    Air Force/Navy prank -- Go get a can of jet wash.

    IT Related -- Time to empty the bit bucket.

  • RE: I don't know how to do it :(

    konstantinos.christodoulakis (4/5/2010)


    More info:

    Table name: MSP_RESOURCES

    EmployeeID: RES_UID (PK, UID(uniqueidentifier)

    EmployeeName: RES_NAME (NAME(nvarchar(255)),not null)

    EmployeeApprover: RES_TIMESHEET_MGR_UID (UID(uniqueidentifier),null)

    Do I need to create a new table and select from there?

    You've been given a solution and some...

  • RE: Today's Random Word!

    crookj (4/5/2010)


    Birthday

    (My granddaughter turned 3 today!)

    Joe

    Happy Birthday!

    Great niece turned three Saturday (missed the party, reason I'm sore and exhausted).

  • RE: Today's Random Word!

    Exhausted (and sore!)

  • RE: Are the posted questions getting worse?

    Paul White NZ (4/2/2010)


    Lynn Pettis (4/2/2010)


    I used to be the same. Commuted to Denver from Colorado Springs for 15 years, survived on 4 hours sleep Monday through Friday.

    Had to...

  • RE: Foreign key constraints...WHY??

    sumit.joshij (4/2/2010)


    In every tranasaction, a database maintain the statistics.

    SO when we create the relation between the PK and FK it check the statistics for PK and FK. it can take...

  • RE: The Missing Certification

    For an idea of where I am thinking, check out TDWI's certification, and more specifically their recertification. In many ways it is much like what Jack suggested, continuing education.

    TDWI's...

Viewing 15 posts - 16,126 through 16,140 (of 26,486 total)