Select
C.author
,sum(CASEWHEN T.[TO]= C.AUTHOR AND T.AMOUNT_SYMBOL='SBD'THEN T.AMOUNT END) AS SBD입금
,sum(CASEWHEN T.[FROM]= C.AUTHOR AND T.AMOUNT_SYMBOL='SBD'THEN T.AMOUNT END) AS SBD출금
,sum(CASEWHEN T.[TO]= C.AUTHOR AND T.AMOUNT_SYMBOL='STEEM'THEN T.AMOUNT END) AS STEEM입금
,sum(CASEWHEN T.[FROM]= C.AUTHOR AND T.AMOUNT_SYMBOL='STEEM'THEN T.AMOUNT END) AS STEEM출금
from [dbo].[TxTransfers] as T (nolock)
INNERJOIN 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일 이후 작성된 글GROUPBY 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.
'
구체적으로 막히는부분에 대한 질문을 주시면 답이나 힌트를 드리겠습니다 ^^
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시쯤 기상햇네욬ㅋㅋㅋ