Jeff Moden

Forum Replies Created

Viewing 15 posts - 38,581 through 38,595 (of 59,102 total)

RE: replace a string

jayanp (5/7/2010)
Yes.Need to add in to a stored procedure.
Since I did not get any reply, I found out the solution myself.
Thanks anyway.
I understand the disappointment of "no reply", but...
--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)

May 8, 2010 at 11:37 am

#1164590
RE: Need Ideas for a large lookup table solution

Cory Blythe (5/7/2010)
Some of the more common uses would be find all Values of Zip2 within 10 miles of Zip1 etc.
One of the very useful performance tweeks here is 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)

May 8, 2010 at 11:32 am

#1164588
RE: query to get a part of strin

Cory E. (5/7/2010)
This is why we are looking for requirements.
Heh.... I understand the lesson in progress but I thought the requirements were actually pretty clear on this one. 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)

May 8, 2010 at 11:19 am

#1164587
RE: Calculate values for TallyDuration

Heh... I just wanted to know if it worked for you. :blush: Thanks for the compliment, Clive.
Just a followup warning... don't take any shortcuts or deviate from 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)

May 8, 2010 at 11:03 am

#1164585
RE: Need Help in SQL Query - conatinating column values

RAJ GOPAL (5/7/2010)
Hi
Refere to this link
http://www.simple-talk.com/sql/t-sql-programming/concatenating-row-values-in-transact-sql/
What I really hate about articles like that is it's mostly just a list of methods someone collected and posted without any reasonably sized...
--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)

May 8, 2010 at 10:46 am

#1164583
RE: Need Help in SQL Query - conatinating column values

Rajesh Arra (5/7/2010)
Thank you all, will work on it and get back to you if needed
Better than that, get back to us with how you ended up implementing it. ...
--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)

May 8, 2010 at 7:36 am

#1164559
RE: Return the records that equal the sum.

Damn... great idea. This is a "bin stacking" problem and I know people that would kill to have this as a truly scalable solution. The solution, as...
--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)

May 8, 2010 at 7:34 am

#1164558
RE: Daily,Weekly,Monthly Report using TSQL

Thanks. That's just what I needed.
Like I said, UNION ALL the 3 queries and do a simple Cross Tab... this will do what you want it to...
SELECT preagg.Dept,
...
--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)

May 8, 2010 at 1:00 am

#1164532
RE: Adding row and column totals to a dynamic pivot table

Chris Lindley (5/7/2010)
Thanks Lutz. But for someone who is pretty new to this stuff there's a very large gap between my code and your article, especially if I 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)

May 8, 2010 at 12:24 am

#1164528
RE: SQL Server DBA.... what next?

CirquedeSQLeil (5/7/2010)
eric_russell 13013 (5/7/2010)
This discussion just underscores why it's imporatant to always have at least 2 admins and 2 developers who know your database, just in case someone steps 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)

May 7, 2010 at 11:26 am

#1164316
RE: Daily,Weekly,Monthly Report using TSQL

Agile (5/6/2010)
Thank you for your reply, sorry for not acknowledging his codes , yes your right it's much faster compare to my codes, but still my problem is that how...
--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)

May 7, 2010 at 7:42 am

#1164097
RE: MAXDOP

Grant Fritchey (5/7/2010)
Everyone turning off parallelism is ignoring the fact that some queries can benefit. I strongly recommend you explore increasing the cost threshold of parallelism before you simply switch...
--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)

May 7, 2010 at 7:37 am

#1164092
RE: Getting Colorful

Heh... my colorful name for certain types of code is likely obvious at this point in history...
[font="Arial Black"]RBAR[/font]
--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)

May 7, 2010 at 7:26 am

#1164083
RE: inserting Commas

I don't know about the "deep internals", but a scalar function has the same affect as calling a stored procedure where an iTVF used with a CROSS APPLY makes 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)

May 7, 2010 at 6:53 am

#1164044
RE: Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs

ziangij (5/7/2010)
great article... thank you 🙂
You're welcome. Thanks for both the visit and 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)

May 7, 2010 at 6:32 am

#1164014

Viewing 15 posts - 38,581 through 38,595 (of 59,102 total)