Jeff Moden

Forum Replies Created

Viewing 15 posts - 42,211 through 42,225 (of 59,102 total)

RE: Sending multiple rows to the Database from an Application: Part II

Need to pass as many delimited strings as the number of parameters.
Not true... please consider the following...
http://www.sqlservercentral.com/articles/T-SQL/63003/
Since, delimited string would be passed as a string data type, so limitation...
--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 25, 2009 at 8:50 pm

#1044640
RE: Are the posted questions getting worse?

RBarryYoung (8/25/2009)
Steve Jones - Editor (8/23/2009)
I don't have a personal blacklist, but I'm happy to walk away from a post/thread if someone can't respond or maintain a sense of decorum.
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)

August 25, 2009 at 7:14 pm

#1044624
RE: Storing IPv4 Addresses for Performance

Elliott W (8/25/2009)
Guys, I just got to thinking about this, but it seems this kind of conversion is right up SQLCLR's alley, once it is in memory I would think...
--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 25, 2009 at 6:36 pm

#1044617
RE: WORD UP!

No, not yet. Still have too many fires with sticks in them. :hehe:
--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 25, 2009 at 10:48 am

#1044358
RE: find the position of the charcter in delimited string

Bob Hovious (8/25/2009)
Most of the credit goes to Jeff. He taught me everything I know about Tally tables.
:blush: Thanks, Bob. I really appreciate the kudo. ...
--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 25, 2009 at 7:57 am

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

It's also known as a "Correlated Sub Query".
--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 24, 2009 at 7:31 pm

#1043960
RE: find the position of the charcter in delimited string

Heh... I've found that, for people who have never used it before, using it just once is enough to cause confusion. 😀
Personally, I see no reason not to use...
--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 24, 2009 at 11:19 am

#1043790
RE: find the position of the charcter in delimited string

Very interesting requirement and Bob seems to have solved it nicely. Just curious, what is this for?
Also, if you don't know about Tally or Numbers tables and how they...
--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 24, 2009 at 10:48 am

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

michelle.baumgarten (8/24/2009)
Since you asked --- I copied the code, entered '01/MAR/2009',1,3 for the parameters, and got a message saying:
Incorrect syntax near keyword FUNCTION.
A RETURN statement with a RETURN value cannot...
--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 24, 2009 at 10:26 am

#1043753
RE: Realignment of Bit Sequence

No answer to my previous question?
--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 23, 2009 at 1:45 pm

#1043396
RE: Calculations

npatel565 (8/20/2009)
Thanks for the help, I wrote something basic to solve it but this is just very amazing guys. Thanks again!
Would you mind sharing the "something basic" please? Two...
--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 23, 2009 at 1:38 pm

#1043395
RE: Are the posted questions getting worse?

Lynn Pettis (8/21/2009)
We'll have to wait and see. Future posts may (or may not) prove otherwise. Of cousre if he continues like he has I'd be surprised 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)

August 23, 2009 at 12:35 pm

#1043390
RE: Are the posted questions getting worse?

Bob Hovious (8/21/2009)
O Lynn, merciful patron Saint of Patience, tell us where we have failed.
Have we not asked the OP for data?
Have we not shown the OP the link 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)

August 23, 2009 at 9:10 am

#1043363
RE: Each GROUP BY expression must contain at least one column that is not an outer reference.

Please see the following...
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 23, 2009 at 9:03 am

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

sknox (8/21/2009)
Why not just do (using the function definition and parameters (and the @firstDate variable) as given):
set @firstDate = dateadd(dd,1-datepart(dd,@inputdate) ,@inputDate) -- ensures that we start with the first of...
--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:09 pm

#1043303

Viewing 15 posts - 42,211 through 42,225 (of 59,102 total)