Forum Replies Created

Viewing 15 posts - 586 through 600 (of 859 total)

  • RE: Are the posted questions getting worse?

    Brandie Tarvin (4/12/2012)

    Steve Jones - SSC Editor (4/12/2012)

    Both printers here are acting up. One doesn't want to inject ink on the the paper. The other keeps sending offline messages...

    For faster help in answering any problems Please read How to post data/code on a forum to get the best help - Jeff Moden[/url] for the best way to ask your question.

    For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]

    Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
    Jeff Moden's Cross tab and Pivots Part 1[/url]
    Jeff Moden's Cross tab and Pivots Part 2[/url]

    April 12, 2012 at 1:57 pm

    #1472928

  • RE: GROUP BY and HAVING problem

    can you post some sample data and table definitions so we can see what you are looking at for an output??

    For faster help in answering any problems Please read How to post data/code on a forum to get the best help - Jeff Moden[/url] for the best way to ask your question.

    For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]

    Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
    Jeff Moden's Cross tab and Pivots Part 1[/url]
    Jeff Moden's Cross tab and Pivots Part 2[/url]

    April 12, 2012 at 1:27 pm

    #1472898

  • RE: select statement

    Lynn Pettis (4/12/2012)

    drew.allen (4/12/2012)

    Sean Lange (4/12/2012)

    Why are you so stubborn about posting ddl and sample data?

    I've come to the conclusion that he's not really interested in answers. He's only...

    For faster help in answering any problems Please read How to post data/code on a forum to get the best help - Jeff Moden[/url] for the best way to ask your question.

    For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]

    Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
    Jeff Moden's Cross tab and Pivots Part 1[/url]
    Jeff Moden's Cross tab and Pivots Part 2[/url]

    April 12, 2012 at 11:40 am

    #1472806

  • RE: fetching date from 1 sp to another

    hbtkp (4/12/2012)

    i have one sp(sp1) which return values for the specific periods

    now i have another sp (sp2),which has all the values for all the periods.

    now...

    For faster help in answering any problems Please read How to post data/code on a forum to get the best help - Jeff Moden[/url] for the best way to ask your question.

    For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]

    Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
    Jeff Moden's Cross tab and Pivots Part 1[/url]
    Jeff Moden's Cross tab and Pivots Part 2[/url]

    April 12, 2012 at 11:10 am

    #1472786

  • RE: select statement

    hbtkp (4/12/2012)

    i dont have this thread before.

    yes i need to get same values in else also

    drew.allen is saying that you have asked a similar question in the above posted thread...

    For faster help in answering any problems Please read How to post data/code on a forum to get the best help - Jeff Moden[/url] for the best way to ask your question.

    For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]

    Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
    Jeff Moden's Cross tab and Pivots Part 1[/url]
    Jeff Moden's Cross tab and Pivots Part 2[/url]

    April 12, 2012 at 11:08 am

    #1472780

  • RE: Need Help with the Error 'Subquery returned more than 1 value'.

    suhailtajraja (4/12/2012)

    the table that i have provided is the actual table. is that needs to be in new temp table so that i dont mess with the actual table? also,...

    For faster help in answering any problems Please read How to post data/code on a forum to get the best help - Jeff Moden[/url] for the best way to ask your question.

    For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]

    Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
    Jeff Moden's Cross tab and Pivots Part 1[/url]
    Jeff Moden's Cross tab and Pivots Part 2[/url]

    April 12, 2012 at 11:05 am

    #1472777

  • RE: select statement

    hbtkp (4/12/2012)

    i did.stil its not working

    with out seeing your table structure the sample data in that table and the query you are trying to run we can go no further....

    For faster help in answering any problems Please read How to post data/code on a forum to get the best help - Jeff Moden[/url] for the best way to ask your question.

    For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]

    Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
    Jeff Moden's Cross tab and Pivots Part 1[/url]
    Jeff Moden's Cross tab and Pivots Part 2[/url]

    April 12, 2012 at 9:23 am

    #1472675

  • RE: Referentail Integrity

    Sean Lange (4/12/2012)

    But each constraint must have a unique name.

    good catch sean, im getting ready for work and posting. apparently not a good combination.

    For faster help in answering any problems Please read How to post data/code on a forum to get the best help - Jeff Moden[/url] for the best way to ask your question.

    For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]

    Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
    Jeff Moden's Cross tab and Pivots Part 1[/url]
    Jeff Moden's Cross tab and Pivots Part 2[/url]

    April 12, 2012 at 8:51 am

    #1472643

  • RE: Referentail Integrity

    pathankhan (4/12/2012)

    Really, I was setting it up the opposite way.

    So 3 foreign keys on Person_Information table to the same primary key Lookup_Country table will run perfectly fine.

    ALTER TABLE Person_Information ADD...

    For faster help in answering any problems Please read How to post data/code on a forum to get the best help - Jeff Moden[/url] for the best way to ask your question.

    For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]

    Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
    Jeff Moden's Cross tab and Pivots Part 1[/url]
    Jeff Moden's Cross tab and Pivots Part 2[/url]

    April 12, 2012 at 8:42 am

    #1472634

  • RE: select statement

    ill come in and say it could be a select distinct... but even so DDL (Create table statements) and sample data (Insert statements) will be incredibly helpful in this...

    For faster help in answering any problems Please read How to post data/code on a forum to get the best help - Jeff Moden[/url] for the best way to ask your question.

    For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]

    Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
    Jeff Moden's Cross tab and Pivots Part 1[/url]
    Jeff Moden's Cross tab and Pivots Part 2[/url]

    April 12, 2012 at 8:38 am

    #1472627

  • RE: Referentail Integrity

    as Gazareth said the foreign key references the primary key (the home_country_id references Country_ID) i would also read up on foreign key relationships to make sure you under stant...

    For faster help in answering any problems Please read How to post data/code on a forum to get the best help - Jeff Moden[/url] for the best way to ask your question.

    For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]

    Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
    Jeff Moden's Cross tab and Pivots Part 1[/url]
    Jeff Moden's Cross tab and Pivots Part 2[/url]

    April 12, 2012 at 8:34 am

    #1472622

  • RE: Need Help with the Error 'Subquery returned more than 1 value'.

    suhailtajraja (4/12/2012)

    Hi Vinu:

    I checked entity_id,and user_id are retruning multiple records in a table. So, what field do I need in my statement as a distinct.Are these entity_id

    ,user_id ones? or something...

    For faster help in answering any problems Please read How to post data/code on a forum to get the best help - Jeff Moden[/url] for the best way to ask your question.

    For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]

    Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
    Jeff Moden's Cross tab and Pivots Part 1[/url]
    Jeff Moden's Cross tab and Pivots Part 2[/url]

    April 12, 2012 at 8:13 am

    #1472605

  • RE: First time using linked Servers

    danderson 73949 (4/11/2012)

    Hello all,

    I've 2 separate sql servers, both 2008R2. On srv1 i created a link to linksrv in order to update data between 2 tables. essentially what i want...

    For faster help in answering any problems Please read How to post data/code on a forum to get the best help - Jeff Moden[/url] for the best way to ask your question.

    For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]

    Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
    Jeff Moden's Cross tab and Pivots Part 1[/url]
    Jeff Moden's Cross tab and Pivots Part 2[/url]

    April 12, 2012 at 7:58 am

    #1472588

  • RE: Referentail Integrity

    pathankhan (4/12/2012)

    Can someone please help me out setting up primary and foreign key relationships. Here is my issue...

    Lookup_Country Table list all the countries.

    1. USA

    2. Canada

    3. China

    4. India

    Person_Information Table

    Birth_Country_ID

    Citizenship_Country_ID

    Home_Country_ID

    I can create...

    For faster help in answering any problems Please read How to post data/code on a forum to get the best help - Jeff Moden[/url] for the best way to ask your question.

    For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]

    Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
    Jeff Moden's Cross tab and Pivots Part 1[/url]
    Jeff Moden's Cross tab and Pivots Part 2[/url]

    April 12, 2012 at 7:51 am

    #1472582

  • RE: how to sum up instances only 3 of the 4 values that can occur in a given column

    vinu512 (4/12/2012)

    dwain.c (4/11/2012)

    Being the contrarion that I am, I'll offer another solution.

    DECLARE @t TABLE (id INT, test VARCHAR(10), status VARCHAR(10))

    INSERT INTO @t (id, test, status)

    SELECT 1, 'test1', 'Passed' UNION ALL

    SELECT...

    For faster help in answering any problems Please read How to post data/code on a forum to get the best help - Jeff Moden[/url] for the best way to ask your question.

    For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]

    Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
    Jeff Moden's Cross tab and Pivots Part 1[/url]
    Jeff Moden's Cross tab and Pivots Part 2[/url]

    April 12, 2012 at 7:46 am

    #1472577

Viewing 15 posts - 586 through 600 (of 859 total)