Jeff Moden

Forum Replies Created

Viewing 15 posts - 35,311 through 35,325 (of 59,099 total)

RE: Formatting Dates with 3 Character Months (SQL Spackle)

bitbucket-25253 (1/20/2011)
I use a "throw away" variable (@BitBucket)
BWAA-HAA!!!
Hmmmm
The quotes aside .. Jeff a great article with more sample code than most of us deserve.
Thanks, as 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)

January 20, 2011 at 8:13 am

#1275966
RE: Formatting Dates with 3 Character Months (SQL Spackle)

eric.hinrichsen (1/20/2011)
Thanks for the tips on DATENAME (a function I think I'd used awhile back but had faded from my memory)
I too would have done something like (limiting the convert...
--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 20, 2011 at 8:10 am

#1275963
RE: Formatting Dates with 3 Character Months (SQL Spackle)

nigel. (1/20/2011)
David McKinney (1/20/2011)
Très bien, Jeff! Except of course that you can't keep everybody happy!
In France, June and July are Juin and Juillet respectively, and hence JUI and JUI...
--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 20, 2011 at 8:04 am

#1275955
RE: Formatting Dates with 3 Character Months (SQL Spackle)

surreydude. (1/20/2011)
Interesting article. Mal-formed dates are the bane of my professional life; often this goes hand-in-hand with Excel data and/or lack of user discipline and validation.
I've experienced date-related issues whilst...
--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 20, 2011 at 8:02 am

#1275954
RE: Formatting Dates with 3 Character Months (SQL Spackle)

marcin.motyl (1/20/2011)
Different method
DECLARE @BitBucket CHAR(10);
SET STATISTICS TIME ON;
SELECT @BitBucket = substring(convert(varchar(100), SomeDate,13) , 4,8)
FROM dbo.JBMTest
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)

January 20, 2011 at 7:56 am

#1275949
RE: Formatting Dates with 3 Character Months (SQL Spackle)

David McKinney (1/20/2011)
I did a little more hunting and I came across sys.syslanguages which looks quite promising.
To continue with the French exception, it has fields months and shortmonths with the...
--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 20, 2011 at 7:43 am

#1275939
RE: Formatting Dates with 3 Character Months (SQL Spackle)

tommyh (1/19/2011)
Have to say i dont really like the Convert version. There are as i see it multiple "problems" with it compared to DateName (the case version isnt really anything...
--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 20, 2011 at 1:17 am

#1275722
RE: Formatting Dates with 3 Character Months (SQL Spackle)

David McKinney (1/20/2011)
Très bien, Jeff! Except of course that you can't keep everybody happy!
In France, June and July are Juin and Juillet respectively, and hence JUI and JUI when...
--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 20, 2011 at 1:14 am

#1275721
RE: Linked Server Query In A View

mister.magoo (1/19/2011)
Solution:
Well I think I finally found the problem....ready....datatype conversion.
The remote column that I was selecting on "order_no" had a type of CHAR(10).
The query was SELECT .... FROM ... WHERE...
--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 19, 2011 at 11:48 pm

#1275688
RE: Where do you look for DBA's?

Ferguson (1/19/2011)
Wow, flurry of info, thanks.
First, the job descriptions posted were NOT for my job. I was not trying to turn this into a "anyone want 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)

January 19, 2011 at 11:22 pm

#1275674
RE: Where do you look for DBA's?

This is going to sound really mean and negative but I'm actually trying to point out a major flaw which may actually be scaring qualified candidates away...
If Remi did post...
--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 19, 2011 at 10:43 pm

#1275670
RE: Cummulative_Sum

nandakrishnacherukuri,
First, thanks for the readily consumable test data and the CREATE TABLE code. That answered all of my questions without me having to ask. Well done! 🙂
Second, here'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 19, 2011 at 9:26 pm

#1275660
RE: Cummulative_Sum

Ninja's_RGR'us (1/19/2011)
So what's the question?
The question was in the sub-title of the post on the forum page.
--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 19, 2011 at 8:25 pm

#1275652
RE: ThankYou

Very cool post, Justin. Thank you for taking the time. 🙂
--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 19, 2011 at 8:23 pm

#1275651
RE: An Introduction to Database Design

This article is an incredible launch for the continuing adventures of Bob's database and the friends that help him with the original design and modifications coming up. The article...
--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 19, 2011 at 7:03 pm

#1275637

Viewing 15 posts - 35,311 through 35,325 (of 59,099 total)