Jeff Moden

Forum Replies Created

Viewing 15 posts - 46,666 through 46,680 (of 59,095 total)

RE: Cross Tabs and Pivots, Part 1 – Converting Rows to Columns

Kris (12/11/2008)
pretty much, it wasn't my decision, I simply have to make a program to fit within their protocol. With reporting services, the excel format is easy, so long 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)

December 11, 2008 at 8:00 pm

#911419
RE: Urgent: Need help with Query on Group By Part

Jeez... good luck with that... As I said, SUM and AVG don't work with OVER in SQL Server the same way as they do in Oracle. Test it 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 11, 2008 at 7:55 pm

#911418
RE: How do you archive data?

Gabe (12/11/2008)
Jeff, I would be interested in learning more about the "chunk" routines.
No problem... Skull Killer is right though... it would be handy if you could describe what the archive...
--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 11, 2008 at 7:52 pm

#911417
RE: Updating a Column Using a Recursive Definition

r.hensbergen (12/11/2008)
Jeff Moden (12/11/2008)
johncyriac (12/10/2008)
Have a look at Tally/Number Table methods also
Sure... got any links? 😉 And, how do they apply for this particular problem?
Tip: add next...
--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 11, 2008 at 7:39 pm

#911416
RE: Updating a Column Using a Recursive Definition

It's nice to see some documented code for a change. Thanks. 🙂
I think you've made things just a little difficult on yourself and I think I can 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 11, 2008 at 7:25 pm

#911414
RE: Columns (header) and setting something off

Try adding the -n parameter to the OSQL cmd line.
--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 11, 2008 at 7:04 pm

#911412
RE: Wacko SMTP email with ActiveX

Heh... well, someone had to answer 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)

December 11, 2008 at 12:52 pm

#911294
RE: Wacko SMTP email with ActiveX

BWAA-HAAA!!! Sorry for the previous dumb question folks... didn't realize it would be this easy. Thought I'd share my results... of course, the email and IP addresses 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 11, 2008 at 10:23 am

#911212
RE: Splitting comma data to rows

Ian Ritchie (12/1/2008)
I have a function which I use to split the address on a few databases (It is separated by a carriage return, so just amend the code 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)

December 11, 2008 at 9:32 am

#911190
RE: display Full date values which falls under 2 input date values

Actually, if you do a search for "Numbers Table", you'll find all manner of methods to make such a "tableless" number generator. I don't use them... I use an...
--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 11, 2008 at 6:32 am

#911022
RE: display Full date values which falls under 2 input date values

sabarichandru (12/11/2008)
Hi jeff,
thanks for your kind gesture .
could u reveal the logic behind the Query you sent .
Thanks in Advance!
Regards,
Sabari.C
Basically, it's nothing more than a bunch of "derived tables"...
--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 11, 2008 at 5:52 am

#910993
RE: display Full date values which falls under 2 input date values

Sergiy (12/10/2008)
Jeff, I know, you've got SQL2k5 to play with, but this is SQL2k forum, remember?
😉
Crud... nah... I missed that... I was just flying through some posts and didn't look....
--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 11, 2008 at 5:46 am

#910985
RE: Urgent: Need help with Query on Group By Part

rite2shubhra (12/10/2008)
I want to Exclude the two columns from the Group By clause of the following query, If I don't include them its giving me error that "Column 'T4.ORG_NAME' is...
--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 11, 2008 at 5:42 am

#910982
RE: Urgent: Need help with Query on Group By Part

Zeev Kazhdan (12/11/2008)
Because
All I want to put City and State information in front of Project
means for me that all the calculations should be done for the group of those...
--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 11, 2008 at 5:40 am

#910981
RE: Updating a Column Using a Recursive Definition

johncyriac (12/10/2008)
Have a look at Tally/Number Table methods also
Sure... got any links? 😉 And, how do they apply for this particular problem?
--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 11, 2008 at 5:37 am

#910980

Viewing 15 posts - 46,666 through 46,680 (of 59,095 total)