Viewing 15 posts - 1,771 through 1,785 (of 2,648 total)
You are joining two tables together some how but you haven't shown us the rest of the query.
January 23, 2019 at 2:09 pm
I know, i've tried converting everything to varchar(6) (even the principalid in the underlying table) and...
January 22, 2019 at 12:19 pm
January 22, 2019 at 9:53 am
Try replacing
EXEC sp_executesql @sqlQuery
with
PRINT @sqlQuery
Then you will see what it is attempting to execute.
January 22, 2019 at 8:57 am
January 22, 2019 at 4:35 am
January 21, 2019 at 8:09 pm
I think you will half the calls to your function if you use a cross apply:SELECT k.KENNEL_NO AS KennelNumber,
ISNULL(k.KENNEL_STAT, '') AS KennelStatus,
ISNULL(k.kennel_substat, '') AS KennelSubstatus,
January 21, 2019 at 2:28 pm
Do you have 1 row per Timestamp, TagName? If so I think your query is probably about as fast as it will go. If you have many rows per Timestamp, TagName...
January 21, 2019 at 12:54 pm
SELECT o2a.SOURCE_ID source_id, o2a.VALUE
FROM CR2Copy..OBJECT_TO_ATTRIBUTEshould be
January 21, 2019 at 9:09 am
It might be worth trying to rewrite the query. The query below is equivalent to your query and will produce a different execution plan:
It would be good if you...
January 21, 2019 at 8:19 am
January 21, 2019 at 6:54 am
UPDATE A
SET A.Action = IIF(B.EmpId IS NULL,'create', 'update')
FROM dbo.DutyA A
LEFT JOIN dbo.DutyB
ON B.EmpId = A.EmpId
...
January 20, 2019 at 6:30 pm
January 20, 2019 at 9:26 am
8 hours sounds too much that simple query with that execution plan.
How many rows are on your table?
How big are the columns?
How many rows do...
January 19, 2019 at 7:21 am
Viewing 15 posts - 1,771 through 1,785 (of 2,648 total)