Forum Replies Created
Viewing 15 posts - 37,351 through 37,365 (of 59,098 total)
-
RE: Parsing Parameters in a Stored Procedure
tom.groszko (8/10/2010)
With SQL2008 you do have the option of a table variable. I was using XML and found that the table variable provided all the flexibility but was much faster.Any...
--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) -
RE: Parsing Parameters in a Stored Procedure
Be careful with the code in the article. Be aware that it doesn't do full validation. It only evaluates what's right and give no indication as to what...
--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) -
RE: Parsing Parameters in a Stored Procedure
I'm torn. The article is well written and the code examples are pertinent to the article. However...
It was a quick read I did through the article so 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) -
RE: Parsing Parameters in a Stored Procedure
jcboyer-1091017 (8/10/2010)
I have been using an XML string to achieve the same results. Not sure that it is faster, but it is quite flexible as:EXEC sp_xml_preparedocument @idoc OUTPUT, @XMLParameters
insert into...
--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) -
RE: Are the posted questions getting worse?
Chris Morris-439714 (8/10/2010)
Lynn Pettis (8/9/2010)
bitbucket-25253 (8/9/2010)
Celko is at it againhttp://www.sqlservercentral.com/Forums/Topic965546-1292-1.aspx#bm966047
For a community which attempts to help, even the most inept, and helps so many this guy Celko is a real...
--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) -
RE: Are the posted questions getting worse?
Steve Jones - Editor (8/9/2010)
If only I had a shirt like 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) -
RE: CrossTab or Pivot
Novicejatt (8/6/2010)
HiYes I did. But I don't have so much experience in SQL. Also I'm working in weeks. I tried to modify the query but could not get it 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) -
RE: TSQL or SSIS
KBSK (8/9/2010)
its better i would've gone through SSIS approach...Now i got a bad impression 🙁
Thanks,
KB
Ummm... are you saying that other people have a bad impression of you because of 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) -
RE: generate insert statements with data
ssis learner__ (8/9/2010)
@jeff,I used your code with union all and QUOTENAME,
It works fine with all datatypes...
SELECT 'SELECT ' + QUOTENAME(cal,'''')+',' ...--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) -
RE: Are the posted questions getting worse?
Steve Jones - Editor (8/6/2010)
I'm not a big candy guy, but there is one that I usually can't resist.
I fully understand why... the package looks like your shirt. 😀
--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) -
RE: Are the posted questions getting worse?
Lynn Pettis (8/9/2010)
Alvin Ramard (8/9/2010)
Hey Lynn! Howzit goin, eh? 🙂Boring day. In processing with Security and HOUR, get to my cube (already missing having an office) and no...
--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) -
RE: Are the posted questions getting worse?
CirquedeSQLeil (8/9/2010)
Chris Morris-439714 (8/9/2010)
Brandie Tarvin (8/9/2010)
Is it wrong to cry when someone tells me they don't know what Bulk-Logged is?http://www.sqlservercentral.com/Forums/Topic961511-146-2.aspx#bm966015
It's a forestry expression.
That is scary - check the timestamps 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) -
RE: Are the posted questions getting worse?
Dave Ballantyne (8/9/2010)
Woot woot , just got my speaker selection email for sqlbits. Time to get some material together now..Congratulations and I understand the EXCITEMENT!!!!! :-P;-):-P;-) 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) -
RE: SQL subquery WHERE IN clauses
CELKO (8/9/2010)
>> I have this problem: <<No, you have a lot of conceptual problems. You do not know the correct terms for RDBMS and SQL, or how do a 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) -
RE: SQL subquery WHERE IN clauses
blackbird (8/9/2010)
Why are you using a WHERE IN instead of an INNER JOIN? Generally the INNER JOIN has a better performance and looks cleaner. 🙂I'd post my code that shows...
--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)
Viewing 15 posts - 37,351 through 37,365 (of 59,098 total)