Jeff Moden

Forum Replies Created

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

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
RE: Rounding problem

Hi Greg... long time no see.
To round down as you seem to think you need, lookup ROUND in Books Online and study the 3rd operand of the function that not...
--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 6, 2010 at 11:27 pm

#1163792
RE: Calculate values for TallyDuration

Clive... how'd that work for you?
--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 6, 2010 at 9:17 pm

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

Agile (5/6/2010)
Thanks for reply, As I said I already did the query(T-SQL) to get the Daily, Weekly, Report, But I need them in "1" view so maybe 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 6, 2010 at 9:10 pm

#1163760
RE: Date format

Raunak Jhawar (5/6/2010)
Hi Malvika,
As a better practice it is always suggested that one should always handle date-time manipulation at database level and not on SSRS interface.
Heh... not "always suggested" because...
--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 6, 2010 at 9:06 pm

#1163758

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