Not ordinary ConnID format on DB

General Discussion
1

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.

2

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

3

Thx Gen, it could be; any idea?

4

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

5

Edit to give more of a complete answer:

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

to restore connid to hex.

Hope it helps.

Br

6

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