Viewing 15 posts - 16 through 30 (of 581 total)
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...
February 14, 2007 at 2:58 am
A couple of...
February 13, 2007 at 8:05 pm
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...
February 13, 2007 at 7:43 pm
This will work for counts up to 2047.
August 8, 2006 at 8:44 am
Bet on what? I see you got there first: I didn't see your entry until I posted mine.
But 4 tables, not 1?
July 24, 2006 at 6:57 pm
Applications a
July 24, 2006 at 6:11 pm
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.
July 21, 2006 at 3:11 pm
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...
July 21, 2006 at 10:44 am
Your problem is probably that the charindex() and isnumeric() checks are not working in the way you expect. Can you post the code?
July 20, 2006 at 10:50 am
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...
July 20, 2006 at 10:42 am
So are they all int columns? Is the domain the full range of int values?
July 20, 2006 at 10:18 am
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...
July 20, 2006 at 8:30 am
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...
July 20, 2006 at 8:21 am
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...
July 19, 2006 at 4:36 am
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...
July 19, 2006 at 3:07 am
Viewing 15 posts - 16 through 30 (of 581 total)
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy