Forum Replies Created

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

  • Reply To: Query help on Pivoting on two columns

    DECLARE @RegionCounts Table
    (
    TYear char(2),
    Region varchar(30),
    RowCnt int
    )

    Insert into @RegionCounts values ('13','Latam',100)
    Insert into @RegionCounts values ('13','NOAM',200)
    Insert into @RegionCounts values ('14','Latam',300)
    Insert into @RegionCounts values ('14','NOAM',400)

    select * from @RegionCounts
  • RE: SSRS grouping and rows display

    Thank you all for your comments and solutions. I was able to solve my problem as below.
    In the procedure, used row_number to generate row numbers within the group by...

  • RE: SSRS grouping and rows display

    No. do not want the sum of qtySent.
    There will be bunch of other columns like DispatchDate, Location for each of those rows which have different values per row.

  • RE: Issue with AutoRounding of decimal values on SSRS textbox

    Super..!! This works exactly, as needed. Thank you.

  • RE: Query Help

    John Mitchell-245523 - Friday, January 20, 2017 9:13 AM

    s-sql - Friday, January 20, 2017 8:52 AM

    January 20, 2017 at 9:32 am

    #1924084

  • RE: CTE Script Needed for delete statement

    You can do a batch delete of the rows, in the batch increments.

    USE AdventureWorks2008R2;

    GO

    --Delete in batches of 10000 rows

    While @@ROWCOUNT <> 0

    DELETE Top 10000 * FROM Purchasing.PurchaseOrderDetail

    WHERE DueDate =...

  • RE: XML Parsing Help

    Thank you. The solution worked.

  • RE: Query Help

    Thank you. The solution worked and gave the desired results.

  • RE: SQL Help needed...

    Jeff, Here is the code for split function..

    CREATE FUNCTION [dbo].[Split] (@sep VARCHAR(32), @S VARCHAR(MAX))

    RETURNS @t TABLE

    (

    val...

  • RE: SQL Help needed...

    The solution from MelroyV, worked for me. Thanks a lot, melroy.

    Thank you Sean for your inputs/suggestions.

    Your suggested solution was close too, but I was looking for traversed results....

  • RE: Query help with unpivot qry

    The query worked. Made a minor modification, and it gave me the desired results.

    SELECT itemNo AS Item,

    Cat AS CatID,

    SubCat AS SubCatID

    FROM #Test

    CROSS APPLY( VALUES

    ( Cat1, SubCat11),

    ( Cat1, SubCat12),

    ( Cat2, SubCat21),

    (...

  • RE: SQL Query Help using XML

    Thank you very much. The solution worked, and this was exactly what I was looking for..!!

  • RE: Query Help

    Thank you very much. The script worked pretty well, on my actual tables with minor tweaking.

  • RE: Query Help

    How about using row_number() over (order by Userid) as rownum, and do an order by on this Row Num.

  • RE: Query Help

    My Actual tables has more than 50 columns, of which only 3 columns needs to be distinct, on any row, and has many data rows. Tried to simulate the problem...

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