Forum Replies Created

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

  • RE: Trim space in batch script - SSIS script task

    I have managed to get it work in an alternate way. Now it is adding footer record properly with out space.
    Here is the alternate solution, this may be helpful...

    May 26, 2017 at 1:05 pm

    #1944384

  • RE: Columns to rows and rows to columns

    drew.allen - Friday, March 24, 2017 1:45 PM

    This should be done in the presentation layer, not the database layer.  SQL Server is...

    March 24, 2017 at 1:53 pm

    #1934867

  • RE: It's about encryption key

    bmg002 - Monday, February 13, 2017 10:11 AM

    p.shabbir - Monday, February 13, 2017 10:06 AM

    February 13, 2017 at 10:17 am

    #1928163

  • RE: It's about encryption key

    bmg002 - Friday, February 10, 2017 2:34 PM

    p.shabbir - Friday, February 10, 2017 12:35 PM

    February 13, 2017 at 10:06 am

    #1928159

  • RE: Not related to sql - Unlock password protected .7z file.

    Thank God.

    Tried with different combinations and I cracked it.:-)

    Thnx.

    December 9, 2016 at 2:57 am

    #1916991

  • RE: Not related to sql - Unlock password protected .7z file.

    Hi Guys,

    Any help or reference to the links please?

    Eric,

    Can you please provide the powershell script to crack it?

    Thnx in advnc.

    December 9, 2016 at 2:30 am

    #1916984

  • RE: Not related to sql - Unlock password protected .7z file.

    Eric M Russell (12/8/2016)

    By lock, you probably mean decrypt. 7Zip uses AES256 encryption. My advice would be to download the command line version of 7Zip and then write a PowerShell...

    December 8, 2016 at 8:26 am

    #1916803

  • RE: Need help to get prevoius 4 hrs data

    Thank you very much Alan.

    October 3, 2016 at 3:17 pm

    #1904565

  • RE: SSRS display sum for sub category group by value.

    Spiff (8/24/2016)

    Hi Joydev,

    You would use a "100% Stacked Column" chart to achieve this.

    Put the Year in the Category groups and the Criteria in the Series groups.

    You can use Show Data...

    August 24, 2016 at 6:58 am

    #1897168

  • RE: Help with query.

    Luis Cazares (8/8/2016)

    I'm sure that you have some ID for each person that would work as a primary key. That's the reason I added it to the example.

    You just need...

    August 8, 2016 at 6:58 am

    #1894322

  • RE: Need to split the row values

    Chris_M (6/4/2016)

    Most example candidates begin:

    [font="Courier New"]<space><int><space><int><space><YYYYMMDD><space><MM/DD/YYYY><space><YYYYMMDD><space><GLOB><space>[/font]

    If this were ALWAYS the case, you could look for 'GLOB', count back six <space>, and you have found the split-point.

    You might even check that...

    July 1, 2016 at 7:01 am

    #1888080

  • RE: Need to split the row values

    Ok. I have managed to work it manually (It is urgent since, these records we need to send it back to the client). I thought it would take long time...

    June 6, 2016 at 7:08 am

    #1883347

  • RE: Need to split the row values

    ChrisM@Work (6/6/2016)

    Chris_M above has pointed out above that some of your rows appear to be truncated...

    Yes.

    Can this be done or if not, I will have to to do it manually...

    June 6, 2016 at 3:48 am

    #1883321

  • RE: Need to split the row values

    ChrisM@Work (6/3/2016)

    p.shabbir (6/3/2016)

    ChrisM@Work (6/3/2016)

    Do you have a means of detecting the split point?

    After

    "be.wylei.com/3dadf94363998b3bb263e8944efa95b4.smartclick?wid=${Profile.CustomerKey}&wcid=${CAMPAIGN_KEY}&wseg=${VSEG} applynow.chase.com/FlexAppWeb/pricing.do?card=FK6S&page_type=appterms creditcards.chase.com/a1/marriottpremier/200SC-offer-details-May16" value

    in the above example the record must be splitted.

    Thanks.

    You've done this by eye....

    June 6, 2016 at 3:13 am

    #1883313

  • RE: Need to split the row values

    ChrisM@Work (6/3/2016)

    Look through your data to find a common rule which will identify the split location. It might be the nth tab, it might be immediately following "200SC-offer-details-May16", it might...

    June 3, 2016 at 10:17 am

    #1883150

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