Database query error
/dragon/stockgame_rt/STARWARS202208/earningrate_item_sell (RELEASE)
2025-08-10 07:13:18 (216.73.216.9)
SELECT
*
FROM (
SELECT
ROW_NUMBER() OVER (
ORDER BY
((SISE.conPrice - CONVERT(FLOAT, BASE.buy_price_average)) / BASE.buy_price_average * 100) DESC
) as rownum,
P.participant_name,
P.participant_srl,
BASE.stdcode,
ISNULL(RTRIM(SISE.codename_kor), '확인불가종목') AS codename_kor,
BASE.buy_price_average,
BASE.buy_price_total,
BASE.hold_quantity,
SISE.nationalcode,
SISE.conPrice,
SISE.upDown,
SISE.yfPrice-SISE.conPrice AS ydgap,
BASE.sell_quantity,
BASE.sell_price_total
FROM
StockGameRT.dbo.tb_detail_sellitem BASE (NOLOCK)
LEFT OUTER JOIN StockGameRT.dbo.tb_participant P (NOLOCK) ON BASE.participant_srl = P.participant_srl
LEFT OUTER JOIN StockGameRT.dbo.vSTOCKGAME_SISE SISE ON SISE.stdcode = 'A' + BASE.stdcode
WHERE
1=1
AND BASE.participant_srl IN ('502', '503', '504', '505', '506', '507', '508', '509', '510', '511')
) T
WHERE
rownum BETWEEN :p_start AND :p_end
00000(0) ((null)[0] at (null):0)
p_start => 1
p_end => 30
If you want to any help,
Please contact administrator to the email address below.
yyp@futurewiz.co.kr