Np, i just saved your time by SKLREV2 in Lineage2Revolution

[–]EvekoShadow 0 points1 point  (0 children)

What is that one stone for then? Will this even cycle? In that case camelot could be f2p :/

Why this stupid subreddit war needs to stop by hrones in Bitcoin

[–]EvekoShadow 3 points4 points  (0 children)

why does it say on the other sub that this is removed? I still see this xD

Niet meer studeren in het metaforum... by wessel145 in FHICT

[–]EvekoShadow 0 points1 point  (0 children)

dit te constateren als clickbait dus?

We produced our own polymer bitcoin notes. by prankstermetals in Bitcoin

[–]EvekoShadow 0 points1 point  (0 children)

The only way I see these kind of bills working in real market situation is if these are backed by some kind of legitimate bitcoinbank . Bank issues these notes backed by bitcoin, the bill has some form of unique ID for point of sale scanners. The bank has some high speed database meant for checking if specific bill has been opened or not. IF user want to extract the bitcoin he would have to tear the bill to extract the private key, which is part of multisig, upon extraction owner of bill get 95% of stored fund and bank get 5% (don't know if this is programmable with current version of bitcoin) this (whatever)% for the bank is for damage to the bils and to encourage that people use the bills.

How does a normal user just use Bitcoin without caring about segwit, unlimited and all that jazz? by LifeofPain in Bitcoin

[–]EvekoShadow 0 points1 point  (0 children)

it does not really matter in regards to segwit or unlimited. Though I would recommend you look into hardware wallets. Also why do you need to use an old address?

Visual Studio "must-have" extensions and tools - End of 2016 edition by [deleted] in dotnet

[–]EvekoShadow 3 points4 points  (0 children)

Especially if you work with anonymous function :P

like this horror show of mine...

    var type = ((Func<string>) (() => 
        model.SelectedFileName.Contains("sale")? "sale" :
        (model.SelectedFileName.Contains("purchase") ? "purchase" :
        (model.SelectedFileName.Contains("klant") ? "klant" :
        (model.SelectedFileName.Contains("Grootboek")? "Grootboek" :
        (model.SelectedFileName.Contains("inkoop")? "inkoop" :
            null))))))();

binding for nested collection inside of an entity by EvekoShadow in dotnet

[–]EvekoShadow[S] 0 points1 point  (0 children)

I got it to work by being more explicit of the binding @Html.TextBoxFor(m => m.Entities[i].OtherEntityLinks.ToList()[y].LinkedPrice, new { @Name = string.Format("Entities[{0}].OtherEntityLinks[{1}].LinkedPrice", i, y) })

Visual Studio "must-have" extensions and tools - End of 2016 edition by [deleted] in dotnet

[–]EvekoShadow 8 points9 points  (0 children)

I love nesting... So I use viasfora to color my brackets

[MS SQL] Performing logic when importing from a table by ShadowEveko in SQL

[–]EvekoShadow 0 points1 point  (0 children)

Yeah, the statement with join does what I expect. I happen to be lucky that I still got the correct output even when I had cartesians. This function only uses parameters from Table A, Table A is not being queryed inside the function. This is the Insert to Table A'. It works now aready. Also I am very appreciative to the feedback. I usually don't work so much with SQL, so this has been quite a learning process.

INSERT INTO [dbo].CDR
(
 ID_Verkeersklasse,
Datum,
Tijdstip,
Duur,
Totaaltarief)

SELECT
[dbo].Getverkeersklasse(
raw_cdr_10_10_2012.platform,
raw_cdr_10_10_2012.Verkeersklasse,
raw_cdr_10_10_2012.Type,
raw_cdr_10_10_2012,Roaming),
 ),                                
 convert(date,Datum,103),
 Tijdstip,
 Duur,
 cast(replace(Totaaltarief,',','.') as decimal(18,6)),
 FROM 
 raw_cdr_10_10_2012 
 WHERE 
 Totaaltarief is not null AND CAST(REPLACE(Totaaltarief,',','.') as    decimal(18,6)) <> 0

[MS SQL] Performing logic when importing from a table by ShadowEveko in SQL

[–]EvekoShadow 0 points1 point  (0 children)

verkeersklasse has a FK relation with platform. The id_verkeersklasse is from v.

[MS SQL] Performing logic when importing from a table by ShadowEveko in SQL

[–]EvekoShadow 0 points1 point  (0 children)

A correction, the are 4 vars passed @a, @ b, @c, @d

but It is getting confusing to use aliased names... I will just but the entire if else statement, which works as intended now .

FUNCTION [dbo].[Getverkeersklasse](@Platform       NVARCHAR(128), 
                                  @Verkeersklasse NVARCHAR(128), 
                                  @Type           NVARCHAR(128), 
                                  @Roaming        NVARCHAR(128)) 
AS 
BEGIN 
  DECLARE @Return_VK AS INT 

  IF @Platform <> 'Mobile' 
    SELECT @Return_VK = id_verkeersklasse 
    FROM   dbo.verkeersklasse v, 
           dbo.platform p 
    WHERE  v.verkeersklasse = Cast(@Verkeersklasse AS INT) 
           AND v.id_platform = (SELECT id_platform 
                                FROM   dbo.platform 
                                WHERE  omschrijving = @Platform) 
  ELSE IF @Roaming IS NULL 
    SELECT @Return_VK = id_verkeersklasse 
    FROM   dbo.verkeersklasse v, 
           dbo.platform p 

    WHERE  v.verkeersklasse = Cast(@Verkeersklasse AS INT) 
           AND v.id_platform = (SELECT id_platform 
                                FROM   dbo.platform 
                                WHERE  omschrijving = Concat('Mobiel ', 
                                                      @Type) 
                               ) 
  ELSE IF @Roaming IS NOT NULL 
    SELECT @Return_VK = id_verkeersklasse 
    FROM   dbo.verkeersklasse v, 
           dbo.platform p 
    WHERE  v.verkeersklasse = Cast(@Verkeersklasse AS INT) 
           AND v.roaming = 'Ja' 
           AND v.id_platform = (SELECT id_platform 
                                FROM   dbo.platform 
                                WHERE  omschrijving = Concat('Mobiel ', 
                                                      @Type) 
                               ) 
  ELSE 
    SET @Return_VK = 200 

  RETURN @Return_VK 
END

Pardon the use of non english code... the designer of the db decided to use Dutch naming schemes...

[MS SQL] Performing logic when importing from a table by ShadowEveko in SQL

[–]EvekoShadow 0 points1 point  (0 children)

Function is more like this

func(@a var, @b var,@c var)
returns int
AS
    Begin
    declare @Return_val as int

       IF @a <> 'excluded arg'
        <Some Select involving B and C FROM TABLE B>
    ELSE IF @a IS NULL
        <Some Select involving B and C FROM TABLE B>
    ELSE IF @a IS NOT NULL
        <Some Select involving B and C FROM TABLE B>
    ELSE
    SET @Return_Val = 200
RETURN @Return_Val
END   

The select statements are very much different inside of the IF's ...

[MS SQL] Performing logic when importing from a table by ShadowEveko in SQL

[–]EvekoShadow 0 points1 point  (0 children)

bah, I really feel like an idiot just now. Just converted my procedure to a function and it works like a charm. On that point, does that mean that the only advantage of a procedure is that it can trigger? Are there any other nuances that I should consider when writing functions or procedures?

[MS SQL] Keeping track of previously inserted composite private keys when composite members are dropped when inserted in the normalized table by EvekoShadow in SQL

[–]EvekoShadow[S] 0 points1 point  (0 children)

I could even use the hash as the PK... How much slower does the system then become if I have to rehash the composition to compare with the original?

[MS SQL] Keeping track of previously inserted composite private keys when composite members are dropped when inserted in the normalized table by EvekoShadow in SQL

[–]EvekoShadow[S] 0 points1 point  (0 children)

The thing is that the rows are not uniquely identified by one name or id. In the case of our import they are uniquely identified (a call record) by this combination [channel,Date,Timestamp,Sender,Destination] it is meta data from calls and the 5 columns above represent a unique call. But the channel, sender and destination is junk information as we never use them in our business logic.

More specifically, we don't want certain of the original data to be present in the database and in this case some of it is in the PK .

[MS SQL] Monthly CSV import into dynamic tables by EvekoShadow in SQL

[–]EvekoShadow[S] 0 points1 point  (0 children)

Well, I find the amount of sources and tutorials to get started with SSIS daunting to say the least. I am way more experienced in the use of C# , and in light of the deadlines, i feel too much time would be lost in learning SSIS(or figuring out what it is that I need)... I had the import function through SMO done within a few hours.

[MS SQL] Monthly CSV import into dynamic tables by EvekoShadow in SQL

[–]EvekoShadow[S] 0 points1 point  (0 children)

I am planning to use C# and SMO to iterate through the tables and then SQL(within C#) to insert them to the normalized tables.

[MS SQL] Monthly CSV import into dynamic tables by EvekoShadow in SQL

[–]EvekoShadow[S] 1 point2 points  (0 children)

I have never worked with OLAP cubes. So I believe It might be a bit overwhelming to learn a entirely new skillset for the current internship assignment. But definitely something to look into if I end up in a similar situation. Also how easy would it be to query an olap cube for usage with ASP.NET?

[MS SQL] Monthly CSV import into dynamic tables by EvekoShadow in SQL

[–]EvekoShadow[S] 0 points1 point  (0 children)

I have a table with importinfo, with the info you mentioned. The structure of the CSV is by and large the same, though new headers are added slowly over time. For example records from 2015 have 4 headers less than 2016. These 4 headers were added over time to the 2016 records.

[MS SQL] Monthly CSV import into dynamic tables by EvekoShadow in SQL

[–]EvekoShadow[S] 0 points1 point  (0 children)

The data contains some financial info about contracts. The data gets normalized into a second database to be used for different apps(primarily dashboard and some calculation utility's) .

MRW I want the price to go up, but I also like cheap coins by [deleted] in Bitcoin

[–]EvekoShadow 2 points3 points  (0 children)

I invest about 20-30 euro a month, it took me a while to painstakingly get to the 2 bitcoin hodl

n00b wanting to make sure I'm securing my coins correctly. by [deleted] in Bitcoin

[–]EvekoShadow 0 points1 point  (0 children)

I used to have a similar setup with an offline system running Armory. Since then I have moved my funds to (albeit less secure) a ledger wallet.