You are viewing a single comment's thread from:
RE: [SQL] 비개발자도 스티밋 통계를 뽑을 때까지 - 6편 - 검색을 잘하는 것도 실력이다!
Select
C.author
,sum(CASE WHEN T.[TO]= C.AUTHOR AND T.AMOUNT_SYMBOL= 'SBD' THEN T.AMOUNT END) AS SBD입금
,sum(CASE WHEN T.[FROM]= C.AUTHOR AND T.AMOUNT_SYMBOL= 'SBD' THEN T.AMOUNT END) AS SBD출금
,sum(CASE WHEN T.[TO]= C.AUTHOR AND T.AMOUNT_SYMBOL= 'STEEM' THEN T.AMOUNT END) AS STEEM입금
,sum(CASE WHEN T.[FROM]= C.AUTHOR AND T.AMOUNT_SYMBOL= 'STEEM' THEN T.AMOUNT END) AS STEEM출금
from [dbo].[TxTransfers] as T (nolock)
INNER JOIN Comments AS C (NOLOCK) ON (T.[FROM]= C.AUTHOR OR T.[TO]=C.AUTHOR)
Where
[type] = 'TRANSFER ' -- POWER UP한 사람은 제외
and CHARINDEX('KO', BODY_LANGUAGE)>0 -- 한국어로 쓰인 포스팅
AND C.PARENT_AUTHOR ='' --댓글 제외
AND TITLE <>''
and c.created >= '2017-10-01' --10월 1일 이후 작성된 글
GROUP BY C.Author
이 답이라 생각하는데...
`Could not allocate space for object 'dbo.SORT temporary run storage: 140854566846464' in database 'tempdb' because the 'PRIMARY' filegroup is full. Create disk space by deleting unneeded files, dropping objects in the filegroup, adding additional files to the filegroup, or setting autogrowth on for existing files in the filegroup.
'
로 나옵니다. 고진선처 부탁드립니다.
헙... ^^ 잠시만용
잠은 언제 주무시는지.. 혹시 로봇입니까??
짐 아기 분유미기고잇어요ㅎㅅ
헐... 회사일에... 술에.. 밤샘 스팀잇에 육아까지..... 존... 존경합니다.
대단하십니다!!
들켯네요 ㅎㅎ
11시 취침 4시쯤 기상햇네욬ㅋㅋㅋ