Forum Replies Created

Viewing 15 posts - 4,141 through 4,155 (of 5,356 total)

  • RE: SQL query please

    Hi Swathi,

    quote:

    I have an employee table defined like this

    IDNameMgr_Id

    ==============================

    1StevenNull

    2Mary1

    3George6

    4Julie2

    5Lingo3

    6James8

    7Eddie2

    8Linda1

    This table lists the employee and his/her manager.I want to get the output as

    Steven

    --Mary

    ---Julie...

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

    August 22, 2003 at 6:47 am

    #470957

  • RE: How to promote a website?

    quote:

    Make sure the URL is part of your signature in all e-mails you send out. It worked for me.

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

    August 22, 2003 at 4:35 am

    #470950

  • RE: How to promote a website?

    quote:

    Is this for the "Frank Kalis - Employee of the Month" website?

    hey, that's a good...

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

    August 22, 2003 at 3:56 am

    #470946

  • RE: Junior and Senior DBAs

    quote:

    lunch = mittagtrinken

    mittagtrinken ????

    I've always associated lunch with having somethings to eat !

    Must be special...

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

    August 22, 2003 at 2:18 am

    #470937

  • RE: Pet Peeves

    The American and the Japanese corporate offices for a large multi-national corporation decided to engage in a competitive boat race.

    Both teams practiced hard and long to reach their peak performance....

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

    August 22, 2003 at 1:40 am

    #470935

  • RE: Junior and Senior DBAs

    Hi Chris,

    quote:

    Hi there

    Good point with the senior dba comment. I am a "senior dba" apparently :), to be honest, its all...

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

    August 22, 2003 at 1:29 am

    #470934

  • RE: Fire trigger to stop user editing records

    quote:

    Im about 2 months old when it comes to triggers and their abilities 🙂

    May I...

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

    August 22, 2003 at 1:08 am

    #470928

  • RE: Fire trigger to stop user editing records

    In addition to my first post.

    What about verify the update status at the client with a simple sp.

    If Not Updateable Then Exit Sub

    ...

    Cheers,

    Frank

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

    August 22, 2003 at 12:25 am

    #470925

  • RE: Fire trigger to stop user editing records

    Hi adamcrv,

    quote:

    Can you fire a trigger (SP maybe?) that will stop a user from changing a record if it is more than...

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

    August 22, 2003 at 12:22 am

    #470923

  • RE: Silicon Valley (US) startup looking for senior DB

    Sorry, for hooking right in, but

    quote:

    1. Where in Silicon Valley?

    isn't there also a 'Silicone Valley'...

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

    August 22, 2003 at 12:14 am

    #470922

  • RE: Junior and Senior DBAs

    Posting in SQLServerCentral.com

    Written by: brenbart

    Respond here: http://www.sqlservercentral.com/forum/link.asp?TOPIC_ID=15438

    Senior DBA: Grey hair, cautious to the point of paranoia, never volunteers for anything not strictly database related and has a tendency to chitchat...

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

    August 22, 2003 at 12:12 am

    #470921

  • RE: Thanks for this site ! Any similar for DB2

    quote:

    Well don't let them convince you the conversion from MF to FP (Fischer Price) is an easy thing.

    If nothing else the FP...

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

    August 22, 2003 at 12:03 am

    #470920

  • RE: Access Project 2000 front end - varchar to nvarcha

    Nulad,

    quote:

    An Access project contains only code-based or HTML-based database objects: forms, reports, data access pages, macros, and modules. Unlike a Microsoft...

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

    August 21, 2003 at 11:50 pm

    #470918

    • Viewing 15 posts - 4,141 through 4,155 (of 5,356 total)