Forum Discussion

donepr's avatar
donepr
New Contributor
8 years ago

Date Timestamp error while trying to use the "sql server update" snap?

Hi All, I’m trying to update the target sql server table using “sql server update” snap with the where condition “INSERTTS = $INSERTTS” (INSERTTS is the insert date timestamp) but I’m getting the ...
Aleksandar_A's avatar
Aleksandar_A
Contributor III
2 years ago
Copy LinkReport

Hello ahouston,

Attached below is a sample pipeline where I did the calculation for the subtotal, I'm not sure if that's what you expect but you can take a look at it.

Mainly, first I'm grouping the same objects with same key1 and key2 and then I'm adding the value1 and value2.

Please let me know if this helps you.

Regards,

Aleksandar.

  • jonesky's avatar
    jonesky
    New Contributor
    7 years ago
    Copy LinkReport

    Did you ever figure this out? The date time formats for SQL server are not compatible from what I can find.