Jeff Moden

Forum Replies Created

Viewing 15 posts - 32,641 through 32,655 (of 59,099 total)

RE: SQL Update Statement Based on some date Value '00000000'

Ummmm.... what is the data-type for those date columns in the COALESCE?
--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)

September 5, 2011 at 10:40 am

#1377101
RE: Stored procedure naming prefix

I know it's several years old but that's still a good article, Roy. They should rerun it now and again.
--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)

September 5, 2011 at 10:28 am

#1377098
RE: Looking for help taking the RBAR from this problem

mister.magoo (9/4/2011)
Jeff,
I tried your test data/sample query on my desktop with different results:
(Microsoft SQL Server 2008 R2 (SP1) - 10.50.2500.0 (X64) Jun 17 2011 00:54:03 ...
--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)

September 4, 2011 at 6:09 pm

#1376923
RE: Question about forums and individual statuses

Tom.Thomson (9/4/2011)
GilaMonster (9/4/2011)
Tom.Thomson (9/4/2011)
As for raisins in bobotie, wouldn't a green apple be better? Or maybe okra?
Yuk, No way. Raisins, ground or chopped almonds (I prefer ground), chutney and...
--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)

September 4, 2011 at 5:19 pm

#1376918
RE: What should I be doing with my points?

Brandie Tarvin (4/29/2011)
Oh, no! I almost forgot. The big grand prize for the points redemption is a Flying Porkchop Flinger.
Save those points, boys and girls. It takes a couple 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)

September 4, 2011 at 5:15 pm

#1376917
RE: How to know the format of a text file

tinnusqlserver (5/5/2011)
Hi folks.... needed your suggestions.....
I had created a text file named "forward.txt" in windows operating system. How can i know whether my text file...
--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)

September 4, 2011 at 5:08 pm

#1376916
RE: How do you format your SQL queries, just curious --

GSquared (8/29/2011)
I tend to use brackets where needed. I use table aliases and column aliases where they are needed or where they help to read the query, like if...
--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)

September 4, 2011 at 5:01 pm

#1376914
RE: Running totals

cidr (9/4/2011)
Hi jeff. Do you know if this is still possible?
It absolutely possible. And, no, this is NOT directed at you but someone has really been eating some...
--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)

September 4, 2011 at 4:29 pm

#1376908
RE: Looking for help taking the RBAR from this problem

How about ~1 milli-second first time, everytime along with shorter times to rebuild the clustered index and maybe no need to ever rebuild it? 😉
The code below is in 3...
--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)

September 4, 2011 at 3:38 pm

#1376905
RE: Get list of months, monthname and Year

paul_ramster (8/31/2011)
In just a couple of years, this table is only going to contain past dates.
If you're going to create a calendar table, it should contain more years than this,...
--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)

September 4, 2011 at 11:40 am

#1376891
RE: Get list of months, monthname and Year

ColdCoffee (9/4/2011)
Added more details in code and optimized it.
Be careful, CC... The WHERE clause keeps it from being "optimized". The entire 1,000 rows in the "Numbers" CTE will always...
--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)

September 4, 2011 at 11:25 am

#1376889
RE: Get list of months, monthname and Year

tamil.selvanmca (9/2/2011)
WITH DateYear AS
(
SELECT 0 AS num
UNION ALL
SELECT num + 1 FROM DateYear
...
--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)

September 4, 2011 at 10:37 am

#1376884
RE: Looking for help taking the RBAR from this problem

clubbavich (9/3/2011)
@jeff
Here is how the devices are distributed.
Server_Id, Device_Id
1 has 1540 Device_Id's
2 has 742 Device_Id's
3 has 357 Device_Id's
4 has 26 Device_Id's
5 has 917 Device_Id's
Thanks. I'll put something together tomorrow....
--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)

September 3, 2011 at 8:22 pm

#1376823
RE: Get list of months, monthname and Year

komal145 (8/31/2011)
Thank you for all responses...I got it!!!
Cool! Please post the code you ended up using so that we all may learn. 😉
--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)

September 2, 2011 at 8:19 pm

#1376734
RE: Need help with custom ordering, null first/last

Michael Valentine Jones (8/31/2011)
It would be simpler to use dynamic SQL and just construct the exact ORDER BY clause that you need.
+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)

September 2, 2011 at 8:15 pm

#1376733

Viewing 15 posts - 32,641 through 32,655 (of 59,099 total)