Viewing 15 posts - 3,421 through 3,435 (of 4,080 total)
Unfortunately the computer science of sql barely exists.
Ted Codd would be very surprised to learn that. Pity he isn't still alive.
...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
March 15, 2009 at 10:22 am
Sorry I didn't post my code. There's nothing secret about it, but Rob requested it in PM and I respected his request. I was...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
March 14, 2009 at 8:11 pm
Jeff, two things.
1. Some code is missing from your first example. But I presume you were going to cross join syscolumns to itself. I...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
March 14, 2009 at 12:58 pm
Also be prepared for the possibility that the database design will be critiqued. If it turns out that the table structure is a poor design, the fault...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
March 14, 2009 at 12:03 pm
I guess I'm lucky that my guys just ask me for stored procedures now. They know I will give them something that runs fast on the front...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
March 14, 2009 at 10:52 am
First you're going to have to get the file into the database. Your code just specifies a string constant, and you are assuming there is magic to go...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
March 14, 2009 at 9:33 am
my requirement is that i have get the details about the parentid's along with the recursive data' in a single join
Test question?
I've been taking buisness requirements for years, and never...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
March 14, 2009 at 9:18 am
Perhaps he sensed the strength of the Force within you, my little green friend.
More likely, he hit the bars soon after his last post.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
March 14, 2009 at 12:24 am
Or he's a kid who is finally reaching a comfort level in one language, and now he wants everything to be like that so it will come easier to him....
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
March 14, 2009 at 12:16 am
I'm waiting to see if the ranter gets off his high horse or comes back for more ugliness. I bit back my first reply which was...
Really stupid paradigm...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
March 13, 2009 at 11:49 pm
Get some sleep, Jeff.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
March 13, 2009 at 11:11 pm
If you look at BOL (books online - the SQL Server Help function) you can find the format for both the EXISTS keyword and the IN keyword ... with EXAMPLES...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
March 13, 2009 at 10:46 pm
And yet another 😛
declare @number varchar(100)
set @number = '12345678902331234'
select @number as [before], len(@number) as [length]
set @number = STUFF(@number,1,len(@number)-4,REPLICATE('*',len(@number)-4))
select @number as [after], len(@number) as [length]
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
March 13, 2009 at 10:25 pm
There are ways to take sums and then to take averages of those sums, but they usually involve different groupings. For example I could take the sum of...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
March 13, 2009 at 10:12 pm
You're welcome. Have a good weekend.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
March 13, 2009 at 10:07 pm
Viewing 15 posts - 3,421 through 3,435 (of 4,080 total)