Viewing 15 posts - 1,411 through 1,425 (of 4,087 total)
December 21, 2017 at 1:04 pm
How much query tuning can you really expect from a simple select statement that only returns seven rows with no joins, a single SARGable where condition, and a sort?
December 21, 2017 at 12:53 pm
SELECT *
FROM TicketItem
WHERE CAST(SUBSTR(TO_CHAR(dt_when,...
December 21, 2017 at 11:41 am
December 21, 2017 at 10:20 am
December 21, 2017 at 10:02 am
SELECT ,[Name] ...
December 21, 2017 at 9:35 am
December 20, 2017 at 2:36 pm
December 20, 2017 at 2:31 pm
that is wonderful work , i need a help to write this in...
December 20, 2017 at 10:16 am
The problem got a little more complex...
December 20, 2017 at 9:48 am
December 20, 2017 at 9:07 am
The problem is that we don't have access to your tables, so we cannot select from them, so we cannot insert into the table variable. If I try to run...
December 20, 2017 at 8:54 am
I have your answer and will provide it once you provide consumable data.
Drew
December 20, 2017 at 8:03 am
INSERT/SELECT statements do us no good, because we don't have access to the tables in the SELECT part of the statement. You need to provide sample data as INSERT/VALUES statements. ...
December 20, 2017 at 8:01 am
Viewing 15 posts - 1,411 through 1,425 (of 4,087 total)