Jeff Moden

Forum Replies Created

Viewing 15 posts - 32,236 through 32,250 (of 59,099 total)

RE: How to generate all Possible Alphabit pattern in a sequence?

Mark-101232 (10/18/2011)
Using a tally table
WITH AllAlpha(Letter) AS (
SELECT CHAR(ASCII('A')+N)
FROM dbo.Tally
WHERE N BETWEEN 0 AND 25)
SELECT (SELECT c.Letter AS "text()"
FROM...
--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)

October 18, 2011 at 9:41 pm

#1396429
RE: Getdate function not returning data

jshahan (10/18/2011)
Maybe someone sugested this and I missed it but just convert getdate() to a string and back to a date.
select CONVERT(datetime,(convert(char(10),getdate(),101))) as Today
Hopefully, you'll change your mind about that...
--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)

October 18, 2011 at 8:45 pm

#1396421
RE: BCP Code not behaving same on diff servers...

p.s. The "Underground Tour" with you guys was an absolute blast!
--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)

October 18, 2011 at 8:21 pm

#1396417
RE: BCP Code not behaving same on diff servers...

Has a proxy been created for the use of xp_CmdShell? Has xp_CmdShell been enabled? Can the production server "see" the file path you're trying to use?
Try running 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)

October 18, 2011 at 8:21 pm

#1396416
RE: How to automate database scripting

Dev @ +91 973 913 6683 (10/17/2011)
via xp_cmdshell;
Please follow the discussion... I cringe every time I see a recommendation for xp_cmdshell....
http://www.sqlservercentral.com/Forums/Topic1186236-1526-1.aspx
Heh... yes, please DO follow the discussion... ALL 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)

October 18, 2011 at 7:59 pm

#1396415
RE: Temp table loading in a proc

Lexa (10/18/2011)
Ninja's_RGR'us (10/18/2011)
Actually the first test would be to see if removing it helps.
Step 2 would be to see where and how that table is used.
Most of the time 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)

October 18, 2011 at 7:49 pm

#1396412
RE: low tech pivot

I'm not sure what you mean... In the final code result I posted, the are 6 "datapoint" columns and 22 rows for a total of 132 datapoints.
--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)

October 18, 2011 at 7:43 pm

#1396410
RE: A good place to shamelessly plug my blog?

From your first blog entry...
... I wish to attain that level of expertise and to be able to give back to the community like they have
If you really want 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)

October 18, 2011 at 7:33 pm

#1396409
RE: A good place to shamelessly plug my blog?

And make the link in your signature clickable, as well.
--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)

October 18, 2011 at 7:23 pm

#1396407
RE: Reverse Treeview

I keep looking at this problem and I guess I'm totally confused now. To me anyway, it looks like the code that ChrisM@Work posted several post above this one...
--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)

October 18, 2011 at 6:17 pm

#1396399
RE: Reverse Treeview

Alan,
I've been asking questions about this because I DO have an idea... 2 actually. I'll try to put it together tonight.
Just to confirm from the forum you've posted in,...
--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)

October 18, 2011 at 8:31 am

#1396012
RE: Jeff Moden elected Exceptional DBA of 2011

Steve Jones - SSC Editor (10/18/2011)
Congrats again, Jeff, and a nice ceremony for you and a nice speech from you. The award was well deserved.
You and Red Gate sure do...
--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)

October 18, 2011 at 8:25 am

#1395999
RE: Jeff Moden elected Exceptional DBA of 2011

bitbucket-25253 (10/17/2011)
Jeff for a guy who is 2 days older than dirt, from a guy who is 3 days older than dirt
Thanks for all you have done to teach myself...
--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)

October 18, 2011 at 8:22 am

#1395996
RE: Are the posted questions getting worse?

WayneS (10/17/2011)
Anyone have an idea if this post http://www.sqlservercentral.com/Forums/FindPost1191243.aspx is spam? (Afraid to click the link that is in that linked post...)
It's ok... he's been here before and has apparently...
--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)

October 17, 2011 at 10:40 pm

#1395683
RE: Reverse Treeview

Alan,
This sounds like a mostly static tree. Can you give an estimate on how often the tree may suffer the addition, deletion, or modifcation of at least 1 node...
--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)

October 17, 2011 at 10:21 pm

#1395678

Viewing 15 posts - 32,236 through 32,250 (of 59,099 total)