Jeff Moden

Forum Replies Created

Viewing 15 posts - 47,491 through 47,505 (of 59,099 total)

RE: Implement Data integrity

Muralidharan Venkatraman (10/31/2008)
:(I have a production application which holds 100+ tables which does not have primary keys at all and running in sql server 2005. I inherited this application 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)

October 31, 2008 at 9:02 pm

#892664
RE: Is a Recursive Query what I need?

Nicely done! And thanks for the feedback especially on the performance/durations.
My only concern is the BEGIN/COMMITs you have for Stages 1 through 4... the [CPMTEST].[XJASN4N].[tblCLS_OFSA] is a...
--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 31, 2008 at 8:50 pm

#892663
RE: varchar error

ry.rith (10/31/2008)
Thank so much,
that you tell me about the solution.
I also do the same of yours to complete the crosstab-report, but something that i want is to know why it's...
--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 31, 2008 at 8:22 pm

#892658
RE: SQL Cursor problem

Heh... I've just gotta agree with 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 31, 2008 at 8:05 pm

#892656
RE: compressing / collapsing numbers

juergen.kessler (10/31/2008)
@Seth: Sorry Seth, will follow you next time.
If you do it this time, you'll actually get a tested answer... 😉
--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 31, 2008 at 7:57 pm

#892652
RE: Query data with manipulation

jack_hc (10/30/2008)
Hi,
I am facing a problem to extract data from a table, the table contains over 41k records, and some of them(>5k) share same column value, now what i am...
--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 31, 2008 at 7:45 pm

#892650
RE: Update Trigger questions / multiple rows in "inserted" table

Mark Rissmann (1/30/2007)
IF UPDATE(VendorCode)
BEGIN
UPDATE vendor SET vendorcode=inserted.vendorcode
FROM inserted JOIN deleted ON inserted.vendorID=deleted.vendorID
WHERE (inserted.vendorcode <> deleted.vendorcode) AND (inserted.iscopy=0) AND (inserted.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 31, 2008 at 7:37 pm

#892649
RE: CPU usage 100%

Search the web for "CDONTS"
--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 31, 2008 at 7:35 pm

#892648
RE: custom start day of week

It's a good thing to have, anyway... make a Calendar table based on the user inputs.
--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 31, 2008 at 7:25 pm

#892646
RE: Merging duplicate rows

sam (10/31/2008)
How can I merge the rows with the duplicate or common custnumbers, amounts and semesters?
e.g. row 4 and 5 have a common custnumber, amount and semester so i want...
--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 31, 2008 at 7:18 pm

#892644
RE: compacting a numbered list

dlongnecker (10/31/2008)
Hey everyone,
I've got a table with a column of ints and I need to remove any discontinuity between them...
Although PW's post is spot on, I suspect there's a bigger...
--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 31, 2008 at 7:09 pm

#892643
RE: Clr Trigger for Insert

anupamabr (10/31/2008)
thanks for your quick response ..eventhogh i changed the code it didnt work
Do you mean that you changed it to T-SQL?
--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 31, 2008 at 7:07 pm

#892642
RE: Need help generating a unique two letter alpha code for set based insert

dbaInTraining (10/31/2008)
I probably should have explained the reasoning behind the codes. This is for inventory part numbers and the table stores options that all parts can have. 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)

October 31, 2008 at 6:58 pm

#892640
RE: Need help generating a unique two letter alpha code for set based insert

john.steinbeck (10/31/2008)
I'm a bit confused, but check out my post I just posted and my other post, "Recursive"; I think that may be what you want...
Please post the correct URL.
--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 31, 2008 at 6:57 pm

#892639
RE: T-SQL Code Optimizers

clive (10/31/2008)
What is the preferred option, with(nolock) or with(readpast).
What is the preferred option, if exists or if @@rowcount.
What is the preferred option, temporary table or derived table.
What is the preferred...
--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 31, 2008 at 6:48 pm

#892638

Viewing 15 posts - 47,491 through 47,505 (of 59,099 total)