Viewing 15 posts - 1,381 through 1,395 (of 8,760 total)
May 30, 2018 at 7:23 am
May 30, 2018 at 7:21 am
May 30, 2018 at 5:34 am
[code...
May 29, 2018 at 9:45 am
Can you please check the expected results as those do not match the sample data.
😎
Here is an example of reverse charindex, in this case extracting 6...
May 29, 2018 at 9:05 am
May 29, 2018 at 8:22 am
May 29, 2018 at 2:51 am
This should get you passed this hurdle
😎
USE TEEST;
GO
SET NOCOUNT ON;
--https://www.sqlservercentral.com/Forums/1962235/Special-output-from-xml-data-with-XQuery
Declare @TXML XML = N'
<xml>
<row...
May 29, 2018 at 12:28 am
May 28, 2018 at 5:56 am
Quick suggestion, add the TYPE directive to handle any extended characters and the text() function to prevent the reconstruct of the XML for the output.
😎
[code...
May 27, 2018 at 6:31 am
Here is a more efficient way of doing this, the code should be self explanatory.
😎
May 27, 2018 at 5:59 am
Piling on, there are at least 15 alternatives to the format function, all of which are at least 10 times faster, some are closer to 1000 times faster
😎
May 26, 2018 at 3:49 am
May 26, 2018 at 1:35 am
May 24, 2018 at 10:09 am
May 24, 2018 at 9:43 am
Viewing 15 posts - 1,381 through 1,395 (of 8,760 total)