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
20,172 reads
Here are a couple of functions to convert between roman numerals and integers. They are handy for all sorts of...
2011-09-20
20,172 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,640 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,198 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,128 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,292 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,517 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,948 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,608 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,982 reads
It’s me again with my apparently semi-annual blog post. This time we’re going to...
By Steve Jones
I saw an article on this and realized I had no idea how to...
In this blog post I wrote a tip about fixing the PostgreSQL backup failure...
Hey all, Currently trying to build a report in SSRS using SSAS cube. Load...
Comments posted to this topic are about the item A Partial Count
Comments posted to this topic are about the item The Stagnant Career