Forum Replies Created

Viewing 15 posts - 661 through 675 (of 911 total)

  • RE: insert into: ignore identity column's value

    rotcha99 - Monday, May 28, 2018 10:00 AM

    Hi,
    is there any Chance to get this working?

    CREATE TABLE [dbo].[Table_1](
     [id] [int] IDENTITY(1,1) NOT...

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

    May 31, 2018 at 12:57 pm

    #1992538

  • RE: YTD running balance including missing months

    DesNorton - Wednesday, May 30, 2018 4:01 AM

    When looking up the month names, you could also use the CHOOSE function

    Replace...

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

    May 31, 2018 at 12:51 pm

    #1992536

  • RE: YTD running balance including missing months

    Lynn Pettis - Tuesday, May 29, 2018 3:37 PM

    jcelko212 32090 - Tuesday, May 29, 2018 12:24 PM

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

    May 31, 2018 at 11:17 am

    #1992508

  • RE: YTD running balance including missing months

    Phil Parkin - Wednesday, May 30, 2018 5:21 AM

    You could also add the decoded monthname to the CROSS JOIN:
    CROSS...

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

    May 31, 2018 at 11:03 am

    #1992505

  • RE: YTD running balance including missing months

    ddly_ann - Monday, May 28, 2018 7:47 AM

    A useful idiom is a report period calendar. It gives a name to a range...

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

    May 29, 2018 at 12:24 pm

    #1992205

  • RE: how to store percent symbol while creating a new table,which datatype will store percent symbol.

    tara.ajith1 - Sunday, May 27, 2018 8:02 PM

    I am importing data from excel and there is a column which contains % symbol...

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

    May 28, 2018 at 1:16 pm

    #1992124

  • RE: Help with an Update Query

    ordnance1 - Sunday, May 27, 2018 9:13 AM

    >> I use the query below to _identify any records [sic: rows are records] that...

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

    May 27, 2018 at 7:33 pm

    #1992089

  • RE: Array in specific columns

    dallmann - Wednesday, May 23, 2018 11:21 AM

    Hi there,
    I 'm looking for a way to save an array in to a table....

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

    May 27, 2018 at 7:13 pm

    #1992088

  • RE: A better way than multiple subqueries?

    Mark Harley - Tuesday, May 22, 2018 11:34 AM

    What you have here is called an EAV design, and it's a total nightmare....

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

    May 24, 2018 at 9:41 am

    #1991825

  • RE: Need help with derived column expression

    Phil Parkin - Wednesday, May 23, 2018 11:12 AM

    jcelko212 32090 - Wednesday, May 23, 2018 11:08 AM

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

    May 23, 2018 at 11:27 am

    #1991668

  • RE: Need help with derived column expression

    neranki9 - Tuesday, May 22, 2018 1:53 PM

    >> I have a requirement for derived column expression as if col_a ="AB" then display...

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

    May 23, 2018 at 11:08 am

    #1991663

  • RE: Cursors

    paul s-306273 - Wednesday, May 23, 2018 1:38 AM

    Jeff Moden - Tuesday, May 22, 2018 9:19 PM

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

    May 23, 2018 at 9:02 am

    #1991642

  • RE: Cursors

    Ronnie65 - Friday, May 18, 2018 10:22 AM

    In what situations should i use cursors over joins. I know that joins are much...

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

    May 22, 2018 at 12:59 pm

    #1991494

  • RE: Is there a maximum number of joins allowed in SQL 2016?

    Lynn Pettis - Friday, May 18, 2018 7:07 AM

    jcelko212 32090 - Thursday, May 17, 2018 7:01 PM

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

    May 21, 2018 at 11:20 am

    #1991306

  • RE: create temp view

    Donald Leaderach - Thursday, March 13, 2008 6:56 AM

    Is it possible to create a temporary view from within a stored procedure for...

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

    May 21, 2018 at 9:47 am

    #1991273

Viewing 15 posts - 661 through 675 (of 911 total)