Forum Discussion

gowdhaman008's avatar
gowdhaman008
New Contributor II
6 years ago

SQL Server Merge Snap - Issues with Date as Null

Hi, I have developed the pipeline which reads the data from the incoming stream and send to SQL Merge. My pipeline looks like below. My Input JSON is as follows: [ { “member_id”: 13000...
heidi_andrew's avatar
heidi_andrew
Contributor
3 years ago
Copy LinkReport

I KEEP getting the null:


But i did figure out how to show first day of last month and last day of last month!

Aleksandar_A's avatar
Aleksandar_A
Contributor III
3 years ago
Copy LinkReport

It is because the COUNT is an integer, try with this:

"0000000000".slice($COUNT.toString().length) + $COUNT
  • gowdhaman008's avatar
    gowdhaman008
    New Contributor II
    6 years ago
    Copy LinkReport

    Hi,

    I have tried to cast as date type. But it still could not go with SQL merge, but note that it is working with SQL Inserts.

    Thanks,
    Gowdhaman