Forum Replies Created

Viewing 15 posts - 481 through 495 (of 3,232 total)

  • RE: Formating a Select Statement

    @DynamicForms_QuestionResponse is a table variable in my example. You'll want to remove the '@' symbol and replace it w/ dbo. if you want to run this same query against...

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

    May 13, 2010 at 1:43 pm

    #1167170

  • RE: Formating a Select Statement

    Well, this gives you the results that you are looking for (I think) based on your original query's DynamicQuestionIDs. But my question is, how do you know from the...

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

    May 13, 2010 at 1:10 pm

    #1167160

  • RE: Formating a Select Statement

    So based on the 8 rows of sample data that you've shown us. What do you want the result set to look like? Can we figure out what...

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

    May 13, 2010 at 12:51 pm

    #1167147

  • RE: Formating a Select Statement

    OK. Now we have sample data to work with...Here it is in a usable format:

    DECLARE @DynamicForms_QuestionResponse TABLE(

    DynamicQuestionResponseID uniqueidentifier ,

    ...

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

    May 13, 2010 at 12:24 pm

    #1167126

  • RE: Formating a Select Statement

    It should not matter where the data comes from. Grab (SELECT) a few rows from you table and post them in the forum.

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

    May 13, 2010 at 11:58 am

    #1167112

  • RE: Formating a Select Statement

    acogswell (5/13/2010)

    I want to take each row, after Response (which is the header pulled from the Select Top 15 RESPONSE) and add a column with each of these names:

    Presentee, Factory,...

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

    May 13, 2010 at 11:28 am

    #1167086

  • RE: Formating a Select Statement

    Your formatting is not the problem. We need to know the table structure and see some sample data to help. Can you post your DDL for DynamicForms_QuestionResponse? ...

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

    May 13, 2010 at 11:09 am

    #1167072

  • RE: Formating a Select Statement

    If you can give us an example of your table, data, and an example result set, this should not be to difficult to help you with. Please read the...

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

    May 13, 2010 at 10:49 am

    #1167059

  • RE: Today's Random Word!

    Blarney Stone.

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

    May 12, 2010 at 8:14 am

    #1166240

  • RE: Today's Random Word!

    exponential

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

    May 11, 2010 at 10:20 am

    #1165665

  • RE: Today's Random Word!

    Played Fossil Trace in Golden, CO this weekend.....nice course.

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

    May 10, 2010 at 9:07 am

    #1165050

  • RE: Today's Random Word!

    crookj (5/6/2010)

    sing4you (5/6/2010)

    crookj (5/6/2010)

    CirquedeSQLeil (5/6/2010)

    bcsims 90437 (5/6/2010)

    El Paso? Salsa... it's almost lunchtime.

    Jalapenos

    Chili Cookoff (New Mexico or Arizona style!)

    Joe

    Don't forget Texas. It may be hell to...

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

    May 6, 2010 at 2:59 pm

    #1163640

  • RE: Today's Random Word!

    Training (Teradata).

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

    May 5, 2010 at 12:01 pm

    #1162667

  • RE: Where are you?

    tosscrosby (5/4/2010)

    Chris Morris-439714 (5/4/2010)

    tosscrosby (5/4/2010)

    Who? The men in white coats carrying a net?

    You see them too!

    Actually, I see dead people!

    Was there a full moon again in...

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

    May 4, 2010 at 9:49 am

    #1161902

  • RE: Today's Random Word!

    Steve Jones - Editor (5/4/2010)

    Baking. Made chocolate croissants this morning.

    mbricker-600840 (5/4/2010)

    bacon

    Steve, can you combine these 2 threads and make bacon covered chocolate croissants?

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

    May 4, 2010 at 8:55 am

    #1161860

Viewing 15 posts - 481 through 495 (of 3,232 total)