My favorite, in nomenclature only, since I've never tried it, is "Old Leghumper",...

Sergiy, the quote button is taking me to the wrong post, but you said

in your last post. Do you know...

I'm up to around page 30, and I have found it particularly entertaining, especially where you guys post...

Gsquared, are you saying that in 2005/2008, I can access the inserted and deleted tables directly from a...

Greetings all. Admitedly, reading "the rant" lead me to this thread, and at the risk of seeming to barge in on a club of which I am not a...

maifs, something like this might work for you. I am assuming that all areas are of the same format, that is, there is a space between the last numerical...

Thanks for the advice bitbucket. I should have clarified that I have two laptops in question. The first one, and the one on which I did the install,...

Thanks to both for the quick replies. It seems to have worked. When I ran the disk, it asked me if I wanted to generate a key for...

Not really sure what you mean by that. Are you talking about porting...

Boy...I wish my school gave an 'A' for an 83.

Mark, thanks again for your quick response.

Here is another thought I had. My dates solution only generates one day in order for the whole year, and only allows one product to be ordered on that...

Thanks Mark, that is exactly what I was looking for, and I guess you posted it just before I posted my solution. I am going to have to take...

Well, this works, but it is not really random, but I guess for my purposes that does not really matter.

SELECT

ORDER_DT = DATEADD(d,N-1,DATEADD(yy,DATEDIFF(yy,0,GETDATE())-1,0)),

...

Thanks for the tip guys, I'll have to do some experimenting when I get back to work.