Jeff Moden

Forum Replies Created

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

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
RE: String manipulation

Thanks, Sapna... :blush: Such a nice compliment is a great way to start the day. 🙂
--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:01 am

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

Me too... except I'd add one thing...
UPDATE Employee
SET SocialSecNumber = stuff(stuff(SocialSecNumber , 6, 0, '-'), 4, 0, '-');
WHERE SocialSecNumber NOT LIKE '%[^0-9]%'
... just to be on the safe side.
--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 13, 2008 at 11:13 pm

#814942
RE: How to random dates

One other thing... why do you want to scramble the dates in such a fashion?
--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 13, 2008 at 11:06 pm

#814941

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