Jeff Moden

Forum Replies Created

Viewing 15 posts - 35,296 through 35,310 (of 59,099 total)

RE: TSQL Problem -- Cal the actual working hours for a particular users

Thanks for posting the 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)

January 20, 2011 at 8:07 pm

#1276348
RE: A different Type Of Query

CELKO (1/19/2011)
CREATE TABLE Foobar
(i INTEGER NOT NULL PRIMARY KEY);
WITH Sequenced_Foobar (i, seq)
AS
(SELECT i, ROW_NUMBER() OVER(ORDER BY i))
SELECT S1.i, S2.i
FROM Sequenced_Foobar AS S1
...
--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:17 pm

#1276339
RE: Are the posted questions getting worse?

Koen (da-zero) (1/19/2011)
WayneS (1/19/2011)
This thread has made me realize that I suck in deciphering job descriptions. Craig, hurry up with your articles - I need the help!!!
At my place, job...
--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 6:49 pm

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

GilaMonster (1/20/2011)
Ferguson (1/20/2011)
Where I continue to resist however is the whole generalist idea. They must be out there.
Sure they are. However you've indicated you want hotshots. Top skills....
--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 6:29 pm

#1276331
RE: Hierarchies in SQL

Thanks 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)

January 20, 2011 at 1:42 pm

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

marcin.motyl (1/20/2011)
Yes. I ran query 3 times with different language settings. Result are rendered against your test data.
I think, that my test environment is far weaker;).
Forgive me, but I will...
--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:25 pm

#1276228
RE: Cummulative_Sum

nandakrishnacherukuri (1/19/2011)
Thanks For giving the solution.
You're welcome but, I need to make sure, do you understand the solution? If you don't, don't use the solution because you'll need to...
--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:23 pm

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

allmhuran (1/20/2011)
"You mean an 8% increase in performance with 44% less typing? Don't you wish you could do that everywhere?"
SOLD!
Heh... I agree! Thanks for stopping by. 🙂
--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:37 am

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

Phil Factor (1/20/2011)
You'll see that the shortmonthname is correctly inserted into the date if you use CONVERT. Is there a way of using DateName to get the correct short-date? 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:35 am

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

sharath.chalamgari (1/20/2011)
Thanks Jeff for the article. i learned something about the datename function and these langauages settings.
Thanks for the feedback Sharath. As so often is the case, 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:33 am

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

radyo (1/20/2011)
My experience are just opposite. DATENAME is slower than CONVERT + DATEPART. See below:
/*------------------------
DECLARE @BitBucket CHAR(4);
PRINT '========== DATENAME Method of Conversion ==========';
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 8:27 am

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

Koen (da-zero) (1/20/2011)
Whupty-freakin'-doo! This is an amazing article!
I have never heard of DATENAME before, so thanks for pointing it out Jeff.
You bet Koen... thanks for the feedback.
As a side bar,...
--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:22 am

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

katesl (1/20/2011)
Question from a DBA--
I have to ask this question because I have no experience doing user interface programming-- I use T-SQL and SSMS, and Excel to deliver reports, 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)

January 20, 2011 at 8:19 am

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

carie dobson (1/20/2011)
Well written AND entertaining. Nice. 🙂
I've been using SqlSvr since the 6.5 days I still learn new stuff everyday. I have to admit I usually use...
--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:16 am

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

alen teplitsky (1/20/2011)
is this a SQL 2008 only function or is it in SQL 2005 as well?
I believe that it'll work in any version of Standard or Enterprise editions. ...
--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:15 am

#1275969

Viewing 15 posts - 35,296 through 35,310 (of 59,099 total)