Forum Replies Created

Viewing 15 posts - 4,846 through 4,860 (of 5,590 total)

  • RE: Passing table variable or temp table as input parameter

    arctica82 (1/27/2010)

    I am working with SQL SERVER 2000,Is it possible to Pass table variable or temp table as input parameter to stored procedure?

    Not in SQL 2000.

    Can I define a...

    January 27, 2010 at 9:30 pm

    #1109718

  • RE: Are the posted questions getting worse?

    CirquedeSQLeil (1/27/2010)

    Jeff Moden (1/27/2010)

    Alvin Ramard (1/27/2010)

    Oh, before I forget Jason, we passed on to our local chapter membership the link to your blog about user group participation. That should...

    January 27, 2010 at 6:54 pm

    #1109693

  • RE: Universal date format for WHERE clauses.

    Michael Valentine Jones (1/27/2010)

    There are two datetime string formats that are interpreted correctly with with any language setting.

    With the first format, only the YYYYMMDD part is required, but...

    January 27, 2010 at 2:09 pm

    #1109589

  • RE: Are the posted questions getting worse?

    Lynn Pettis (1/27/2010)

    Ray K (1/27/2010)

    Just curious: is anyone else besides me struck by the number of people asking about character-to-date conversions?

    See it quite often. Most replies are that it...

    January 27, 2010 at 11:57 am

    #1109495

  • RE: Time - Adding minutes and seconds

    This should do the trick:

    -- note how this starts off by creating a table structure and putting data into it?

    -- In order to get people willing to help, this is...

    January 27, 2010 at 11:25 am

    #1109471

  • RE: Mishi Kobe Niku

    jameslester78-958147 (1/21/2010)

    Mishi Kobe Niku, what is it?

    And all I could think of (all the while knowing it was wrong) was Star Trek, Capt. Kirk, and the no-win simulation he cheated...

    January 26, 2010 at 2:22 pm

    #1108953

  • RE: Log Shipping, Transaction Logs not being restored (error:14421)

    I had a problem just like this... by any chance are these VMs? Was one a copy of the other? If so, you may need to adjust the entries in...

    January 26, 2010 at 8:44 am

    #1108730

  • RE: How to query on acedemic years?

    I suggest a second table to hold the academic year and the starting date of that year. ie.

    declare @AcademicYears TABLE (AcademicYear smallint PRIMARY KEY CLUSTERED, StartDate datetime)

    insert into @AcademicYears

    values (2010,...

    January 25, 2010 at 9:55 pm

    #1108480

  • RE: Declarative Data Integrity

    Kelsey Thornton (1/25/2010)

    bitbucket-25253 (1/25/2010)

    <snip>

    In the future I will when appropriate not copy a snippet of the explanation, but rather just post a link to the supporting documentation.

    I think an appropriate...

    January 25, 2010 at 2:58 pm

    #1108415

  • RE: Urgent development question

    CirquedeSQLeil (1/25/2010)

    Here is a thread that may help you find your solution. You will still need to look at the code and determine how to adapt it to your...

    January 25, 2010 at 2:33 pm

    #1108402

  • RE: We'll go no more a' tibbling

    GSquared (1/25/2010)

    Grant Fritchey (1/25/2010)

    I think a lot of this, for me anyway, is just habit. Is there a good reason any more to put idx or ix at the beginning...

    January 25, 2010 at 2:15 pm

    #1108388

  • RE: Are the posted questions getting worse?

    Steve Jones - Editor (1/25/2010)

    Looks like The Thread is alive and well. Good to be back and hoping everyone behaved over the last week.

    Shoot, he's back early. quick, everyone clean...

    January 25, 2010 at 8:56 am

    #1108199

  • RE: Are the posted questions getting worse?

    Alvin Ramard (1/23/2010)

    WayneS (1/23/2010)

    Well, USPS just delivered my "SQL SERVER MVP Deep Dives". After a quick scan through it, all I can say is WOW! All these MVPs did a...

    January 24, 2010 at 7:39 pm

    #1107983

  • RE: Declarative Data Integrity

    The explanation, while by itself is accurate, in the context of this question does not really provide an adequate explanation.

    A better explanation might be explaining how, with cascading deletes, how...

    January 24, 2010 at 7:20 pm

    #1107981

  • RE: Are the posted questions getting worse?

    Well, USPS just delivered my "SQL SERVER MVP Deep Dives". After a quick scan through it, all I can say is WOW! All these MVPs did a great job!

    January 23, 2010 at 1:40 pm

    #1107816

Viewing 15 posts - 4,846 through 4,860 (of 5,590 total)