Viewing 15 posts - 3,091 through 3,105 (of 7,615 total)
Look for function (ITVF) dbo.DelimitedSplit8K,
October 24, 2018 at 1:51 pm
October 23, 2018 at 10:13 am
October 23, 2018 at 9:43 am
October 23, 2018 at 9:32 am
Try this:
REPLACE(accountx, '-', '.')
October 22, 2018 at 2:36 pm
October 22, 2018 at 2:05 pm
October 22, 2018 at 11:25 am
Just delete the rows. If it's not that many rows, it's more work than it's worth to try to TRUNCATE.
I suspect (hope) the temp table is clustered first...
October 22, 2018 at 11:21 am
For this particular need, you just need to touch up your original script to bit to avoid unnecessary errors:
CREATE TABLE ##temp_fbl
(
DBName nvarchar(200),
October 22, 2018 at 11:15 am
CAST is more flexible than specifying a specific format.
Thus, I'd suggest TRY_CAST ... AS date to perhaps allow more data to be automatically converted to a date.
October 18, 2018 at 2:28 pm
Viewing 15 posts - 3,091 through 3,105 (of 7,615 total)