Hello All
Can you help me with concatenation of BIG INT
<select distinct
CASE when pl.firstname IS NULL then '' else pl.firstname END as 'First Name',
CASE when pl.lastname IS NULL then '' else pl.lastname END as 'Last Name',
CASE when pl.playerId IS NULL then '' else pl.playerId END as 'Players ID',
CASE when pc.Cardid IS NULL then '' else max(cast(right('3000000000', 10) as BIGINT))+ convert(nvarchar(9), pc.Cardid) END as'Card ID'
from tPlyr pl
LEFT join tPlEvaluationHistory pcs on pl.playerid = pcs.playerid
left join tPlayerCard pc on pcs.playerid = pc.PlayerId
--WHERE pc.Cardid <> ' '
--WHERE NULLIF(pc.Cardid, '') IS NOT NULL
Group by pl.firstname,pl.lastname,pl.playerId,pc.Cardid >
However, the Cardid field is given me 0 though it should be giving me 3000000000 + 9 digits that is, '3000000000123456789'
fname lstname Playrid Cardid
ZE lastman 999999 0
DAN Redman 999999 0
Can you help me with concatenation of BIG INT
<select distinct
CASE when pl.firstname IS NULL then '' else pl.firstname END as 'First Name',
CASE when pl.lastname IS NULL then '' else pl.lastname END as 'Last Name',
CASE when pl.playerId IS NULL then '' else pl.playerId END as 'Players ID',
CASE when pc.Cardid IS NULL then '' else max(cast(right('3000000000', 10) as BIGINT))+ convert(nvarchar(9), pc.Cardid) END as'Card ID'
from tPlyr pl
LEFT join tPlEvaluationHistory pcs on pl.playerid = pcs.playerid
left join tPlayerCard pc on pcs.playerid = pc.PlayerId
--WHERE pc.Cardid <> ' '
--WHERE NULLIF(pc.Cardid, '') IS NOT NULL
Group by pl.firstname,pl.lastname,pl.playerId,pc.Cardid >
However, the Cardid field is given me 0 though it should be giving me 3000000000 + 9 digits that is, '3000000000123456789'
fname lstname Playrid Cardid
ZE lastman 999999 0
DAN Redman 999999 0