Not ordinary ConnID format on DB

[Gef Buneri]

Hi all, hope all fine around there, and everyone's fine; in a DB I've got a table for stats that writes ConnID in a format like 3,xxxx instead of usual hex format; any clue on how to convert it? ( a doc will fit too).


Best regards,

Gef.

[gen_rtfm]

Is it like the format of connids that are stored in infomart?

I had this problem a while back, for an ms-sql query; would that be of any use to you?

Br

Skickat från min Mi MIX 3 5G via Tapatalk

[Gef Buneri]

Thx Gen, it could be; any idea?

[gen_rtfm]

I'll get back to you, need to be where my workstation is at to get the expression. Might be a few hours.

Skickat från min Mi MIX 3 5G via Tapatalk

[gen_rtfm]

Edit to give more of a complete answer:

I used
convert(varchar(16),cast(convert(bigint,[SOURCE FIELD NAME]) as varbinary(),2)

to restore connid to hex.

Hope it helps.

Br

[Gef Buneri]

Thank you very much in any case for the answer, I'll try it and let you know.