Jeff Moden

Forum Replies Created

Viewing 15 posts - 45,376 through 45,390 (of 59,095 total)

RE: count of consecutive value

dubem1 (1/31/2009)
Hi Jeff
I am glad you had fun with the article. I am surely not at this level!
I cannot give you a lot more information on the purpose 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)

January 31, 2009 at 8:20 pm

#936085
RE: insert records into another table.

sandy (1/30/2009)
Yes it is neccessary to insert into another table because based on that many more further processes & calculation will be done and i will be using into my...
--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)

January 31, 2009 at 8:09 pm

#936084
RE: insert records into another table.

Vladan, check your code... I don't believe it's coming up with the correct result set. 😉
--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)

January 31, 2009 at 7:47 pm

#936080
RE: procedure

You can use a While loop if you want... but I wouldn't... 😉 See the following...
http://www.sqlservercentral.com/articles/T-SQL/63003/
--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)

January 31, 2009 at 7:11 pm

#936077
RE: Rolling Back Strategy

ammarghanem921 (1/31/2009)
Hi all
I do have One stored procedure that calls other stored procedures, each on which might call another stored procedure. However, am making begin transaction, commit transaction 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)

January 31, 2009 at 7:06 pm

#936075
RE: Using trim with Join

Isn't there something missing from that JOIN? Like a table or somthing and an equation?
--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)

January 31, 2009 at 7:02 pm

#936073
RE: count of consecutive value

RBarryYoung (1/31/2009)
Heh. You know Jeff, I think that this might change that article that you're writing, just a little bit. I bet you don't mind too much though....
--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)

January 31, 2009 at 6:58 pm

#936072
RE: Trouble with variables and function

Jeff Moden (1/31/2009)
RBarryYoung (1/31/2009)
For Stephen or anybody else who may be interested, here is a previous thread where Jeff, andrewd.smith, myself and others discuss the finer points of Latitude/Longitude calculations...
--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)

January 31, 2009 at 6:54 pm

#936071
RE: Trouble with variables and function

RBarryYoung (1/31/2009)
For Stephen or anybody else who may be interested, here is a previous thread where Jeff, andrewd.smith, myself and others discuss the finer points of Latitude/Longitude calculations and searchs...
--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)

January 31, 2009 at 6:53 pm

#936070
RE: Guest Editorial: And Now; a Recitation

On that note, all I can do
is raise my mug into the air
and say "3 cheers to SSC"
and to all of those that care! 😀
--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)

January 31, 2009 at 6:49 pm

#936069
RE: Celebrating A Million

I ran into an interesting article... glad to see that "big money" hasn't changed Steve a bit since then except that he continues to just keep making it better 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)

January 31, 2009 at 6:42 pm

#936067
RE: Undocumented Routines: Forbidden fruit.

Heh... "Don't use undocumented features"... as opposed to what? Using just the documented ones? You mean like the wonderful and heavily documented sp_MakeWebTask whose required privs changed overnight...
--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)

January 31, 2009 at 6:36 pm

#936066
RE: Top 1 or Max??

It depends on whether or not you believe in the myth of portable code. TOP is an SQL Server manifestation.
Other than that, "best", in my book, is the one...
--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)

January 31, 2009 at 5:50 pm

#936060
RE: Trouble with variables and function

Heh... Barry graduated from the school of "Right Now" and teaches from the good book of "Boy Howdy!" 😛
--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)

January 31, 2009 at 5:39 pm

#936056
RE: GROUPING only if EXISTS

Dyamond (1/31/2009)
Hello, I'm trying to keep together/group on the following:
SELECT date,name,desc,‘Code’ as cdDesc
FROM activity
WHERE date = ‘2009-01-05' and site = ‘80' and
code in (’55544',’33333', ‘66666')
I'm a bit thick on...
--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)

January 31, 2009 at 5:27 pm

#936053

Viewing 15 posts - 45,376 through 45,390 (of 59,095 total)