Jeff Moden

Forum Replies Created

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

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
RE: Please need help on looping through the dataset!!!

Garadin (10/31/2008)
3. Read the link in my signature for some tips on how to post data here for future questions. Had I had the information described in 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 6:44 pm

#892637
RE: Passing Parameters as (almost) 1, 2, and 3 Dimensional Arrays

Jorge,
I flattered that you've mimiced the format I use for comments. And, they're pretty much what I would expect to see in a code review.
There are, however, a couple...
--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 5:52 pm

#892633
RE: Passing Parameters as (almost) 1, 2, and 3 Dimensional Arrays

jlcampos71 (10/31/2008)
I'll do that Jeff... but please let me know... where can I found information about it?
Yeaup... start by looking up "temporary tables [SQL Server]" (without the quotes) in Books...
--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 5:29 pm

#892631
RE: Loop through a list of parameters to pass to a sproc

stacik (10/30/2008)
I have a sproc that has two parameters. It lives on a server which I only have remote access to. My manager runs the sproc to process a list...
--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 11:06 am

#892474

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