Gosh, Eirikur... now you've got me asking the same as what Thomas asked...

That's an awful lot of implicit (Reverse) and explicit conversions just to handle some negative time stamps...

Just had a look at the negative timestamp values and...

Too simple!

😎

Here is the code:

USE TEEST;
GO
SET NOCOUNT ON;
GO
CREATE OR ALTER FUNCTION dbo.ITVF_UXTS_TO_DT2
(
   ...

Good point Jeff,

never used the functions for negative timestamps, will have to adjust the logic as the binary structure wrecks havoc on the bit-bashing approach, -1 being 0xFFFFFFFFFFFFFFFF, -2 =...

Thank you, Jeff, for this fine article.

I found your approach very interesting as it is quite different from mine.

😎

Here are the two functions I use for converting Unix TimeStamp to...

• This reply was modified 3 years, 3 months ago by Eirikur Eiriksson.

We have a stored procedure that frequently getting blocked in production and sometimes is falling as a victim of deadlock. In normal cases, it executes usually in around 1...

The program becomes vulnerable to SQL injection if user input is added to a SQL query without change, as in the example below:

$unsafe_variable = $_POST['user_input']; 

mysql_query("INSERT...

Make no mistake, I will performance test it when I get access to a SQL 2022 instance. To me, it's not worth installing Dev Edition on my...

I had a SQL Server 2000 system that got to 25k transactions/sec when we turned on the intranet. The intranet was too slow that day, and I told them...

I have a saying that I borrowed from the Submarine Service about things like that... "Don't worry about the fire... the flooding will put it out"....

• This reply was modified 3 years, 3 months ago by Eirikur Eiriksson.

Same as the...

Same as the...

Hi Patrick,

can you post the DDL (create table) for the tables, and sample data as an insert statement?

😎

Combining the datasets on the RDBMS is much more efficient than attempting such...

Quick question, are the data sets in a relational database, i.e. SQL Server?

😎

Here is a quick sample that should get you over this hurdle

😎

USE TEEST;
GO
SET NOCOUNT ON;
GO
---------------------------------------------------------------------
-- EXAMPLE 1: SPLITTING A SINGLE STRING
---------------------------------------------------------------------
DECLARE @TSTR   VARCHAR(100)  ...

Job security is a very flexible term 😉

😎