Viewing 15 posts - 1,261 through 1,275 (of 8,760 total)
First, I apologize, I don't speak cloud. But I'll do my best 🙂
In short, I...
July 21, 2018 at 2:20 am
Mike01, you should add the text() function to your code, simplifies the execution plan by bypassing the reconstruct of the XML for the output.
😎
The code with...
July 19, 2018 at 11:51 pm
I have used some XML in my SQL to split a...
July 19, 2018 at 10:27 pm
Heh... I've been playing the part of a terrorist on that one... "Bin...
July 19, 2018 at 8:53 am
I did ask you for the full create statement, your posts do not list any input parameters! On top of it, you have a data set that nobody can see...
July 19, 2018 at 8:36 am
DECLARE @LAT1 FLOAT...
July 19, 2018 at 3:19 am
Quick question, are you trying to calculate geographical distance?
😎
Quick example using the geography spatial data type
DECLARE @LAT1 FLOAT = 37.6053577010;
July 19, 2018 at 2:08 am
I have table of IPv6 range such as:
2001:254::/32 or 2001:420:4490::/44
Does anybody have function to check if...
July 15, 2018 at 12:35 am
Jeff, where should I start on this? Not translating the binary values, in the right order, caveats on the ranges covered, unsigned datatype as a base?
😎
Datetime...
July 14, 2018 at 12:34 pm
July 14, 2018 at 1:50 am
Just a quick note, DATE data type is stored as 3 byte little-endian, which has number of days after 0001-01-01. This means that i.e. 0001-02-01 = 0x1F0000 when in the right...
July 14, 2018 at 1:30 am
SELECT TOP (100) PERCENT dbo.CLEAR.ID, dbo.CLEAR.DESCRP, dbo.CLEAR_AUX.OWNER, dbo.CLEAR_AUX.EMAIL
FROM dbo.CLEAR INNER JOIN
...
July 12, 2018 at 11:06 am
July 12, 2018 at 10:38 am
Thanks in advance for any solutions I have been doing some searching and...
July 12, 2018 at 10:36 am
When I run this Query as an Import:
SELECT ID, OWNER, EMAIL
FROM dbo.CLEAR_AUX
i get...
<Binary data>...
July 12, 2018 at 10:25 am
Viewing 15 posts - 1,261 through 1,275 (of 8,760 total)