Jeff Moden

Forum Replies Created

Viewing 15 posts - 36,391 through 36,405 (of 59,102 total)

RE: T-SQL help needed

Nick123-481228 (10/13/2010)
declare @Prices TABLE (
Id int NOT NULL,
Date smalldatetime NOT NULL,
CreatedDate smalldatetime NOT NULL,
Price float NOT NULL,
Currency int NULL,
LastChangeDate smalldatetime NULL
)
insert @Prices
select 1,'20030101','20090203','9.48',6,'20030101' union all
select 1,'20030102','20090203','9.48',6,'20030102' union all
select 1,'20030103','20090203','9.48',6,null union...
--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 7:17 pm

#1236598
RE: T-SQL help needed

Nick123-481228 (10/13/2010)
declare @Prices TABLE (
Id int NOT NULL,
Date smalldatetime NOT NULL,
CreatedDate smalldatetime NOT NULL,
Price float NOT NULL,
Currency int NULL,
LastChangeDate smalldatetime NULL
)
insert @Prices
select 1,'20030101','20090203','9.48',6,'20030101' union all
select 1,'20030102','20090203','9.48',6,'20030102' union all
select 1,'20030103','20090203','9.48',6,null union...
--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 7:14 pm

#1236597
RE: Are the posted questions getting worse?

Absolutely perfect reply. Mr. Thompson, my hat is off to you again and again. Would you send me a thimble-full of that incredible calm but firm ability-to-deal-with-people 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)

October 13, 2010 at 7:06 pm

#1236596
RE: Subquery returned more than 1 value.

Sahasam (10/12/2010)
Thanks Craig. i am trying to debug into this code from long time.But i am unable to figure it out.Thanks for the info. I will try to debug line...
--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:42 pm

#1236592
RE: Subquery returned more than 1 value.

Brandie Tarvin (10/13/2010)
I am extremely curious what part of "old code" you didn't understand...
Heh... be careful, Brandie. It may not be the OP's code but the code isn't 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)

October 13, 2010 at 6:36 pm

#1236591
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

Viewing 15 posts - 36,391 through 36,405 (of 59,102 total)