Jeff Moden

Forum Replies Created

Viewing 15 posts - 50,551 through 50,565 (of 59,102 total)

RE: Tally Table

Find bad characters in a string
Remove Digits from Strings
Remove Alpha from "numbers"
Change to Title Case
Histogram of characters in a column
Generate test data (not just dates)
Find gaps in serial numbers 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)

May 14, 2008 at 11:27 pm

#815638
RE: getdate() accuracy

The following shows the accuracy you're talking about...
SELECT 1,CAST('2000-01-01 23:59:59.990' AS DATETIME) UNION ALL
SELECT 2,CAST('2000-01-01 23:59:59.991' AS DATETIME) UNION ALL
SELECT 3,CAST('2000-01-01 23:59:59.992' AS DATETIME) UNION ALL
SELECT...
--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)

May 14, 2008 at 10:48 pm

#815623
RE: getdate() accuracy

The CPU does other things... it's not dedicated to running your code.
--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)

May 14, 2008 at 10:41 pm

#815621
RE: Obtaining year and week numbers from a date in SQL

Ack... double post... :sick:
http://www.sqlservercentral.com/Forums/Topic500305-5-1.aspx?Update=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)

May 14, 2008 at 10:19 pm

#815612
RE: SQL Year and Week numbers

Ack... double post.... :sick:
http://www.sqlservercentral.com/Forums/Topic500664-338-1.aspx
--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)

May 14, 2008 at 10:18 pm

#815610
RE: SQL Year and Week numbers

When using DATENAME, it's already in a character format, so you don't need to use CONVERT or CAST...
SELECT DATENAME(yy,GETDATE())+RIGHT('00'+DATENAME(wk,GETDATE()),2)
--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)

May 14, 2008 at 10:08 pm

#815608
RE: Convert Float to Varchar

Better question to ask is why is the column in your table VARCHAR(18) instead of FLOAT like it should be?
--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)

May 14, 2008 at 10:04 pm

#815605
RE: The Lighter Side - Life is like an analogy

What a riot! I laughed out loud especially at the end. Well done, David!
In the same vein, someone needs to write an article on how to be politically...
--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)

May 14, 2008 at 3:15 pm

#815559
RE: You are a T-SQL developer who needs to...

Heh... no problem, Steve... I know about the QOD's and the fact that, like you said, they can't cover every caveat. It's one of those questions that someone asked...
--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)

May 14, 2008 at 1:52 pm

#815521
RE: How to random dates

MD (5/14/2008)
Jeff
I'm not sure if I can use this because it took so long to run. I mean, I can think of better things to do with my seven...
--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)

May 14, 2008 at 1:44 pm

#815515
RE: How to random dates

Thanks for the compliment, Todd... :blush:
Au4848... are you all set?
--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)

May 14, 2008 at 11:54 am

#815454
RE: Uncomfortable situation at office

It really is 'he said, she said'
If you perceived it as "almost stalking", so will others... don't forget to protect your self.;)
--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)

May 14, 2008 at 11:28 am

#815439
RE: How to random dates

Well done John and Matt! Exactly correct on both parts!
Todd, here's the long answer... Funny thing... I'm actually writing a series of articles on the generation of constrained random...
--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)

May 14, 2008 at 11:09 am

#815414
RE: How to find gaps between date ranges

Michael,
They don't come right out with an example that I can easily find in BOL, but if you put a couple of bread-crumbs together, you come up with the following...
--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)

May 14, 2008 at 8:52 am

#815270
RE: The CLR

Renato Buda (5/14/2008)
Regexp Expressions
Compression of Blobs
Concatenate() aggregate function
All the above have proved useful.
**** The 8K limit is an urban myth!!! ****
see the following for a sample:
http://www.codeproject.com/KB/database/blob_compress.aspx
What kind of...
--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)

May 14, 2008 at 8:07 am

#815223

Viewing 15 posts - 50,551 through 50,565 (of 59,102 total)