Jeff Moden

Forum Replies Created

Viewing 15 posts - 42,226 through 42,240 (of 59,102 total)

RE: Nth occurence of a day in a month/year

michelle.baumgarten (8/21/2009)
Can't get this to work.
The code works fine for me. You need to post the exact code that you can't get to work so we 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)

August 22, 2009 at 2:00 pm

#1043300
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/21/2009)
Thanks Jeff, I've learned something new today! 🙂
Very cool. Thanks for the feedback, William.
--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 7:08 am

#1042793
RE: Twenty tips to write a good stored procedure

arup_kc (8/18/2009)
Hi,
Sorry for late replying, actually I was out of net for last 3 weeks. I have seen the comments. I do agree that I had some misconceptions, which are...
--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 7:06 am

#1042790
RE: Are the posted questions getting worse?

ta.bu.shi.da.yu (8/21/2009)
I can't help it... I gave her a derived table with which she can do a group by on. I have no idea if it will work (no easy...
--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:42 am

#1042692
RE: Are the posted questions getting worse?

Bob Hovious (8/20/2009)
You gotta love it. He passes out a solution that performs faster AND (to me) reads simpler. But no, they still want him...
--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:41 am

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

Viewing 15 posts - 42,226 through 42,240 (of 59,102 total)