Post reply

to use break and continue

  • March 2, 2008 at 11:40 am

    #187266

    hi all

    i need to quote my columns into strings like

    '"'+cast(columnname as data type())+'"' so that if the column name is FristName

    to be displayed in notepad as "FirstName" ie within quotes

    any one pls help me out

    and i need to add or read the firstname if exists continue or break (skip) and go to next

  • March 3, 2008 at 11:36 am

    #784578

    Is this thread supposed to be about something posted by Jeff Moden? What is the link to it?

  • March 3, 2008 at 8:22 pm

    #784758

    This is the second time I've seen this and I don't know how folks are doing it... I don't know how or why it says "Discuss Content Posted By Jeff Moden".

    --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)

  • March 3, 2008 at 8:24 pm

    #784759

    salinasalina2001 (3/2/2008)

    hi all

    i need to quote my columns into strings like

    '"'+cast(columnname as data type())+'"' so that if the column name is FristName

    to be displayed in notepad as "FirstName" ie within quotes

    any one pls help me out

    and i need to add or read the firstname if exists continue or break (skip) and go to next

    Lookup QUOTENAME in Books Online and a WHERE clause would be the best to skip things that don't have a first name...

    --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)

  • March 4, 2008 at 1:59 pm

    #785207

    Jeff Moden (3/3/2008)

    This is the second time I've seen this and I don't know how folks are doing it... I don't know how or why it says "Discuss Content Posted By Jeff Moden".

    It's really easy - if you click "add topic" while in (say - reading it) a thread - it seems to create the new topic in the SAME folder. So - if I were to click "add thread" right now - I too would have threads under Content Posted by Jeff Moden.

    ----------------------------------------------------------------------------------
    Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?

  • March 4, 2008 at 4:01 pm

    #785248

    Guess I should be pretty happy then... apparently some of my articles inspire people to ask questions. 🙂

    --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)

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply