Viewing 15 posts - 46,186 through 46,200 (of 59,062 total)
Venkat (1/1/2009)
Instead of storing the value as column in table
Write a Function which will return the contribution percentage
example F_GET_COUNTRY_CONTRIBUTION ( country_name, Year)
By...
January 1, 2009 at 1:55 pm
While I believe that industry experience can, indeed, be a huge help, I believe it should be "nice to have" rather than a requirement when it comes to DBA's and...
January 1, 2009 at 1:46 pm
The more I see about the problems of XML in a database, whether real or percieved, the more happy I am that I've taken the very bitter and hardline stance...
January 1, 2009 at 1:38 pm
santosh.shrestha (1/1/2009)
January 1, 2009 at 1:27 pm
gryphonsclaw (1/1/2009)
You don't have to use a cursor to concatenate a string.DECLARE @myVar varchar(MAX)
SET @myVar = ''
SELECT @myVar = @myVar + mycolumn + ' '
FROM myTable
SELECT @myVar
The author...
January 1, 2009 at 1:18 pm
We have the 3 foot cube wall thing... it's great for communication. So far as IM goes, it's ok when it's not abused. I find it totally stupid...
January 1, 2009 at 1:13 pm
RBarryYoung (1/1/2009)
Jeff Moden (12/29/2008)
January 1, 2009 at 12:43 pm
Heh... Happy New Year to you and your's, Steve!
Man... keep up the awesome work on SSC... I went a visited more than a dozen other sites just to...
January 1, 2009 at 12:37 pm
Thanks, eramya... but with about 13,000 posts total, I'm thinking it may take more than a week. 😛
January 1, 2009 at 12:34 pm
Man-o-man... I trully hope no one got any feelings hurt... it was all a bit of fun to watch.
Happy New Year, folks! Better times are coming!
January 1, 2009 at 12:30 pm
RBarryYoung (12/31/2008)
Jeff Moden (12/31/2008)
Jay,It's a bit of a misnomer... all single quotes must be turned into 2 single quotes... not actual "double quotes". ... 😛
Hmmm, maybe we should have...
January 1, 2009 at 12:23 pm
paulhunter (12/31/2008)
Welcome to the other side of the looking glass.
Heh... more like a one way mirror... could be interpreted as "check valve". 😛
January 1, 2009 at 12:20 pm
Steve Jones - Editor (12/31/2008)
I do think they ought to adhere to a schedule, but not at the expense of bad code.
[font="Arial Black"]FINALLY![/font] That's exactly what I've been saying...
January 1, 2009 at 12:18 pm
npfitzner (1/1/2009)
Tom.Thomson (1/1/2009)
He wants to remove the From clause from the Update statement? Seriously?No - I think that's what the 😉 was for.
🙂
Yes! He actually...
January 1, 2009 at 12:15 pm
Viewing 15 posts - 46,186 through 46,200 (of 59,062 total)