Jeff Moden

Forum Replies Created

Viewing 15 posts - 31,576 through 31,590 (of 59,101 total)

RE: Equivalant of "Left Join" but in XML

I see you've added "mind reading" to your list of skills. That was going to be my next question if I couldn't suss it on my own. Thanks,...
--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 25, 2011 at 4:43 pm

#1425439
RE: Equivalant of "Left Join" but in XML

I suspected that an OUTER APPLY was going to be involved. I just didn't know enough to solve it myself. Nicely done, Lutz. I'm going to have...
--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 25, 2011 at 4:36 am

#1425411
RE: Problem with running total

It's been 10 days since the last post on this thread. Did you find a solution or do you still need 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)

December 24, 2011 at 3:51 pm

#1425378
RE: create folders using t-sql

Learner1 (12/9/2011)
Thanks Lowell...
Your answer is perfect but I cannot use xp_cmdshell as No permission
Msg 15281, Level 16, State 1, Procedure xp_cmdshell, Line 1
SQL Server blocked access to procedure 'sys.xp_cmdshell' 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)

December 24, 2011 at 3:44 pm

#1425376
RE: create folders using t-sql

Lowell (12/9/2011)
just saw you said no xp_cmdshell;
in that case, unless you can install a CLR, theres no way to do this from TSQL. xp_cmdshell is the only thing i know...
--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 24, 2011 at 3:38 pm

#1425374
RE: quick way to create a table that has every day of the year in it?

captcooldaddy (12/16/2011)
Anyone know how to do this. I've done it in the past however forgot which sys table i used for generating this.
create table #date
(
dayOfYear datetime
)
insert into #date (...
--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 24, 2011 at 3:15 pm

#1425372
RE: Query slow... using CTE

nithiyanandam-447806 (12/21/2011)
the following qry is very slow. qry have CTE command with union all...
In my environment we need to find telephone no with two different tables. both tables have more...
--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 24, 2011 at 2:09 pm

#1425365
RE: Your Boss Is Your Customer

TravisDBA (12/23/2011)
Jeff Moden (12/20/2011)
Gosh, Andy. Although I appreciate where you're going in these articles, that's, what? 4 in a row about how to be a better employee? ...
--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 23, 2011 at 4:37 pm

#1425295
RE: People That Get It Done

Then you know that not all Union Workers are slouches. 😉 But I do get your point... it's a lot harder to get rid of a unionized slouch than...
--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 23, 2011 at 4:16 pm

#1425293
RE: Using Month(Getdate()) with Between ... need help

Tamrak (12/23/2011)
Hello,
I have these existing codes:
CASE WHEN Month(GetDate()) BETWEEN 2 AND 7 THEN 2
ELSE 1 END AS FiscalCyle
This one works, when the months fall between February to July.
There are...
--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 23, 2011 at 4:09 pm

#1425292
RE: Pay Ranges

SQLKnowItAll (12/22/2011)
It is just a selling point for me that helps me negotiate since I cannot use years of experience. I have only been a DBA for 3 years 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)

December 23, 2011 at 4:07 pm

#1425291
RE: Thanks

Nice thoughts, Dhirju. Merry Christmas to you, 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)

December 23, 2011 at 3:51 pm

#1425290
RE: merge statement and cte(common table expression)

pramany (12/23/2011)
Hello all,
i am new to these topics
can any body breifly explain about merge statement and cte.
i am confusing while learning cte.can someone differ temp table, table variable 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)

December 23, 2011 at 3:46 pm

#1425289
RE: One of the worst examples of 3rd party SQL I've ever seen

Heh... gosh... I don't know why anyone would think that's bad code considering the "standard" that MS set when they wrote sp_execresultset for SQL Server 2000.
--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 23, 2011 at 2:51 pm

#1425284
RE: Question on index column ordering

Dev (12/23/2011)
Gail I agree to you on SEEK operation but I care about following.
Clustered indexes are not a good choice for the following attributes:
Columns that undergo frequent changes
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)

December 23, 2011 at 2:12 pm

#1425282

Viewing 15 posts - 31,576 through 31,590 (of 59,101 total)