Viewing 15 posts - 31 through 45 (of 311 total)
And I thought I was the only one who had to see the bottom of the potato chip package...
"Hey man I can kick it anytime I want."
I just kept reading...
March 17, 2009 at 10:25 am
[/quoteBy foxjazz - 2 days ago @ 2:48 AM
Do any of you know a language other than English? Spanish, as a second or German?
Because using English is dominant,...
March 17, 2009 at 10:05 am
By foxjazz - 3/14/2009 11:18 PM
Ok, yes I did it that way before. Except you have to do it in 4 distinct query sets, and link the...
March 17, 2009 at 9:49 am
Most of the time when using cursors, it isn't to go through lots of records, but just a few at a time
This kind of justification inevitably leads to a database...
March 17, 2009 at 9:37 am
foxjazz (3/13/2009) also instead of using cursurs like they are now, wouldn't it be easier to say:
foreach( select myfield from tbl where myotherfield > 3)
{
insert into myothertable (myotherfield) values (myfield)
}
are...
March 17, 2009 at 9:05 am
So the guy, on the employer's tab and trust managed to destroy work he was paid for and on top of that he wants money to fix his sabotage.
This goes...
March 17, 2009 at 8:19 am
I strongly object to such obfuscated programming. How many beginners who subscribed to this forum could be misled into thinking "wow ! clever trick I've got to find an occasion...
March 17, 2009 at 7:52 am
Thanks Sergyi.
No, I cannot propose any better alternative, never having faced and coped with such a situation.
Regards
March 13, 2009 at 5:29 am
Michael Valentine Jones (3/11/2009)
Shorter.
select [Month] = right(100+month(getdate()),2)
Results:
Month
-----
03
I like that one! The use of of 100 is clever.
I used something like RIGHT('00' + CONVERT(varchar(2), month(getdate()), 2)
March 12, 2009 at 3:41 pm
:laugh:Now that's funny.:laugh: A good way to end a boring day converting data from a foreign RDMS system and having to wait 20 minutes for the sp to complete and...
March 12, 2009 at 3:37 pm
so...
you did pee in your boss' cornflakes ...
March 12, 2009 at 3:29 pm
Sergyi
Good point on the constraints.
However, since I am working on a specific table, I have to look no further than the table itself to find out about constraints. Also, in...
March 12, 2009 at 3:25 pm
I break into a sweat just imagining I am the one stuck with debugging this mammoth of an sql statement...
Note that the divide and conquer comments come from people with...
March 12, 2009 at 2:32 pm
Sergiy
Triggers ! :w00t:
I have this deep-rooted prejudice against "hidden" code that executes from somewhere else. Say I am trying to debug a stored proc and I forget that there is...
March 12, 2009 at 2:19 pm
Moojjoo: "I know this is a DB forum site, but I have a question "
I really fail to see why you should be concerned with posting this here. Master-Detail relationships...
March 12, 2009 at 1:48 pm
Viewing 15 posts - 31 through 45 (of 311 total)