Jeff Moden

Forum Replies Created

Viewing 15 posts - 42,196 through 42,210 (of 59,067 total)

RE: Realignment of Bit Sequence

naveenreddy.84 (8/21/2009)
Hi Jeff,
Thanks!!! but this works only for the value of seq 111
Will it work for seq like 110, 101, 001,011? when the resid 2 is removed, the final...
--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 21, 2009 at 4:37 am

#1042685
RE: date function

smknox (8/20/2009)
Hi Jeff:
The reason I was adding a date from one column to the time of another column is because: This is a medical application and one surgical procedure...
--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 11:46 pm

#1042608
RE: Are the posted questions getting worse?

"You can lead a horse to the water..."
http://www.sqlservercentral.com/Forums/Topic774023-149-1.aspx
--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 10:35 pm

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

Heh... you say you understand, but I just can't bring myself to show you how to do it wrong, Paula. Sorry...
--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 10:31 pm

#1042595
RE: Realignment of Bit Sequence

Very cool... that pretty much explains it and it allows me to test my code for you. This will do it.
DELETE FROM Table1
WHERE AID ...
--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 10:18 pm

#1042589
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)
That's ok. I really really want it to work. I have been working on it for ages and would really appreciate it if you could.
Thank you so much!!!
Are 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)

August 20, 2009 at 10:05 pm

#1042583
RE: Summarize columns by rowcount from a selected set of database tables

By the way... do all the tables that match the pattern have an identical structure and identical column names?
--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:57 pm

#1042582
RE: Summarize columns by rowcount from a selected set of database tables

grover (8/20/2009)
Is this a far reaching request and can this even be done efficiently in SQL or should I look elsewhere?
Uh... and where would you 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)

August 20, 2009 at 9:52 pm

#1042580
RE: Changing a column from ntext to nvarchar(max)

Matt (8/20/2009)
Hi
I want to change a column in one of my tables from ntext to nvarchar(max), I was just wandering if there is likely to be any kind of data...
--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:47 pm

#1042579
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)
Thank you so much for spending the time to do that. Can I ask you for one more favour? Can you get the code I wrote to work also?
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 9:45 pm

#1042578
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

Viewing 15 posts - 42,196 through 42,210 (of 59,067 total)