Roman Numerals to integers, and Vice Versa, in SQL:
Here are a couple of functions to convert between roman numerals and integers. They are handy for all sorts of...
2011-09-20
19,561 reads
Here are a couple of functions to convert between roman numerals and integers. They are handy for all sorts of...
2011-09-20
19,561 reads
Today, I needed a way of searching through a database, any database, looking for a certain string. The procedure I...
2011-07-08
3,564 reads
A moment ago, I was deep in some coding. What it was is not entirely relevant, With a page-full of...
2011-06-30
2,579 reads
/*
When you are having to extract just part of a string in TSQL, there are a number of techniques you...
2011-06-14
2,196 reads
The other day, I was answering a question on the ASK.SQLSERVERCENTRAL.COM forum from a programmer who had hit a
problem...
2011-01-28
2,117 reads
You have to admire Microsoft for sticking to their guns, even when being palpably stupid. I refer, of course to...
2011-01-13
3,275 reads
In SQL we are used to the GROUP BY and the type of result it produces. In real life, we...
2010-10-11
1,510 reads
/* Have you ever come across the problem where you have to remove spaces from a string that has too many?...
2010-09-30
2,939 reads
/*I'd be very surprised if you've ever used the old COMPUTE clause in SQL Server. It is a bit mad,...
2010-09-23
1,607 reads
--Whilst trying to design a more effective way of detecting dependencies in a SQL Server database, I was mulling over...
2010-07-29
1,981 reads
By Steve Jones
Today’s coping tip is to appreciate your hands and all the things they do...
By alevyinroc
On to the FIRST Robotics Competition 2023 World Championship Last week I wrote about...
My biggest fear when my book went into production was that any factual errors...
SELECT BusinessEntityID,FirstName,MiddleName,LastName, YEAR(OrderDate) AS OrderYear, DATENAME(MM,OrderDate) AS OrderMonth FROM Person.Person Pp INNER...
I am after some advice, I have completed a SSRS migration 2017 - 2019. ...
Hi, I've been tasked with finding out why we've been unable to patch the...