Forum Replies Created

Viewing 13 posts - 1 through 13 (of 13 total)

  • Reply To: Getting Total Spending/Purchase of Unique Customers against Each Store - TSQL

    Thanks, the final script summed all required details.

    February 23, 2021 at 6:19 am

    #3848861

  • Reply To: Getting Total Spending/Purchase of Unique Customers against Each Store - TSQL

    Output required mentioned in the attachments of first post in Table (4) where last column obtained with the query mentioned in my last reply. I will join the ones provided...

    February 22, 2021 at 8:31 pm

    #3848694

  • Reply To: Getting Total Spending/Purchase of Unique Customers against Each Store - TSQL

    Thanks Jonathan,

    What are the total purchases of unique customer is the tricky part. The query gives the total of purchase for each customer at each store. There are 3 stores...

    • This reply was modified 3 years, 7 months ago by  Rehan Ahmad.

    February 22, 2021 at 4:43 pm

    #3848590

  • Reply To: Getting Total Spending/Purchase of Unique Customers against Each Store - TSQL

    Dear, not homework. I done a lot and tried by using joins but stuck on the final result where total purchase of each customer required to be plotted (against those...

    February 22, 2021 at 3:10 pm

    #3848530

  • Reply To: Importing File in SQL Server (Having Header and Footer and no delimiters)

    I have upload such similar file with Ragged Right option and setting fixed width. Problem is with lines in the start and end and report description mentioned in the top...

    October 10, 2019 at 3:25 pm

    #3687766

  • RE: Change in row values identification

    Thom A - Tuesday, March 19, 2019 6:58 AM

    Rehan Ahmad - Tuesday, March 19, 2019 6:52 AM

    March 19, 2019 at 7:14 am

    #2024887

  • RE: Change in row values identification

    Thom A - Tuesday, March 19, 2019 5:54 AM

    You can use a CTE and LAG to easily achieve this:

    • '); } var target = "undefined" !== typeof items[3] ? items[3] : ( "undefined" !== typeof items[items.length-1] ? items[items.length-1] : null ); if ( "undefined" !== typeof target ) { var list = document.querySelector('#bbp-user-navigation ul'); var li = document.createElement("LI"); li.innerHTML= '
  • Following
    • '; var li = li.firstChild; list.insertBefore( li, target ); } else { console.error("BPT Error: Could not find an item position for a profile element (%s)",'
  • Following
    • '); } }; BPT_init();