Jeff Moden

Forum Replies Created

Viewing 15 posts - 49,246 through 49,260 (of 59,099 total)

RE: Working part-time

abba (7/10/2008)
I would like to know if anyone works part-time at their job and if so, how did you find such a position?
I answered a help wanted ad for...
--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)

July 11, 2008 at 7:38 pm

#841917
RE: Split data

For a 2 dimensional split, see the following...
http://www.sqlservercentral.com/articles/T-SQL/63003/
The real problem is going to be how to make a table from that... you will need to use the parameters in...
--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)

July 11, 2008 at 7:35 pm

#841916
RE: Null value is eliminated by an aggregate or other SET operation.

You don't have to...
SET ANSI_WARNINGS OFF
... will eliminate this expected error message.
Just to be sure about a couple of things, you might want to post the proc for a...
--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)

July 11, 2008 at 7:22 pm

#841915
RE: Selecting data in a grid?

I'm in the process of writing a couple of articles on Cross Tabs and Pivots... the more I dig into Pivots, the better I like the ol' classic crosstab. ...
--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)

July 11, 2008 at 7:10 pm

#841914
RE: Query help please!

You mean a correlated subquery, Grant?
--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)

July 11, 2008 at 6:36 pm

#841911
RE: Insert

Mike Levan (7/11/2008)
can i do this insert
INSERT INTO @GroupId, @GroupName, @ZoneInstanceId, @ScoreType
SELECT ItemId,InspectionItemName,ZoneInstanceId,ScoreTypeId from InspectionGroup
ORDER BY InspectionItemName
here InspectionGroup is a CTE
No... You cannot INSERT into scalar variables... tell us...
--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)

July 11, 2008 at 6:34 pm

#841910
RE: ERROR: String o binary data would be truncated

It because you're trying to put something too big into a column too small. It usually means there's an error in the file... might be a transmission error or...
--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)

July 11, 2008 at 6:27 pm

#841909
RE: Analytical Interview Questions

Christopher Stobbs (7/11/2008)
Thanks for that.
I'm actually look for more of an Analytical question rather than tech skills questions...
For example giving them puzzles to see what there approach to problem solving...
--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)

July 11, 2008 at 6:13 pm

#841908
RE: Analytical Interview Questions

Loner (7/11/2008)
There are two rooms separating by a wall, one room has three lamps, the one one has three switches, can you tell how to find out which switch is...
--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)

July 11, 2008 at 6:01 pm

#841905
RE: Analytical Interview Questions

rameshchandra.a (7/11/2008)
4.What are temperory tables.(perfermence wise cursors r Temperory Tables which are better)
If a WHILE loop is involved, then each will suck as bad as the other
5.What is CTE(Common Table...
--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)

July 11, 2008 at 5:42 pm

#841904
RE: By the time you could afford it you didn't need it.

Heh... I always get what I want because the best things in life... are not things. 😛
--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)

July 11, 2008 at 5:27 pm

#841902
RE: How to Pivot a table

mblack (7/11/2008)
Thanks for the help. I'm getting a syntax error i believe by my GROUP BY. The message is:
Msg 102, Level 15, State 1, Line 23
Incorrect syntax near ')'.
Other than...
--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)

July 11, 2008 at 5:11 pm

#841898
RE: Subquery vs Derived Table

... or correlated subquery.
Spot on, Gus. 🙂
--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)

July 11, 2008 at 5:08 pm

#841897
RE: Get rid of cursors

Bijal Parekh (7/10/2008)
You can try using while loop where cursor is used
Why? What do you think a cursor is, anyway? It's nothing but an internal table with a...
--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)

July 11, 2008 at 5:05 pm

#841896
RE: coalesce negative values

antonio.collins (7/10/2008)
before i write some awful case statements or multiple UDFs, is there any direct way to determine if any values in a list are negative?
coalesce_negative( 1, 1, 1,-1, 1,-1,-1,-1,...
--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)

July 11, 2008 at 4:58 pm

#841895

Viewing 15 posts - 49,246 through 49,260 (of 59,099 total)