Jeff Moden

Forum Replies Created

Viewing 15 posts - 40,591 through 40,605 (of 59,098 total)

RE: Mean, Median, Mode

Just curious... did either of those links help you sort your problem out?
--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)

December 20, 2009 at 6:32 pm

#1094562
RE: How to split the value

shuzi,
Did you ever get this sorted out or do you still need some help?
--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)

December 20, 2009 at 6:30 pm

#1094561
RE: How to access a current row particular column value

You bet. Thank you for the feedback.:-)
--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)

December 20, 2009 at 6:18 pm

#1094558
RE: New to SQL

My recommendation would be to read the following article before you do anything...
http://www.sqlservercentral.com/articles/DBA/68526/
--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)

December 20, 2009 at 4:18 pm

#1094545
RE: How to access a current row particular column value

surya-434952 (12/20/2009)
Hi Jeff,
Thanks a ton for your kind help. Its working. Could you please explain a bit about quirky update So that i can reuse this when ever 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)

December 20, 2009 at 11:40 am

#1094526
RE: enable/disable xp_cmdshell before/after Windows schedule task

Simple check in Books OnLine does it... 😉 Past the following into the URL box of the help system.
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/c147c9e1-b81d-49c8-b800-3019f4d86a13.htm
--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)

December 20, 2009 at 11:34 am

#1094524
RE: File Name

QQ-485619 (12/19/2009)
Can you please be more specific?
Thanks,
Yes, but then you'd miss out on all the fun. 😉 Did you lookup REVERSE in Books Online? Also lookup CHARINDEX which...
--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)

December 20, 2009 at 10:48 am

#1094519
RE: How to "Rebuild" all the indexes of all the tables in all the databases?

I'm not sure what's available in 2k8, but if you lookup DBCC SHOWCONTIG, there's a fully written script near the bottom of that help listing.
--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)

December 20, 2009 at 10:45 am

#1094518
RE: How to access a current row particular column value

surya-434952 (12/20/2009)
Hi Jeff,
Let me know explain the scenario clearly,
i have a table called balance sheet as follows
Dept Acct Date credit...
--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)

December 20, 2009 at 9:59 am

#1094514
RE: Looking for some fundamental help automating a query

If you don't know me by now, then let me tell you that I always have to ask "Are you sure?" when I see something like that. Same thoughts...
--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)

December 20, 2009 at 8:36 am

#1094510
RE: Dissecting SQL Server Execution Plans

Grant Fritchey (12/20/2009)
Hey Jeff,
Thanks for the great review and the kind words. "I'm not worthy" doesn't begin to cover it, but thanks for the sentiments.
Heh... Humility and knowledge will get...
--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)

December 20, 2009 at 8:27 am

#1094506
RE: Compare documents in folder to items in a table

I agree... the problem with that is (IIRC) that xp_getfiledetails is no longer available in SQL Server 2008 (although xp_DirTree is) so any upgrade plans would make some pretty loud...
--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)

December 19, 2009 at 10:41 am

#1094466
RE: How to access a current row particular column value

Provided that "value" and "some value" are different in your example, this is easy...
DECLARE @Col1 somedatatype
UPDATE yourtable
SET @Col1 = Col1 = value,
...
--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)

December 19, 2009 at 10:16 am

#1094463
RE: Looking for some fundamental help automating a query

Heh... I notice you have a "name splitter" in the code. Let me ask, what are you going to do with a name like Dr. Robert Douglas van Guttenburg...
--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)

December 19, 2009 at 10:12 am

#1094462
RE: trimming trailing spaces and zeros from a string

First of all, I have to remind everyone that SQL Server isn't a word processor and storing formatted text numbers is very contrary to what SQL Server should be used...
--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)

December 19, 2009 at 10:03 am

#1094461

Viewing 15 posts - 40,591 through 40,605 (of 59,098 total)