Jeff Moden

Forum Replies Created

Viewing 15 posts - 46,216 through 46,230 (of 59,095 total)

RE: Join Query (Please Urgent !!!!!!!!!!)

Heh... interview must be over, huh? 😛
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

January 1, 2009 at 2:23 pm

#920032
RE: The Year in Review 2008

Steve Jones - Editor (12/31/2008)
Guess no one is working today or my cell phone woes didn't strike anyone as funny.
Heh... not supposed to slam "Dash" phones against the "Dash"... that's...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

January 1, 2009 at 2:21 pm

#920030
RE: Join Query (Please Urgent !!!!!!!!!!)

This is obviously either homework or an interview test.
First, please read the article at the link in my signature below for how to post questions concerning data.
Second, show us what...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

January 1, 2009 at 1:57 pm

#920026
RE: SQL Help Required!!

Venkat (1/1/2009)
The Best way to handle this is..
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...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

January 1, 2009 at 1:55 pm

#920025
RE: Dynamic Sql

EXEC (@SQL1+@SQL2+@SQL3...+@SQLn)
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

January 1, 2009 at 1:48 pm

#920022
RE: Industry Experience... Required?

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...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

January 1, 2009 at 1:46 pm

#920021
RE: aagghh! More XQuery trouble

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...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

January 1, 2009 at 1:38 pm

#920017
RE: Help creating a SQL query

santosh.shrestha (1/1/2009)
Thank you very much I have figured it out. It was quite easy. Thanks for advice regarding datatype. now I have to work on datatype of Table1. Due to...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

January 1, 2009 at 1:27 pm

#920015
RE: Cursors for T-SQL Beginners

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...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

January 1, 2009 at 1:18 pm

#920014
RE: Corporate Software Development

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...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

January 1, 2009 at 1:13 pm

#920013
RE: Looking Forward

RBarryYoung (1/1/2009)
Jeff Moden (12/29/2008)
Well, there is the handle-bar mounted 110 mm automatic loading pork chop cannon with the heat seeking sight... 😛 On the unicyle, I try to keep...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

January 1, 2009 at 12:43 pm

#920007
RE: How Would You Rate This? - Database Weekly (Dec 29, 2008)

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...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

January 1, 2009 at 12:37 pm

#920006
RE: Forum Etiquette: How to post data/code on a forum to get the best help

Thanks, eramya... but with about 13,000 posts total, I'm thinking it may take more than a week. 😛
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

January 1, 2009 at 12:34 pm

#920004
RE: How to calculate the Bi-weekly in SQL

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!
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

January 1, 2009 at 12:30 pm

#920001
RE: Data Import In SQL 2000

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...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

January 1, 2009 at 12:23 pm

#919998

Viewing 15 posts - 46,216 through 46,230 (of 59,095 total)