Jeff Moden

Forum Replies Created

Viewing 15 posts - 39,196 through 39,210 (of 59,098 total)

RE: The Missing Certification

dma-669038 (3/27/2010)
<<What I find sorely lacking in most resumes is a list of significant accomplishments. I want to know "what have you done in the time you've had and 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)

March 27, 2010 at 8:32 pm

#1141016
RE: The Missing Certification

Lynn Pettis (3/27/2010)
I do have an MA and BS degree, but haven't had the time to get an MS certs as yet, so curious Jeff, where would I fall 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)

March 27, 2010 at 7:03 pm

#1141012
RE: Need simple way (using t-sql) to generate "realistic"-looking numbers...

Jeff Moden (3/27/2010)
SwePeso (3/27/2010)
The good Lord allows you to jump in, huh Jeff? 😀
Ummm... not sure I understand the reference or the question, Peter. What do you mean 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)

March 27, 2010 at 6:54 pm

#1141011
RE: The Missing Certification

To be sure, I'm not against certs, degrees, and other supposed tally marks of education. When done correctly, they are well deserved.
The problem is that so many do them...
--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)

March 27, 2010 at 3:06 pm

#1140991
RE: Need simple way (using t-sql) to generate "realistic"-looking numbers...

SwePeso (3/27/2010)
The good Lord allows you to jump in, huh Jeff? 😀
Ummm... not sure I understand the reference or the question, Peter. What do you mean or have I...
--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)

March 27, 2010 at 2:48 pm

#1140989
RE: Need simple way (using t-sql) to generate "realistic"-looking numbers...

Quatrei.X (3/25/2010)
I agree with Eric
SELECT CAST((RAND()*1000000000) AS INT)
since you said no "-"
but if it includes dashes like lowell's example, thi is my code
DECLARE @i INT
SET @i=1
DECLARE @tbl TABLE (SSN NVARCHAR(11))
WHILE...
--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)

March 27, 2010 at 2:24 pm

#1140984
RE: Need simple way (using t-sql) to generate "realistic"-looking numbers...

Eric Zierdt (3/24/2010)
SELECT CAST((RAND()*1000000000) AS INT)
Let me know if that works for ya
That only works for one row at a time which means you'll also need to use some form...
--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)

March 27, 2010 at 2:12 pm

#1140983
RE: Records missing

Sudarsan Srinivasan (3/26/2010)
Apparently this got fixed with a SQL server restart...
All that's left to do is get rid of the loop and you're golden! 😉
--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)

March 27, 2010 at 2:06 pm

#1140982
RE: Duration value in a Trace

Heh... I believe so.
Of course, there might be the "parameter sniffing" thing going on, as well. 😀
--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)

March 27, 2010 at 2:01 pm

#1140981
RE: Cross apply Ambiguity

And now we know why I've gotten in the habit of aliasing all column names. Out of habit, it's even bled over into queries that only have one 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)

March 27, 2010 at 1:59 pm

#1140980
RE: T-SQL Oddities

As a bit of a side bar, my favorite name for a Temp table used to resolve a difficult problem is... you guessed it... #MyHead. 😛
--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)

March 27, 2010 at 1:49 pm

#1140978
RE: PIVOT FOR 2 or more Columns

Bhavin_Bhatt25 (3/27/2010)
Hi all.
I have developed CTE which gives result using PIVOT; Its working perfect. as follows.
Item Year ...
--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)

March 27, 2010 at 1:43 pm

#1140976
RE: Parse field with Numeric ranges and comma deliminated values

Heh... absolutely remarkable. On a bit of a meloncholy note, it's amazing how things have changed in the last 7 or so years on this fine forum. "I...
--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)

March 27, 2010 at 1:40 pm

#1140975
RE: Money vs. Decimal Data type

You're supposed to round the final answer.
--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)

March 27, 2010 at 1:20 pm

#1140970
RE: Debugging T-SQL

IIRC, you need the Enterprise version of SQL Server to use DEBUG and you need some seriously elevated privs even then. The detailed information you seek is too long...
--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)

March 27, 2010 at 1:15 pm

#1140968

Viewing 15 posts - 39,196 through 39,210 (of 59,098 total)