Forum Replies Created

Viewing 15 posts - 4,396 through 4,410 (of 5,356 total)

  • RE: How can I show results while WHILE is running

    Hi SQLBill,

    not sure if this really helps but I've found the following on http://www.umachandar.com/

    

    --To store the progress details

    CREATE TABLE ##Progress( Step int , ItTookSoLong int )

    GO

    CREATE...

    --
    Frank Kalis
    Microsoft SQL Server MVP
    Webmaster: http://www.insidesql.org/blogs
    My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

    August 1, 2003 at 8:49 am

    #468233

  • RE: Full-Text Problem

    quote:

    Thanks Frank but this isn't it. The fields I'm trying to index are VARCHAR(80) or less not huge TEXT fields.

    --
    Frank Kalis
    Microsoft SQL Server MVP
    Webmaster: http://www.insidesql.org/blogs
    My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

    August 1, 2003 at 7:58 am

    #468209

  • RE: How to Break a While ?????

    Hi David,

    quote:

    Harsh tone in that quote.

    Let me know which dark alleys, and I certainly keep well away.

    --
    Frank Kalis
    Microsoft SQL Server MVP
    Webmaster: http://www.insidesql.org/blogs
    My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

    August 1, 2003 at 7:46 am

    #468206

  • RE: Full-Text Problem

    Hi Paul,

    take a look at this one

    http://support.microsoft.com/default.aspx?scid=kb;en-us;241113

    Maybe it will help you

    Cheers,

    Frank

    --
    Frank Kalis
    Microsoft SQL Server MVP
    Webmaster: http://www.insidesql.org/blogs
    My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

    August 1, 2003 at 6:11 am

    #468181

  • RE: QOD 1/8/03 (or is it 8/1/03?)

    The whole discussion with date formats reminds me somehow of those dbase days where I used to split the string into the ISO format.

    Even today I use this format when...

    --
    Frank Kalis
    Microsoft SQL Server MVP
    Webmaster: http://www.insidesql.org/blogs
    My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

    August 1, 2003 at 6:00 am

    #468179

  • RE: QOD 1/8/03 (or is it 8/1/03?)

    quote:

    What's funny is the question was written by someone in Germany

    is...

    --
    Frank Kalis
    Microsoft SQL Server MVP
    Webmaster: http://www.insidesql.org/blogs
    My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

    August 1, 2003 at 4:59 am

    #468166

  • RE: SP's

    Copy 'n' paste isn't as simple as it may seem

    Here's the corrected version:

    

    CREATE PROCEDURE sp_Permissions

    AS

    

    SET NOCOUNT ON 

    

    IF EXISTS (SELECT * FROM tempdb..sysobjects WHERE [name] LIKE...

    --
    Frank Kalis
    Microsoft SQL Server MVP
    Webmaster: http://www.insidesql.org/blogs
    My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

    August 1, 2003 at 4:34 am

    #468160

    • Viewing 15 posts - 4,396 through 4,410 (of 5,356 total)