Jeff Moden

Forum Replies Created

Viewing 15 posts - 36,361 through 36,375 (of 59,067 total)

RE: Subquery returned more than 1 value.

CELKO (10/13/2010)
[font="Arial Black"]Your tables have singular names[/font], to show that you think they are files, not sets.
....
Should have been:
UPDATE Foobar
SET ..
WHERE Foobar.id = @id
...
--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)

October 13, 2010 at 6:10 pm

#1236584
RE: Are the posted questions getting worse?

Steve Jones - SSC Editor (10/12/2010)
jcrawf02 (10/12/2010)
At the risk of encountering a porcine missile, have you ever heard of earplugs? 😀
I have found that single rooms are the best earplugs...
--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)

October 12, 2010 at 5:27 pm

#1235937
RE: Are the posted questions getting worse?

jcrawf02 (10/12/2010)
Jeff Moden (10/12/2010)
WayneS (10/11/2010)
Jeff Moden (10/10/2010)
WayneS (10/10/2010)
Hey gang... not definite yet, but my wife is talking about letting me spend the $ to go to PASS. 😀
Any suggestions 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)

October 12, 2010 at 5:19 pm

#1235935
RE: csv string

mail4sha (10/11/2010)
yes ofcourse..... Perfect guidance... thanks jeff
You bet. 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)

October 12, 2010 at 7:14 am

#1235494
RE: Columns to rows

The Dixie Flatline (10/11/2010)
It not only reads easier, it should be child's play to generate dynamically as well.
Jeff, you should check out this thread. It's about a year...
--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)

October 12, 2010 at 7:10 am

#1235490
RE: Are the posted questions getting worse?

GilaMonster (10/12/2010)
Paul White NZ (10/12/2010)
GilaMonster (10/11/2010)
This site was somewhere between terrifying and hilarious - http://www.allinterview.com/showanswers/65496.html
Terrifying. Maybe I will experience some of the humour later, but for now, I'm 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)

October 12, 2010 at 6:46 am

#1235463
RE: Are the posted questions getting worse?

WayneS (10/11/2010)
Jeff Moden (10/10/2010)
WayneS (10/10/2010)
Hey gang... not definite yet, but my wife is talking about letting me spend the $ to go to PASS. 😀
Any suggestions on good, inexpensive, close...
--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)

October 12, 2010 at 6:44 am

#1235461
RE: Oracle empty string ('') is the same as NULL

... and, no, there is no setting that I know of that will make it otherwise.
--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)

October 11, 2010 at 10:09 am

#1235101
RE: Extract csv values with multiple rows?

Please see the following to do what you need...
http://www.sqlservercentral.com/articles/T-SQL/63003/
The embedded comma that you have will cause a bit of frustration on your part but I'm sure you'll be able 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)

October 11, 2010 at 5:37 am

#1234906
RE: Membership Span

Actually, check out today's article...
http://www.sqlservercentral.com/articles/CTE/71169/
--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)

October 11, 2010 at 5:24 am

#1234903
RE: project

kanika.bhagat (10/11/2010)
defination for the table student is given below:
create table "student"
(
"rollno" varchar2(4000),
"class" varchar2(4000),
"sem" varchar2(4000),
"sub" varchar2(4000),
"mtt1" number,
"mtt2" number,
"external" number,
"tot" number,
)
output will be like
if we insert values in all the fields...
--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)

October 11, 2010 at 4:41 am

#1234879
RE: csv string

mail4sha (10/11/2010)
http://www.sqlservercentral.com/articles/T-SQL/62867/... i got ur article jeff 🙂
So you're all set then?
--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)

October 11, 2010 at 4:30 am

#1234873
RE: Query to get a running total for each row?

A word of caution. These solutions are all "Triangular Joins". What are those? Well, a full up CROSS JOIN is also known as a "SQUARE JOIN" so...
--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)

October 10, 2010 at 11:34 pm

#1234787
RE: Columns to rows

The Dixie Flatline (10/5/2010)
Here we go, Jeff:
It is the CROSSTAB of UNPIVOTS
Is this what we're looking for?
declare @sample table (ID int identity(1,1), Column1 varchar(10), column2 varchar(10), column3 varchar(10))
insert into @sample...
--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)

October 10, 2010 at 11:01 pm

#1234782
RE: Columns to rows

The Dixie Flatline (10/5/2010)
Here we go, Jeff:
It is the CROSSTAB of UNPIVOTS
Is this what we're looking for?
declare @sample table (ID int identity(1,1), Column1 varchar(10), column2 varchar(10), column3 varchar(10))
insert into @sample...
--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)

October 10, 2010 at 10:53 pm

#1234781

Viewing 15 posts - 36,361 through 36,375 (of 59,067 total)