Seasons Greetings to all

Have you looked at the RAND function (Random number generation) for example to generate your Id value ?:

DECLARE @I DECIMAL(10,8)

SET @I = RAND( (DATEPART(mm, GETDATE()) * 100000 )

...

From BOL (2008)

Multiplies by an amount and...

Nice question for the beginning of the week ..

Jan Van der Eecken

And yes, I do remember punchcards (but not paper tapes)! Biggest fun was when my female colleague at varsity came down the stairs with two drawers full...

A lot of reading, but a nice question which will certainly teach those who answer incorrectly.

Thanks

john.arnott Posted Today @ 7:02 PM

Ron (AKA Bitbucket),

You were spoiled having as much as 32K (I assume bytes) to work with, let alone be able to chain...

Evil Kraig F (12/19/2011)

---

Good lord. Some of you are Older than Steam!

I'm not even going to get in this old fogie contest, best I can offer is starting out...

Stefan Krzywicki Posted Today @ 10:55 AM

Those of you who have been talking about the first machines you used in the industry, what was it that got you to that...

LutzM Posted Today @ 9:07 AM

Hmmm.... interesting....

Based on the (almost public available) age of the two fellows you're somewhat between 14 and 16 years old. Hard to believe that you've...

Revenant (12/18/2011)

---

As in MLCM, IOCTL and the rest of...

Revenant (12/17/2011)

I have started on 2 September 1970, on an IBM 360/40 installation that was pride of the town: 128k of memory, 8 tape drives, and 8 2311 disk drives...

SQL Kiwi (12/17/2011)

---

Good question. If you had wanted to be really sneaky...

DECLARE @Example TABLE (col1 VARCHAR(10))

INSERT @Example VALUES ('X'), ('X' + SPACE(1)), ('X' + SPACE(2))

SELECT COUNT_BIG(*) FROM @Example AS...

Why settle for an approximate date. Create a table calendar and use the value of interval to return a exact date.

CREATE TABLE #Calendar

(xdate SMALLDATETIME NOT NULL, Interval...

SQLQuest29 (12/16/2011)

---

Thanks Lowel !

But my problem is that the data is integer and I get it as 465, 356, etc .. I need to convert it into meaning full data.

I...