Forum Replies Created

Viewing 15 posts - 1 through 15 (of 136 total)

  • RE: Grouping inside a loop

    Hi Andy, 
    Please do not bother, i've been able to resolve the issue by doing a sum(Base) and Partitioning by selection
    It was resolved in another post.

    August 10, 2018 at 7:27 pm

    #2001332

  • RE: Finding Percentages Based on Column Sum

    Jacob Wilkins - Friday, August 10, 2018 4:08 PM

    In that case, something like this should do the trick:

    SELECT *,
       ...

    August 10, 2018 at 4:28 pm

    #2001328

  • RE: Finding Percentages Based on Column Sum

    Jacob Wilkins - Friday, August 10, 2018 3:50 PM

    It's not entirely clear from your description, but from your expected results it looks...

    August 10, 2018 at 4:02 pm

    #2001324

  • RE: Grouping inside a loop

    Hi andy thanks a lot for your previous help, but i'm having another challenge with same code after some modifications
    I want to find percentages for the generated result, but...

    August 10, 2018 at 1:12 pm

    #2001303

  • RE: how to massively drill down a survey

    Hi Steve,
    Thanks for your reply, i actually used a string_split to handle the massive columns and did a pivot to handle each column and i got what i wanted.

    August 7, 2018 at 1:16 pm

    #2000701

  • RE: Grouping inside a loop

    andycadley - Wednesday, August 1, 2018 1:51 PM

    Yeah, string_split is a 2017 thing but should be easily replaceable with your favourite string...

    August 1, 2018 at 3:54 pm

    #1999956

  • RE: Grouping inside a loop

    Hi Andy,
    I've been able to resolve the string_split issue, but the computation of the second solution is giving me above the total base on each column
    Please help look...

    August 1, 2018 at 4:33 am

    #1999846

  • RE: Grouping inside a loop

    andycadley - Tuesday, July 31, 2018 9:16 PM

    Are you trying to do something like this?

    Thanks Andy, that is what i want to...

    August 1, 2018 at 1:42 am

    #1999835

  • RE: Grouping inside a loop

    Lynn Pettis - Tuesday, July 31, 2018 5:31 PM

    I have to write cursors at times but this is a little confusing. ...

    July 31, 2018 at 5:57 pm

    #1999814

  • RE: Pivoting Very Large Data

    Luis Cazares - Monday, July 30, 2018 2:29 PM

    I'm curious. Who would read a row like that? What is this good for?
    There's...

    July 30, 2018 at 3:13 pm

    #1999591

  • RE: Pivoting Very Large Data

    sgmunson - Monday, July 30, 2018 9:24 AM

    That wide a pivot is going to fail because SQL Server simply can not handle...

    July 30, 2018 at 1:06 pm

    #1999562

  • RE: Adding extra rows based on supplied integer

    Hi Steve,
    Thanks so much, you have saved me two days of babbling about.
    Thanks so much again, it works very fine.

    God bless you.
    Tim

    March 8, 2017 at 8:55 am

    #1932339

  • RE: Resolve Data using Pivot

    DesNorton (9/30/2016)

    1 - You have not provided a key that groups all of the data for a specific person. Although, from your pivot code, it appears that Period may...

    October 1, 2016 at 1:05 pm

    #1904296

  • RE: Resolve Data using Pivot

    Thanks Thom for the reply and thanks for the advice.

    The kind of result i want is in this format:

    CREATE TABLE [dbo].[Testtable2](

    [Period] [nvarchar](50) NULL,

    [Name] [nvarchar](max) NULL,

    [CompanyName] [nvarchar](max) NULL,

    [CompanyAddress] [nvarchar](max) NULL,

    [Phone] [nvarchar](max)...

    September 30, 2016 at 10:30 am

    #1904215

  • RE: Using Select Statement inside Case result

    Hi laurie-789651,

    Based on your suggestion, it got me thinking, eventually, i did some hard-coding to resolve it, i don't know if your answer can be more automatic, but this code...

    September 26, 2016 at 7:48 am

    #1903083

Viewing 15 posts - 1 through 15 (of 136 total)