Viewing 15 posts - 766 through 780 (of 4,087 total)
I'm pretty new to this forum and SQL query.
Can some please take a...
December 13, 2018 at 10:32 am
Regarding the questions/issues:
Can you please post an example that fails...
December 12, 2018 at 2:03 pm
This is obviously a continuation of your previous thread. You should just learn how to shred XML documents correctly in the first place instead of trying to cobble...
December 12, 2018 at 11:24 am
December 12, 2018 at 9:33 am
December 11, 2018 at 3:15 pm
WITH CTE AS (
SELECT
CASE WHEN LAG(serial_number, 1) OVER( ORDER BY trans_date, trans_time) = serial_number THEN 0 ELSE 1 END AS is_start,
index_num,
December 11, 2018 at 2:58 pm
December 7, 2018 at 7:14 am
The back end is Oracle. Is there anyway i can make below statement...
December 6, 2018 at 12:44 pm
December 6, 2018 at 9:19 am
Yes, but it's MUCH, MUCH, MUCH, MUCH easier to use FOR XML PATH. Do you really need to use FOR XML EXPLICIT?
Drew
December 3, 2018 at 4:06 pm
This is a variation on the Set Cover Problem and has been proven to be NP-Complete.
Drew
December 3, 2018 at 3:28 pm
November 28, 2018 at 11:24 am
November 28, 2018 at 10:12 am
November 27, 2018 at 2:24 pm
Viewing 15 posts - 766 through 780 (of 4,087 total)