Forum Replies Created

Viewing 15 posts - 16 through 30 (of 55 total)

  • RE: Update and Calculate FIFO

    Thank you . duplicate post only for error in my internet connection. sorry about that. I can't find how to delete the duplicate post.
    but about your question. This data...

  • RE: Update and Calculate FIFO

    Thank you for helping me to send my question in correct format.
    I send spreadsheet only for say what I want.

    In this picture, Cost_Expected field gets returned for...

  • RE: Update and Calculate FIFO

    Thank you for helping me to send my question in correct format.
    I send spreadsheet only for say what I want.

    In this picture, Cost_Expected field gets returned for...

  • RE: Update and Calculate FIFO

    ChrisM@Work - Tuesday, October 30, 2018 10:49 AM

    Hamid-Sadeghian - Tuesday, October 30, 2018 4:09 AM

  • RE: Update and Calculate FIFO

    ChrisM@Work - Tuesday, October 30, 2018 3:55 AM

    Hamid-Sadeghian - Tuesday, October 30, 2018 12:15 AM

  • RE: SQL Server stored procedures fast in SQL but slow when called by ASP.NET

    jkramprakash - Wednesday, September 26, 2018 4:50 AM

    i made some changes in the query.actually i created clustered index for three columns for...

  • RE: Insert 2k rows in one second

    1.    VM type (Vmware, Hyper-V): VMware
    2.    VM Configuration (number of cores presented, number of vCpu per cores): 2 Sockets, 8 Cores per Socket
    3.    VM Disk type - pass through, vmdk, SAN:...

  • RE: Insert 2k rows in one second

    DesNorton - Monday, September 24, 2018 7:28 AM

    Hamid-Sadeghian - Sunday, September 23, 2018 10:03 PM

  • RE: How to get precise error message when processing SSAS through SSIS?

    Eric Mamet - Monday, September 24, 2018 8:40 AM

    Not much as far as I know.

    We just log a few details we...

  • RE: SQL Server stored procedures fast in SQL but slow when called by ASP.NET

    jkramprakash - Sunday, September 23, 2018 11:21 PM

    Jeff Moden - Sunday, September 23, 2018 10:30 AM

    September 24, 2018 at 12:16 am

    #2006692

  • RE: Insert 2k rows in one second

    This is raw message sample

    "MessageCode":"0053","InstrumentId":"IRB3AL010251","Message":"AdAIaEwAAAACAAAAAluoTpFheHh4eHh4eDEwMDM2MiBOT1oxSVJCM0FMMDEwMjUxQUwxUTEyMDE4MDgwNTE2MzQ1NDAwNTMwMDAwMDFBbGJvcnpOci5JSlIyMzA4MDUzMDYwSVJOMjAwMDAxMDAwMDAwMDAgICAwMDAwMDEwNTAwMDBBTDAxIMrM5e3Sx8og5MfmkMfkINHt4e0gx+HI0dLk7dHmIDAwMDAwMCAgIDAwMDAwMDAwMCAgMDAwMDAwMDAwMDAwMCAwMDAwMDAwMDAwMDAwMDAwMDAwMDAwMDAwMDAwMDAwMDIwMTgwODA1MDBBMDAwMDAwMCAgICAwMDAwMDAwMDAwMDAwMDAgMDAwMDAwMDAwMDAxWjEgICAwMDAwMDAwMDAwMDBJUiBJUlIyMDE4MDgwNCAwMDAwMDAgIDEwMDAwMDAwMDIwMDAwMTAwMDAwMDAwICAgICAgICAgICAgIDIwMDAwMTAwMDAwMDAwMjAwMDAwMDAwMDAxMDDH4cjR0jAyMSAgICAgICAgICAwIDAwICAwMDAwMDAwMDAwMDAwQUwwMTAyICAgICAgICAgICAgICAgICAgICAgICAgICAgIDAwMDAwIDAwMDAwMDAwMDAwMDAgIDAwMDAwMDAwMDAwMDEgMDAwMDAwMDDHzMfR5SDR7eHtIMfhyNHS5O3R5jE0MDIwNTE0ICAgICAgICAwMDAwMDAwMCAgICAgICBJUkIzQUwwMTAyNTggICAgICAgICAgICAgICAgICAwMDAwMDAwMDAwMDAwMDAwMCAgICAgICAgICAgICAwMDAwMDAwMDAwMDEgMDAwMDAwMDAwMDAwMCAgICAgICAgICAgMDAgMDAwMDAwMDAwMDAwMCAgIDAwMDAwMDAwMDAwMCAgMDAwMDAwMDAwMDAwMDAwICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgRSAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAwMCAwMCAwMCAwMCAwMCAwMCAwMCAwMCAwMCAwMCAwMCAwMCAwMCAwMCAwMCAwMCAwMCAwMCAwMCAwMCAwMCAwMCAwMCAwMCAwMCAwMCAwMCAwMCAwMCAwMCAwMCAwMCAwMCAwMCAwMCAwMCAwMCAwMCAwMCAwMCAyIDAwMDAwMDAwMDAwMDAgMDAwMDAwMDAwMDAwMCAgIDAwMDAwMDAwMDAwMTAwMDAwMDAyNTAwMCAwMDAwMDAwMCAgMDAwMDAwMDAwMDAwMDIwMDAwMTA1MDAwMDAwMjAwMDAwOTUwMDAwMDAwNU8gICAgMDAwMDAwMDAwMDAwMCAwMDAwMDAwMDAwMDAwICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIE5PIDAgNDY5IDY5MTAzMCAgMDQgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIDAwMDAxMDAwMTY5ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgMDAwMDAwMDI1MDAwMDAwMDAwMDI1MDAwMjAwMDAxMDAwMDAwMDBGMDAwMDAwMDAwMDAxIDAwICAgICAgICAgICAgMDAwMDAwMDAwMDAwMDAwICAgMDAwMDAwMDAwMDAwMCAwMDAwMDAwMDAwMDAwIDAwMDAwMDAwMDAwMDAgMDAwMDAwMDAwMDAwMCAgAA==","MessageVersionId":"267000000000002"}

    and this is parsed message smaple

    {"LRLCDIFFHeader":{"Tech_head_Type":1,"ItemCode":2256,"SessionNumber":19560,"ABSMessageNumber":150994944,"MessageNumberForItemCode":150994944,"BroadCastTimestamp":2437851227,"TransMitterSignature":8680820740569200737,"InstumentCharacteristicHeaderType":"1","MarketFeedCode":"00","MarketPlaceCode":"362","FinancialMarketCode":" BK","CIDGrc":"Z4","InstrumentID":"IRB3BK0199C4","CValMNE":"BK1Q4","DEven":"20180721","HEven":"160945","MessageCodeType":"0053","SEQbyINSTandType":"000001"},"InstrumentID":"IRB3BK0199C4","MessageCodeType":"0053","Message":{"ACarValRLC":{"LVal18":"BG.KaraneMRB210312","YVal":"306","SVal":"0","CPyEmet":"IRN","QNmVlo":{"IFt":"2","QMt":"0000100000000"},"CDevNm":" ","ZTitAd":"000000500000","CSocCSAC":"BK01 ","LSoc30":"?????? ??? ???? ?????991222 ","ASecEco":{"CGdSecEco":"00","CSecAtvEco":"00","CSecCompAtv":"00","Filler01":" "},"CEtFnc":"00000000","IValMry":"0","CSegMarEnvLco":" ","XIntOblRte":{"IFt":" ","QMt":"0000000000000"},"YTxInt":" ","DEmisObl":"00000000","DPrRgLivVal":"00000000","DDebAm":"00000000","DFinAm":"00000000","DESop":"20180721","YOPSJ":"00","CGdSVal":"A","CSicoRGAChn":"000000","CQtmJoui":"0","CDevPEmis":" ","PEmis":{"IFt":" ","QMt":"0000000000000"},"YRbAnt":"0","YRbPro":"0","IValAdSrd":" ","DEchPretEmp":"00000000","IDtVote":"0","IDemat":"0","ITpi":"0","ILcoVwap":"1","CGrValCot":"Z4","Filler001":" ","AClasCo":{"NDivCo":"0","NRubCo":"000","NOrdCo":"0000000"},"IMarche":"0","CPyCot":"IR...

  • RE: Insert 2k rows in one second

    Jeff Moden - Sunday, September 23, 2018 4:42 PM

    Hamid-Sadeghian - Sunday, September 23, 2018 12:00 PM

    September 23, 2018 at 10:06 pm

    #2006688

  • RE: Insert 2k rows in one second

    frederico_fonseca - Sunday, September 23, 2018 12:56 PM

    Most likely the issue is on the application side and how the data is being...

  • RE: Insert 2k rows in one second

    for example such as this link 

    Insert statement is very simple.
    tables has a primary key and only 2-7 columns

    for each table I have...

  • RE: Insert 2k rows in one second

    Thanks for your hint. 
    I update my question and new state of my problem.

Viewing 15 posts - 16 through 30 (of 55 total)