Jeff Moden

Forum Replies Created

Viewing 15 posts - 42,241 through 42,255 (of 59,102 total)

RE: Column '(x) ' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause.

Sorry... I left out one "%" wildcard in the code above... I've fixed the code above.
--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)

August 20, 2009 at 9:33 pm

#1042575
RE: Column '(x) ' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause.

paula (8/20/2009)
I'm sorry. But I am a bit lost here. I think I need the sum aggregate function. I don't think max will give me what I'm looking for.
I understand...
--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)

August 20, 2009 at 9:28 pm

#1042574
RE: Column '(x) ' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause.

Alright... give me a bit and I'll show you how to do the pre-aggregated cross tab from the article link I just posted. It'll also improve performance drastically.
--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)

August 20, 2009 at 8:05 pm

#1042555
RE: Column '(x) ' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause.

WilliamB (8/20/2009)
Hi Paula,
You need to include your CASE statements in your group by clause for your query to work. eg:
SELECT TOP 10
[VOLUME] = count(1),
[ISVALID] =
CASE BOT_DR_CLIENT_NO
WHEN 1 THEN 'YES'...
--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)

August 20, 2009 at 8:03 pm

#1042552
RE: round function behaviour

"Rounding" doesn't mean the same thing as "Formatting" and how ROUND displays a result really shouldn't matter... formatting should be done in the GUI especially on date, time, and currency...
--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)

August 20, 2009 at 7:58 pm

#1042551
RE: Realignment of Bit Sequence

What is the datatype of the SEQ column. Also, you're kinda new... take a look at the article in the first link in my signature line below. I...
--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)

August 20, 2009 at 7:52 pm

#1042549
RE: What's cold backup.?

San (8/19/2009)
Ok. By the way, why do we need to detach the DB for taking abckup.? What's the advantage.?
There is only one... how many people can change data during a...
--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)

August 20, 2009 at 7:45 pm

#1042547
RE: What's cold backup.?

San (8/19/2009)
Asked in an interview.
So, what did you answer in the interview?
--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)

August 20, 2009 at 7:43 pm

#1042546
RE: doing some math in query

middletree (8/20/2009)
I'm asked to report some fields from a particular table, most of which are straightforward. The last two, however, are "2009 list price" and "2008 list price". In 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)

August 20, 2009 at 7:38 pm

#1042545
RE: Do DBA's (SQL 2008) need to know T-SQL

Not only should they know T-SQL, but they should be "dancing with the stars" when it comes to T-SQL because guess who gets to "tune the database"? Guess who...
--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)

August 20, 2009 at 7:20 pm

#1042540
RE: cursors in stored procedure

mirravi9 (8/20/2009)
but i need to write a stored procedure using cursor
As the others have stated, "No... you probably don't". The thing is, we need more info about your 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)

August 20, 2009 at 7:12 pm

#1042539
RE: Select distinct into or dedupe faster

Ghanta (8/20/2009)
(not many duplicates though)..
It's important... how many?
--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)

August 20, 2009 at 7:09 pm

#1042538
RE: Need advice

If the production server has a large amount of data on it, backup/restore probably isn't the most effective method. If a SAN is involved, it sometimes comes with or...
--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)

August 20, 2009 at 7:07 pm

#1042537
RE: to_char

As a bit of a sidebar... unless this formatting you want to do is strictly for output to a file, you should let the GUI do date formatting so 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)

August 20, 2009 at 7:03 pm

#1042536
RE: Benchmarking software....

Heh... corporate made the brilliant decision to move our SQL Servers to VM. We're a "sub division" of the main company and had to comply. We've had nothing...
--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)

August 20, 2009 at 6:58 pm

#1042533

Viewing 15 posts - 42,241 through 42,255 (of 59,102 total)