Viewing 15 posts - 976 through 990 (of 1,468 total)
Name = CASE WHEN GROUPING([ie].[Amount]) = 0 THEN [ie].[Amount]...October 18, 2017 at 7:48 am
Ed Wagner - Friday, October 13, 2017 1:46 PMSchool
Shoal
October 13, 2017 at 3:44 pm
You have 2 updates to the same table, with a trigger firing on each update.
I would try doing a single updateUPDATE [dbo].[UO_MList]
SET GeneralSales_HolidaySales_OptIn...
October 11, 2017 at 12:39 pm
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
Viewing 15 posts - 976 through 990 (of 1,468 total)