Forum Replies Created

Viewing 15 posts - 10,831 through 10,845 (of 15,381 total)

  • RE: cursor error in a stored procedure.

    qur7 (9/5/2012)

    i understand , but in this box.. because of the bad application code lot of temporary tables are not getting drop... from last month of so. i want to...

    September 5, 2012 at 1:14 pm

    #1534083

  • RE: Please Help on Trailing spaces

    You should use a trigger to trim the data during INSERTs and UPDATEs

    [/quote]

    I don't think I agree that you should just add a trigger to trim spaces but we can...

    September 5, 2012 at 12:55 pm

    #1534077

  • RE: rCTE vs LIKE for Hierarchy

    what first querie does is a like on Hierarchy column, what mine does is a rcte from ID to ParentID pretty much like BOL examples... what I really don't understand...

    September 5, 2012 at 12:25 pm

    #1534060

  • RE: rCTE vs LIKE for Hierarchy

    ariel_mlk (9/5/2012)

    Celko and Sean,

    Thanks for the responses, I'm sorry i don't think i was clear enough, what I have is something like

    ID ...

    September 5, 2012 at 12:20 pm

    #1534055

  • RE: Databar with single value

    Andy Gerard (9/5/2012)

    right, right... sorry for the bad info.

    No worries.

    Now to try to help the OP...I don't understand what the issue is.

    September 5, 2012 at 10:07 am

    #1533980

  • RE: Please Help on Trailing spaces

    derek.colley (9/5/2012)

    Sean - SELECT state FROM state.state.state.state WHERE state = @state ORDER BY state;

    Could be perfectly valid :ermm: (even if it should be a sackable offence) and reminds me a...

    September 5, 2012 at 10:04 am

    #1533976

  • RE: Please Help on Trailing spaces

    Lynn Pettis (9/5/2012)

    The update statement does not delete data. It simply updates the data as you tell it to. If it deleted data from your table it is...

    September 5, 2012 at 9:29 am

    #1533939

  • RE: it returning null

    vinay.varaala (9/5/2012)

    actually I was looking for

    eg: when we search for books in amazon one drop box will ask for with24hrs, last week, last month, last year, I want the...

    September 5, 2012 at 9:28 am

    #1533934

  • RE: it returning null

    vinay.varaala (9/5/2012)

    actually I was looking for

    eg: when we search for books in amazon one drop box will ask for with24hrs, last week, last month, last year, I want the...

    September 5, 2012 at 9:27 am

    #1533932

  • RE: Databar with single value

    Andy Gerard (9/5/2012)

    does this script work in a query window? i could be wrong but i think you might have to put an "as Size" after the cast statement.

    No, the...

    September 5, 2012 at 9:24 am

    #1533929

  • RE: it returning null

    vinay.varaala (9/5/2012)

    thanks got the error. cheers..

    one more question i want to select a record of 2012-05-20 date how to teh code for dateadd()

    http://bit.ly/UrUYss

    September 5, 2012 at 9:19 am

    #1533921

  • RE: Please Help on Trailing spaces

    hydbadrose (9/5/2012)

    create table state

    (

    state_Code int null,

    state varchar(50) not null

    primary key (state

    );

    ????

    You really need to try your scripts before you post them.

    I...

    September 5, 2012 at 9:14 am

    #1533912

  • RE: using IN statment & a string variable.

    Tava (9/4/2012)

    Sean Lange (9/4/2012)

    Tava (9/3/2012)

    excellent, I got it working, created the Function & in the subquery now getting the results i wanted... really appreciate your help on this... no...

    September 5, 2012 at 7:32 am

    #1533806

  • RE: Equals space between two string when concatenate two columns

    GuruGPrasad (9/4/2012)

    Thanks Lynn Pettis

    Max column length may vary.

    And your code

    select

    country + replicate(' ', 56 - len(country)) + currency_code from dbo.currency order by country;

    does not...

    September 5, 2012 at 7:29 am

    #1533802

  • RE: Equals space between two string when concatenate two columns

    Nice job posting ddl and sample data. I don't understand what you want for output.

    September 4, 2012 at 3:26 pm

    #1533546

Viewing 15 posts - 10,831 through 10,845 (of 15,381 total)