Viewing 15 posts - 976 through 990 (of 1,464 total)
Ed Wagner - Wednesday, October 11, 2017 12:00 PMTransaction
Level
October 11, 2017 at 12:04 pm
Ed Wagner - Tuesday, October 3, 2017 6:59 AMBullet
Vegas (Sorry)
October 3, 2017 at 7:32 am
That said, let's see what...
September 30, 2017 at 12:56 am
September 27, 2017 at 11:41 pm
Revenant - Wednesday, September 27, 2017 7:32 PMOpposites
Attract
September 27, 2017 at 11:22 pm
September 26, 2017 at 8:49 am
This should do the trick.
SELECT NEWDATETIME = DATEADD(DD, DATEDIFF(DD, 0, DATEFIELD1), 0) + CAST(CAST(DATEFIELD2 AS TIME) AS DATETIME)
September 12, 2017 at 10:17 pm
September 5, 2017 at 10:04 pm
September 4, 2017 at 11:55 pm
With no indexes to help it, SQL has to do a full table scan.
Add an index to B
Without the full query and table DDL, it is almost...
September 3, 2017 at 10:21 pm
August 30, 2017 at 6:27 pm
August 27, 2017 at 11:56 pm
August 25, 2017 at 7:14 am
Viewing 15 posts - 976 through 990 (of 1,464 total)