Jeff Moden

Forum Replies Created

Viewing 15 posts - 27,856 through 27,870 (of 59,101 total)

RE: How to Shcedule set of SP,executing sequencly

Lookup "IF", "@@ERROR", and "RETURN" in Books Online.
--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)

December 15, 2012 at 9:44 am

#1568888
RE: ORDER BY Should be same as my input in IN()

Josh Ashwood (12/12/2012)
Every time i open that database management window now.. that thought is there..
"Is what I am doing wrong.. not a LITTLE bit wrong.. but TOTALLY FUNDAMENTALLY WRONG?"...
--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)

December 15, 2012 at 9:33 am

#1568887
RE: ORDER BY Should be same as my input in IN()

CELKO (12/11/2012)
You have no idea how RDBMS and SQL work. The list in the IN() predicate is a set; sets have no order. The result of a query is 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)

December 15, 2012 at 8:28 am

#1568886
RE: ORDER BY Should be same as my input in IN()

Eugene Elutin (12/11/2012)
....
SELECT AA.*
FROM @T AA,
@T_INPUT BB
WHERE AA.NAME=BB.NAME
ORDER BY...
--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)

December 15, 2012 at 7:03 am

#1568884
RE: Split input string into multicolumn - multirows

murthyvs (12/14/2012)
Hi Jeff - Sorry those things are not pairs/dont increment by one. I just made that example in excel.
Like I said... remarkable coincidence. Thanks for the feedback.
--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)

December 14, 2012 at 9:21 pm

#1568876
RE: Split input string into multicolumn - multirows

Yes... both variables and any/all string literals must be defined as VARCHAR(MAX) including the ones that hold the single character delimiters. It's one of the great joys of recursive...
--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)

December 14, 2012 at 9:17 pm

#1568875
RE: Split input string into multicolumn - multirows

dwain.c (12/14/2012)
Jeff has said (he can correct me if I'm wrong) that DelimitedSplit8K is optimized for VARCHAR(8000) so change it to VARCHAR(MAX) with that in mind.
I think although I don't...
--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)

December 14, 2012 at 9:02 pm

#1568870
RE: Split input string into multicolumn - multirows

murthyvs (12/14/2012)
Hi - the solution works as expected. Is there anyway to increase the size of the input string to 100,000. Its only limited to 8,000.
Thanks much!
Unless your example...
--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)

December 14, 2012 at 8:49 pm

#1568869
RE: Archieving Data

runal_jagtap (12/12/2012)
The data in the databases are large in amount.. die to which if some one want to retriev report from that db the performance is very poor, the 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)

December 14, 2012 at 8:05 pm

#1568866
RE: Deadlock due to intra-query parallelism

Abdul Rahman (12/14/2012)
Thanks Kevin.
I will check it out.
But after interpreting the output and discussing with the developers, they want to start with adding with(Nolock) to all the queries, detected...
--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)

December 14, 2012 at 7:59 pm

#1568865
RE: how to read xml variable using openxml

jos.moy (12/14/2012)
Hola,
No entiendo bien tu pregunta, espero te pueda ayudar esto, no hablo ni escribo bien el ingles
select
campo.value('(/Encabezado/Heads_dependiendo_arbol_del_XML)[1]','tipo_dato'')
from tabla
y de ahi ya podrias manejar tu fecha a tu gusto,...
--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)

December 14, 2012 at 7:26 pm

#1568863
RE: Value of column dependent on the values of others. How can I do it . Please help !

dragosgrigs (12/14/2012)
Thank you all for the prompt responses. Damn, you guys are good
I have a question, though. What do all of these columns contain? Do they contain just...
--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)

December 14, 2012 at 7:20 pm

#1568861
RE: Retrieving only character result set from varchar column

Lokesh Vij (12/14/2012)
If employeeID does not contain combination of both alphabets and numerals than you can use this also:
SELECT *
FROM employee
WHERE employeeId LIKE '%[A-Z]%'
In the earlier post,...
--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)

December 14, 2012 at 7:19 am

#1568693
RE: Retrieving only character result set from varchar column

farooq.hbs (12/14/2012)
Hi guys,
I have an employee table, in this table there is a column called employeeId(Varchar(5000)).
Now i want only to retrieve the result set of char type
Exapmle
EmployeeId
123
ABC
...
--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)

December 14, 2012 at 7:15 am

#1568688
RE: Maintenance Plan: View History takes long to open

Arthur Kirchner (12/14/2012)
Hmm, maybe that was a misunderstanding: I want to reduce the time it takes to see the History Log of the Maintenance Plan, has nothing to do with...
--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)

December 14, 2012 at 7:09 am

#1568685

Viewing 15 posts - 27,856 through 27,870 (of 59,101 total)