Jeff Moden

Forum Replies Created

Viewing 15 posts - 36,346 through 36,360 (of 59,067 total)

RE: Finding Sequences (Need help ASAP)

Craig Farrell (10/14/2010)
Paul White NZ (10/14/2010)
It is frequently possible to achieve the desired 'running total' results while breaking one or more QU 'rules', but I think it puts Jeff in...
--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 16, 2010 at 8:10 am

#1238009
RE: Finding Sequences (Need help ASAP)

Craig Farrell (10/14/2010)
Paul White NZ (10/14/2010)
For 2005 onward, consider adding the 'safety code' I mentioned - you can find it here: http://www.sqlservercentral.com/Forums/FindPost980118.aspx
Well, far be it from me to turn down...
--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 16, 2010 at 7:52 am

#1238007
RE: Sending multiple rows to the Database from an Application: Part I

As yet another alternative... use with your favorite splitter...
http://www.sqlservercentral.com/articles/T-SQL/63003/
I also recommend NOT using a recurrsive CTE for such a thing because it's just too slow.
--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 15, 2010 at 12:06 pm

#1237769
RE: Finding Sequences (Need help ASAP)

rishabh.upkr (10/14/2010)
Your range is static
means %%%%%%%%%%0001-%%%%%%%%%%003
or it will change on some condition
Can you explain what your talking about just a bit more?
--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 15, 2010 at 5:11 am

#1237429
RE: Need Records other than month end dates from a table

R.P.Rozema (10/14/2010)
(tnx Jeff)
You bet. Thanks for the feedback and thanks for the code to play with. It's always nice to see when folks gen more than 10 rows...
--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 14, 2010 at 11:17 pm

#1237304
RE: I want to create primary key after inserting foreign key.

aspardeshi (10/14/2010)
Hello Professionals,
I have a typical scenario. I have a table for students. When I enter username required for parents in student master the parent master table needs to be...
--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 14, 2010 at 10:53 pm

#1237296
RE: Arranging table output

SKYBVI (10/14/2010)
@ gail
Ya, i noticed that there was no use, as the rows were not according to that..(order by) in the new table..
I had to delete 1-2 columns( as per...
--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 14, 2010 at 3:52 pm

#1237245
RE: Finding Sequences (Need help ASAP)

Very cool, Joe. I'm thinking that you didn't test it...
[font="Courier New"]Msg 207, Level 16, State 1, Line 18
Invalid column name 'part_id'.
Msg 245, Level 16, State 1, Line 2
Conversion failed...
--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 8:03 pm

#1236602
RE: Learning Oracle

ta.bu.shi.da.yu (9/17/2010)
2. Oracle has implemented more of the SQL standard that Microsoft. Case in point: try doing a lag, lead, or top analytic function in SQL Server... you can't! You...
--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:38 pm

#1236600
RE: Upgrading from 2000 to 2008 performance issue

reggie burns-317942 (10/13/2010)
I removed the Loop hint and it seem to make the performance worse than what it was before the move.
It degraded tremendously with the loop hint removed.
Did...
--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:21 pm

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

Viewing 15 posts - 36,346 through 36,360 (of 59,067 total)