Forum Replies Created

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

  • 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

  • RE: Varchar(max) not storing all data

    opc.three (9/4/2012)

    You can output is as XML in grid view so it will appear as a link:

    SELECT YourColumnName as [processing-instruction(x)]

    FROM YourSchemaName.YourTableName

    FOR XML PATH('');

    Then click the link to see the entire...

    September 4, 2012 at 3:13 pm

    #1533538

  • RE: rCTE vs LIKE for Hierarchy

    ariel_mlk (9/4/2012)

    Hi people,

    I'm tunning a database and i've stumbled by some hierarchy queries, on the good old form of ID, ParentID, to work out the hierarchy the previous developers...

    September 4, 2012 at 2:38 pm

    #1533513

  • RE: Get incremental numbers from char string(005 through 020)

    I did however find a bug in my code. You should change the final query to be this.

    select *

    from cteAgg

    join tally on tally.N >= cteAgg.MinItem and tally.N <= cteAgg.MaxItem

    I...

    September 4, 2012 at 1:38 pm

    #1533487

  • RE: Varchar(max) not storing all data

    bindish (9/4/2012)

    I also change datatype to text and check the size. It still shows me 43600 characters in SSMS.

    I am not sure how else I can say this....SSMS does NOT...

    September 4, 2012 at 1:03 pm

    #1533471

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