Forum Replies Created

Viewing 15 posts - 691 through 705 (of 911 total)

  • RE: Generate a sequence number for corresponding numbers

    komal145 - Thursday, April 5, 2018 10:32 AM

    I have a requirement , where i need to create a look up table to...

    Please post DDL and follow ANSI/ISO standards when asking for help. 

    April 6, 2018 at 10:53 am

    #1985829

  • RE: Converting varchar to float

    Warning: pedantic Celko history lesson coming!

    This actually has an interesting history to it. Europeans like using a comma for a decimal point

    Please post DDL and follow ANSI/ISO standards when asking for help. 

    March 28, 2018 at 12:14 pm

    #1984872

  • RE: get date by rank

    Angela4eva - Wednesday, March 21, 2018 9:06 AM

    >> have results from my query <<

    In the future please follow forum rules and post...

    Please post DDL and follow ANSI/ISO standards when asking for help. 

    March 23, 2018 at 10:17 am

    #1984431

  • RE: first-in first-out profit calculation

    Jacob Wilkins - Thursday, March 15, 2018 4:22 PM

    If I understand the requirements correctly, here's one method:

    WITH
    n   AS...

    Please post DDL and follow ANSI/ISO standards when asking for help. 

    March 16, 2018 at 3:37 pm

    #1983672

  • RE: Link table return more than record

    makis_best - Friday, March 16, 2018 3:37 AM

    >> I have a query that return more than one record [sic] can any one...

    Please post DDL and follow ANSI/ISO standards when asking for help. 

    March 16, 2018 at 2:40 pm

    #1983661

  • RE: Fill in gaps between 2 dates

    Jeff Moden - Wednesday, March 7, 2018 2:12 PM

    jcelko212 32090 - Monday, March 5, 2018 6:34 PM

    Please post DDL and follow ANSI/ISO standards when asking for help. 

    March 8, 2018 at 7:18 am

    #1982392

  • RE: Fill in gaps between 2 dates

    adhikari707 - Monday, March 5, 2018 11:34 AM

    Hi  All,
    Need some help in filling up gaps between 2 dates.
    Scenario :  I have  Product...

    Please post DDL and follow ANSI/ISO standards when asking for help. 

    March 5, 2018 at 6:34 pm

    #1982033

  • RE: CTE Crazy: Sums, Counts and Pivots I'm missing something here

    Tom257 - Thursday, March 1, 2018 1:02 PM

    >> Wow Joe, thanks for the thorough treatise! <<

    I am always pedantic 🙂

    >> In answer:...

    Please post DDL and follow ANSI/ISO standards when asking for help. 

    March 2, 2018 at 10:02 am

    #1981793

  • RE: CTE Crazy: Sums, Counts and Pivots I'm missing something here

    Tom257 - Wednesday, February 28, 2018 7:19 AM

    I've not had to use SQL for a while and I'm having trouble getting to...

    Please post DDL and follow ANSI/ISO standards when asking for help. 

    March 1, 2018 at 10:37 am

    #1981674

  • RE: Splitting a Full Name

    brickpack - Thursday, July 11, 2013 2:54 PM

    I'm trying to split a full name column up into First / Middle / Last....but...

    Please post DDL and follow ANSI/ISO standards when asking for help. 

    March 1, 2018 at 9:34 am

    #1981656

  • RE: Question about a composite key and autoincrement

    ScottPletcher - Monday, February 26, 2018 5:00 PM

    Does is really matter if the numbers are sequential or is everyone just used to...

    Please post DDL and follow ANSI/ISO standards when asking for help. 

    February 27, 2018 at 10:58 am

    #1981327

  • RE: Update the first and last 2 charactors with year and month

    cfm - Wednesday, February 14, 2018 8:57 AM

    I have a value that I need to change the first characters with the year...

    Please post DDL and follow ANSI/ISO standards when asking for help. 

    February 26, 2018 at 12:45 pm

    #1981176

  • RE: Question about a composite key and autoincrement

    herkusg - Wednesday, February 21, 2018 4:26 PM

    Hello all,

    I was recently assigned to convert an Access database to Sql Server.  I have...

    Please post DDL and follow ANSI/ISO standards when asking for help. 

    February 26, 2018 at 12:06 pm

    #1981167

  • RE: Need to get consecutive duplicate rows

    Jeff Moden - Wednesday, February 21, 2018 3:59 PM

    jcelko212 32090 - Wednesday, February 21, 2018 3:23 PM

    Please post DDL and follow ANSI/ISO standards when asking for help. 

    February 21, 2018 at 7:30 pm

    #1980715

  • RE: Triggers or best option

    Kris-155042 - Monday, February 19, 2018 9:21 PM

    Hi,
    This is a little hard to explain, but I'll have a go 🙂
    We have several...

    Please post DDL and follow ANSI/ISO standards when asking for help. 

    February 21, 2018 at 3:37 pm

    #1980705

Viewing 15 posts - 691 through 705 (of 911 total)