Jeff Moden

Forum Replies Created

Viewing 15 posts - 46,651 through 46,665 (of 59,101 total)

RE: Updating a Column Using a Recursive Definition

bkmooney (12/12/2008)
Jeff,
I'm attaching the file with the formatted test data. It should generate about 150 rows of data for you. And because it makes things more interesting...
--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 12, 2008 at 6:54 pm

#911983
RE: Updating a Column Using a Recursive Definition

smunson (12/12/2008)
Looks like Peso nailed the concept for using the "quirky update" to get at the data,...
Ya know what? I missed Peso's post... that's just about where I'm going...
--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 12, 2008 at 6:36 pm

#911981
RE: Are the posted questions getting worse?

Easy big boy... these are not the droids you want... 😛
--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 12, 2008 at 6:25 pm

#911978
RE: Outsourcing is the best idea ???

Heh... told ya I'd be pretty much alone in what I said...
Perhaps some clarification on what I mean by "outsourcing" is necessary... buying and having someone install/interface a well known...
--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 12, 2008 at 6:23 pm

#911977
RE: Outsourcing is the best idea ???

I guess I'll be the only one with a rock solid opinion on this one...
Outsourcing is absolutely the worst idea at all times. The people writing code to solve...
--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 12, 2008 at 11:36 am

#911842
RE: script to get all tables an sizes

rbarryyoung (12/12/2008)
This should do it. You can use it either as a query or a View: http://www.sqlservercentral.com/scripts/tables/62545/
Heh... dammit... now I'll never get the answer to my 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)

December 12, 2008 at 11:24 am

#911831
RE: script to get all tables an sizes

neneco56 (12/12/2008)
I cannot use cursor or loop or create table, I need a simple script to do the job,any ideas?
Trade ya... tell me why you cannot use a cursor or...
--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 12, 2008 at 11:23 am

#911828
RE: Wacko SMTP email with ActiveX

Bugger... now all I have to do is figure out why the ActiveX script on both servers work but the equivalent sp_OA based sproc doesn't work on one of the...
--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 12, 2008 at 7:41 am

#911645
RE: Urgent: Need help with Query on Group By Part

Well, right you are! So, instead of talking and talking and talking, show Shubhra how to do that with the original code posted instead of just making casual suggestions....
--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 12, 2008 at 12:19 am

#911482
RE: Which is better

Heh... dammit... I hate tabs. 😛 Thanks, Christopher.
--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 12, 2008 at 12:04 am

#911478
RE: Selecting numbers up to the first non-numeric char from a string

engintoksoz (12/11/2008)
... and learned how to use patindex.
As a sidebar, what's the first thing you do when you buy a new car? You find out how to operate...
--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 11, 2008 at 11:59 pm

#911477
RE: Generating automatic sequential alphanumeric key

vbugarsk (12/11/2008)
Thanks guys for answers.
I am fully aware of possible problems:
1. Overruns will never happen, meaning that client will never have more then 200 orders per year. If it will...
--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 11, 2008 at 11:59 pm

#911476
RE: CLR vs Dynamic SQL?

The scope of a temporary stored proc is a bit different than that of a temp table... if you create a temp stored proc using dynamic SQL, it IS callable...
--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 11, 2008 at 11:43 pm

#911472
RE: CLR vs Dynamic SQL?

Heh... no, no... I wasn't trying to be sarcastic or smug in any way. From BOL...
[font="Arial Black"]Arguments[/font]
procedure_name
Is the name of the new stored procedure. Procedure names must conform 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)

December 11, 2008 at 11:27 pm

#911470
RE: Selecting numbers up to the first non-numeric char from a string

Ok... here it is... first, we need to make a UDF from Matt's code to drive a point home later...
CREATE FUNCTION dbo.MillerCode
(
@STR...
--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 11, 2008 at 10:25 pm

#911458

Viewing 15 posts - 46,651 through 46,665 (of 59,101 total)