Jeff Moden

Forum Replies Created

Viewing 15 posts - 38,116 through 38,130 (of 59,098 total)

RE: Common Table Expressions overuse

Ion Freeman (6/1/2010)
I'm seeing a lot of code like
; with EMP_CTE(EMPID, NAME) AS (SELECT EMPID, NAME FROM EMPLOYEE WHERE STARTDATE > '4/25/1968')
SELECT EMPID, NAME FROM EMP_CTE WHERE MGRID =...
--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)

June 2, 2010 at 7:51 am

#1175290
RE: update statement with concatenation

WayneS (6/1/2010)
_taz_ (6/1/2010)
yes I need to store it seperate for now.
I have never done an update with a calculation. just simple
update table
set columnx=y
where columnz = null
type of stuff
thanks
First,...
--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)

June 2, 2010 at 7:47 am

#1175285
RE: Best Practice? Shopping Cart Table data

bkirk (6/1/2010)
I'm developing the architecture for a ASP.NET website with a shopping cart SQL table for storing products, quantities, etc... when a person clicks the 'add to cart' button.
I have...
--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)

June 2, 2010 at 7:42 am

#1175283
RE: How to replace the cursor

Very cool feedback, Nagesh. Thank you for taking the time.
--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)

June 2, 2010 at 7:36 am

#1175277
RE: stored procedure search condtion between two dates

naveena 78933 (6/2/2010)
SELECT id,Name, salary FROM Emp
WHERE fromdate >= '1-1-82' AND today <= '12-31-06'
Ummm... no... don't use two digit years and don't use the mm-dd-yy format for such things...
--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)

June 2, 2010 at 7:30 am

#1175271
RE: ADD column storeID while bulk inserting

daniarchitect (6/2/2010)
Jeff,
FInally it works!!!!!!!!!!!!
Thanks so much,have removed the character encoding,and changed the rowdelimiter........it actually imported 98 of 144 files and I think the rest requires some data clean up.
Be blessed!
Very...
--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)

June 2, 2010 at 5:20 am

#1175210
RE: Missing numbers in a series

Paul White NZ (6/2/2010)
j-1064772 (6/1/2010)
I missed that one. Could you please provide the URL ?
Sure can:
http://www.sqlservercentral.com/Forums/Topic896583-338-1.aspx
Ohhh! That! I didn't realize he'd quoted you, Paul.
Yeah... that was pretty cool.
--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)

June 2, 2010 at 5:16 am

#1175207
RE: ADD column storeID while bulk inserting

Ummm... ok.... where's the code that does the actual work of importing?
--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)

June 2, 2010 at 12:17 am

#1175115
RE: How to replace the cursor

WayneS (6/1/2010)
Nagesh S-432384 (5/31/2010)
I 100% agree with you Jeff, my solution was for limited number of records not for huge data.
Nag
How many times have you been told that some code...
--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)

June 2, 2010 at 12:01 am

#1175109
RE: ADD column storeID while bulk inserting

lmu92 (6/1/2010)
daniarchitect (6/1/2010)
Hey Jeff,
I have been trying it the whole night yesterday and all the day today.. and it didn't work out.. (it goes well till some point 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)

June 1, 2010 at 6:19 pm

#1175053
RE: Collapsing a Table

WayneS (6/1/2010)
Jeff Moden (5/31/2010)
WayneS (5/31/2010)
This post is just to include an alternate method. I haven't tested the various methods, but I believe that the "Quirky Update" solution that Jeff presented...
--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)

June 1, 2010 at 12:22 pm

#1174960
RE: Missing numbers in a series

j-1064772 (6/1/2010)
Paul White NZ (5/5/2010)
Jeff Moden (5/5/2010)
Doesn't this remind you of the 'triangular join' I surprised you with a few weeks back? The one with the computed column CASE...
--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)

June 1, 2010 at 12:09 pm

#1174952
RE: Auto Increment Alphabet

The lack of feedback on this post has me worried that the OP is actually using the alphabetic increment in the unfiltered mode. Please save your company a lawsuit...
--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)

June 1, 2010 at 9:12 am

#1174835
RE: How to replace the cursor

Nagesh S-432384 (5/31/2010)
changbluesky (5/31/2010)
please take a look at the below SQL CODE
---
create table mytable
(
potype varchar(10)
)
insert into mytable values
('AA'),
('BB'),
('CC')
declare @potypestring varchar(50)=''
declare @potype varchar(10)
declare mytype cursor local for
select potype from mytable
open mytype
fetch...
--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)

May 31, 2010 at 8:49 pm

#1174620
RE: Collapsing a Table

Well I'll be dipped. I guess I'm glad I didn't think of the "Difference between two row numbers" trick here. Without changing the number of rows in 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)

May 31, 2010 at 8:22 pm

#1174619

Viewing 15 posts - 38,116 through 38,130 (of 59,098 total)