Viewing 15 posts - 346 through 360 (of 621 total)
mazzz (3/20/2009)
1[/sup] names like the UK ones do?(1) In a good way, I mean!
My favorite, in nomenclature only, since I've never tried it, is "Old Leghumper",...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
March 20, 2009 at 12:09 pm
Sergiy, the quote button is taking me to the wrong post, but you said
Except varchar as PK adds extreme overhead for data processing.
in your last post. Do you know...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
March 19, 2009 at 2:22 pm
Jack Corbett (3/18/2009)I have to ask though, have you read all 2700+ posts?
I'm up to around page 30, and I have found it particularly entertaining, especially where you guys post...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
March 18, 2009 at 2:44 pm
GSquared (3/18/2009)
in SQL 2005/2008 by using the inserted table in the insert proc..
Gsquared, are you saying that in 2005/2008, I can access the inserted and deleted tables directly from a...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
March 18, 2009 at 1:12 pm
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...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
March 18, 2009 at 12:27 pm
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...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
March 18, 2009 at 10:50 am
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,...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
February 24, 2009 at 4:35 pm
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...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
February 24, 2009 at 3:06 pm
What is the best way to convert data to SQL which can be later re-loaded to Oracle?
Not really sure what you mean by that. Are you talking about porting...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
February 20, 2009 at 2:11 pm
Boy...I wish my school gave an 'A' for an 83.
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
February 20, 2009 at 1:50 pm
Mark, thanks again for your quick response.
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
February 12, 2009 at 9:22 am
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...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
February 12, 2009 at 8:13 am
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...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
February 12, 2009 at 8:10 am
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)),
...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
February 12, 2009 at 8:07 am
Thanks for the tip guys, I'll have to do some experimenting when I get back to work.
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
January 29, 2009 at 6:00 pm
Viewing 15 posts - 346 through 360 (of 621 total)