Viewing 15 posts - 1,531 through 1,545 (of 2,356 total)
New Event {EVENTNAME}...
December 7, 2017 at 11:22 am
Did you actually read Books Online?
This may work.
DATETIMEFROMPARTS (DATEPART(year, c.Calldate), DATEPART(month, c.Calldate), DATEPART(day, c.Calldate), DATEPART(hour, c.calltime), DATEPART(minute, c.calltime), DATEPART(second, c.calltime), 0)
December 6, 2017 at 1:25 pm
From Books Online:
CAST - Deterministic unless used with datetime, smalldatetime, or sql_variant
Try using CONVERT with the style specified.
And, why are you converting to a...
December 6, 2017 at 12:22 pm
My understanding is when in DB is backed up in "simple" mode , even...
December 6, 2017 at 10:53 am
November 30, 2017 at 11:16 am
I had the same issue on various servers, and ended up putting a loop in place to test for something reading or writing to the logs.
This code can certainly...
November 29, 2017 at 12:51 pm
November 17, 2017 at 11:43 am
November 17, 2017 at 9:01 am
November 16, 2017 at 7:54 am
This is a classic catch-all query.
I had this exact same issue to deal with, a search screen with an almost an infinite number of possibilities.
I captured the...
November 15, 2017 at 3:20 pm
Is it possible to post the actual code?
November 15, 2017 at 2:09 pm
November 13, 2017 at 8:15 am
SELECT CAST(column1 AS INT) AS column1 is your error.
You can't cast 'ABC' to an integer.
November 3, 2017 at 11:25 am
Viewing 15 posts - 1,531 through 1,545 (of 2,356 total)