Forum Replies Created

Viewing 15 posts - 13,801 through 13,815 (of 15,381 total)

  • RE: alternative of Top.

    So I have to ask...why not just use top? That is the purpose of it. Or did your professor tell you come up with a different way? There are a...

  • RE: Move data from memo field in Access database to SQL Server 2005 database

    WOW that is a seriously old version. Maybe you can export your data to file first and then import to sql? I don't know that I can be much help....

  • RE: guyz help me

    RP_DBA (10/6/2011)


    faruk.arshad (10/6/2011)


    @old hand

    but i have the inner condition if @@rowcount=0 then break then shouldnt go infinite......

    Yep, my bad.

    No you were correct. This will never break out of...

  • RE: guyz help me

    faruk.arshad (10/6/2011)


    @old hand

    but i have the inner condition if @@rowcount=0 then break then shouldnt go infinite......

    @sean

    Curser ?? can u write sample query of it ?

    Yes you could use...

  • RE: guyz help me

    faruk.arshad (10/6/2011)


    yes i know tat ..but i want to use loop becoz want clear looping concept in SQL jst pretty mch confuse in it..

    Just my 2¢ but since you...

  • RE: IF EXIST - DO NOTHING

    Lynn Pettis (10/6/2011)


    Eddie Wuerch (10/6/2011)


    IF NOT EXISTS(SELECT * FROM Customer WHERE col1 = @x AND col2 = @y AND @col3 = @z)

    BEGIN

    -- do stuff

    ...

  • RE: guyz help me

    faruk.arshad (10/6/2011)


    A B A+B

    == == ===

    123

    13NULL

    14NULL

    15NULL

    16NULL

    17NULL

    123

    13NULL

    14NULL

    15NULL

    16NULL

    17NULL

    i have this table i want to update the...

  • RE: IF EXIST - DO NOTHING

    LOL Aside from the comment looks like Eddie and I answered with the exact same thing.

  • RE: IF EXIST - DO NOTHING

    SQL_Padawan_Learner (10/6/2011)


    I'm tired and need your help...

    Table: CUSTOMER

    Columns: col_1, col_2, col_3

    What I need is a statement that says IF col_1 = X, col_2 = Y and col_3 = Z in...

  • RE: Are the posted questions getting worse?

    GSquared (10/6/2011)


    Sean Lange (10/6/2011)


    Jack Corbett (10/6/2011)


    I refuse to feel old until the president of the U.S. is younger than me. Eventually it will happen, but not yet.

    Never really listened...

  • RE: Old ODBC - New server

    Dig around on google and find instructions for creating a 32bit DSN on a 64bit box. Let me know if you run into any issues. Wish I had time to...

  • RE: Old ODBC - New server

    Are you trying to install a DSN? You need a 32bit DSN and the tool in the control panel is installing a 32bit driver. There is a way to install...

  • RE: Are the posted questions getting worse?

    Jack Corbett (10/6/2011)


    I refuse to feel old until the president of the U.S. is younger than me. Eventually it will happen, but not yet.

    Never really listened to the Ramones,...

  • RE: Are the posted questions getting worse?

    Stefan Krzywicki (10/6/2011)


    Sean Lange (10/6/2011)


    Stefan Krzywicki (10/6/2011)


    Grant Fritchey (10/6/2011)


    Steve Jones - SSC Editor (10/6/2011)


    If you haven't seen it, his 2005 Stanford Commencement. Excellent talk: http://www.youtube.com/watch?v=D1R-jKKp3NA&feature=player_embedded#!

    A sad day, and a reminder...

  • RE: Are the posted questions getting worse?

    Grant Fritchey (10/6/2011)


    Time to start the education. Quintessential Ramones. But my own preference is for this.

    Hurry, hurry, hurry...

    ...too late I already went insane.

Viewing 15 posts - 13,801 through 13,815 (of 15,381 total)