Viewing 15 posts - 1,726 through 1,740 (of 4,820 total)
March 9, 2018 at 12:41 pm
March 9, 2018 at 12:35 pm
March 9, 2018 at 12:31 pm
Be sure to modify the properties of the e-mail body to HTML first.
March 9, 2018 at 12:21 pm
March 9, 2018 at 12:19 pm
I installed both 32 bits ODAC and 64 bits.
I run it from Visual studio 2017...
March 9, 2018 at 11:49 am
junk.mail291276 - Friday, March 9, 2018 10:43 AMAll right, well guess I gotta bight the bullet. Thanks sgmunson.
Creating hollow points, eh? ...
March 9, 2018 at 11:45 am
At least be sure you match the 32-bit vs. 64-bit execution context for the SSIS package to match the "bit-ness" of the ODBC driver. If the driver is 32-bit, then...
March 9, 2018 at 11:40 am
March 9, 2018 at 11:37 am
SELECT PrimaryKeyColumn, TRY_CONVERT(xml, VarcharColumn) AS XMLValue, VarcharColumn
FROM YourTable
WHERE TRY_CONVERT(xml, VarcharColumn) IS NULL
AND VarcharColumn IS NOT NULL;
This should identify the problem rows.
March 9, 2018 at 11:34 am
ZZartin - Friday, March 9, 2018 10:16 AMThat seems like that would be better done at the application layer.
Regardless of where the...
March 9, 2018 at 11:29 am
Try this on for size:CREATE PROCEDURE dbo.YourStoredProc (
@Year AS smallint = NULL,
@Month AS smallint = NULL,
@type AS varchar(5) = NULL,
@debug AS bit = 0,
@Phone_Mask AS...
March 9, 2018 at 11:07 am
Sorry to burst your bubble, but that's just how CASCADE ON DELETE works. You really just can't have your cake and eat it too. The idea behind CASCADE ON DELETE...
March 9, 2018 at 10:23 am
March 9, 2018 at 10:16 am
Andy Reilly - Thursday, March 8, 2018 10:14 AMHi Steve,Why would that make a difference only when exporting to excel ?
SSRS is...
March 8, 2018 at 10:31 am
Viewing 15 posts - 1,726 through 1,740 (of 4,820 total)