Surely this is base 27?

1 becomes 0A, 2 becomes 0B, 26 becomes 0Z, 27 becomes A0, 28 becomes AA,... seems pretty clear to me. OK, then there's a slight...

Just to be a bit pedantic, the + 1 here:

UPDATE MyTable SET MyColumn  = MyCounter + 1

means you will start your numbering at 2.

A couple of...

I've come across this sort of problem before, but it was a longish time ago so I can't guarantee that my account is exactly right, but from memory:

1. SQL determines...

select * from table t

join master.dbo.spt_values n

on n.number < t.count

where n.type = 'P'

This will work for counts up to 2047.

Bet on what? I see you got there first: I didn't see your entry until I posted mine.

But 4 tables, not 1?

select a.Name ObjectName, a.AppID ObjectID, a.IsSecurityRisk

from

Applications a

union

Tim Wilkinson

"If it doesn't work in practice, you're using the wrong theory"
- Immanuel Kant

If you want to define a cursor on the output of a sp, you need to use INSERT...EXEC into a (temp) table, then define your cursor on that table.

The list of columns which the DISTINCT keyword will operate on is already provided in the SELECT list. Yu just need to add the DISTINCT keyword. If you want to...

Your problem is probably that the charindex() and isnumeric() checks are not working in the way you expect. Can you post the code?

I can't work out what you are actually trying to achieve. What is the logic behind all these cycles and random numbers? It seems overcomplicated. Is the approach dictated by logical...

So are they all int columns? Is the domain the full range of int values?

You could try a checksum with an explicit column list, and change the order of the columns. This can help to reduce duplicate values. what are the columns you are...

If you don't want the user-defined objects to be in every database you create, you should remove them from the model database. Unless you do that, you will have to...

This also presupposes that you convert your lat/longs into a suitably flattened grid projection as on a map with square grid. The surface distance of one minute of either longitude...

Cross join is certainly the way to achieve the described result. But you mention every possible combination of all three categories - do you want to ignore the association between group...