Jeff Moden

Forum Replies Created

Viewing 15 posts - 44,326 through 44,340 (of 59,097 total)

RE: Querying based on a multi-week schedule

Justin,
If that doesn't work out for you, take some time to read the link in my signature line below. A little data goes a long way.
--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)

April 7, 2009 at 12:49 am

#973126
RE: Two different processes have X lock on same resource?

Ummm... it may not be necessary to remove the trigger and there is some great value in having an automated "modified date" or whatever you want to call it. ...
--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)

April 7, 2009 at 12:45 am

#973125
RE: Reference 'Deleted' table: Dynamic SQL

Wow! That's a whole bunch of RBAR. It may work nicely for serveral updates, but if you ever do a large batch update, it's going to take comparatively...
--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)

April 7, 2009 at 12:40 am

#973122
RE: Timestamp to Datetime

Ah... sorry... bad day and I didn't scroll down. I see that folks have already explained that and you agree.
--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)

April 7, 2009 at 12:24 am

#973119
RE: Timestamp to Datetime

javid.alimohideen (4/6/2009)
Actually I am working on some stored procedures that was written by another developer. In my case, the table has a timestamp column, which gets cast to a datetime...
--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)

April 7, 2009 at 12:22 am

#973118
RE: Manners

Jeff Moden (4/6/2009)
Lynn Pettis (4/5/2009)
Well said, both the editorial and the pod cast. From that, I really think that my blog posts are particularly relevant. For those who...
--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)

April 7, 2009 at 12:03 am

#973114
RE: Manners

RBarryYoung (4/6/2009)
majorbloodnock (4/6/2009)
Well, I expect you'll get a lot more posts to this thread agreeing with your article, albeit (frustratingly) all from people who wouldn't commit that cardinal sin 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)

April 6, 2009 at 11:53 pm

#973112
RE: Manners

Lynn Pettis (4/5/2009)
Well said, both the editorial and the pod cast. From that, I really think that my blog posts are particularly relevant. For those who haven't read...
--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)

April 6, 2009 at 11:42 pm

#973109
RE: Convert multiple rows into columns

Actually, I got a blank page on Flo's link... a working link exists in my signature line below. Do yourself a favor and read the article attached to it.
--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)

April 6, 2009 at 11:31 pm

#973105
RE: Convert multiple rows into columns

vishal.chawla (4/6/2009)
Hi All,
Attached is sample data in excel file. I want to display the colored data in column K,L & M as a single row. Please help me.
Thanks,
Vishal
I,...
--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)

April 6, 2009 at 11:29 pm

#973104
RE: Idenity column question /issue

jgrubb (4/6/2009)
By definition, identity has gaps, check BOL. If you need sequential id's without gaps, identity is not the way.
Ummm.... you're gonna have to show 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)

April 6, 2009 at 11:17 pm

#973100
RE: Compare Two Tables

AFIFM (4/6/2009)
I need help with the SQL query to comare two tables in two seperate databases on the same server. The tables have FirstName, LatName and Email as common fields.
I...
--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)

April 6, 2009 at 11:11 pm

#973096
RE: varchar to date derived tables

Op accidently posted in wrong forum. This thread answered in the following post...
http://www.sqlservercentral.com/Forums/Topic691647-169-1.aspx
--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)

April 6, 2009 at 11:06 pm

#973095
RE: varchar to date distinct select

This will likely be slow one way or the other, so you may want to turn it into a function. This seems to catch most
of the aberrations you've...
--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)

April 6, 2009 at 10:57 pm

#973090
RE: How to return a "start of group" column?

Soooo.... does that mean you're happy now?
--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)

April 6, 2009 at 9:52 pm

#973061

Viewing 15 posts - 44,326 through 44,340 (of 59,097 total)