Jeff Moden

Forum Replies Created

Viewing 15 posts - 31,981 through 31,995 (of 59,099 total)

RE: Need nudge with logic to use in dynamic SQL statement to delete duplicate FKs

hxkresl (11/9/2011)
As far as having identified the duplicates, I think Michael Sondergaards sproc works really well for that and I have examined the results. Works good.
You sure about 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)

November 9, 2011 at 3:47 pm

#1405472
RE: how to specify an exact amount of rows to display in a table?

Yep... what I'm trying to figure out is does the OP want a blank row or a row with the number 15 in it or what?
--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)

November 9, 2011 at 10:39 am

#1405381
RE: Unique ID Creation

bpowers (11/9/2011)
Yes. I am trying to create column REPAIR_ID as an identity with a leading "R". My current syntax works, but I would like to do this without creating 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)

November 9, 2011 at 10:37 am

#1405379
RE: Trancender too simple?

I'll tell you what I like to see on CV's... a list of major accomplishments and the words "Google Me". 🙂
--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)

November 9, 2011 at 10:32 am

#1405376
RE: how to specify an exact amount of rows to display in a table?

anthony 80098 (11/9/2011)
Hi Ray,
I know this request is quite strange but i require the data to be displayed on 1 page. I have 2 tables both showing similar data which...
--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)

November 9, 2011 at 9:12 am

#1405296
RE: Unique ID Creation

If you mean as part of the table definition, absolutely. Your syntax for the "computed column definition" seems to be correct. Are you having a problem with creating...
--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)

November 9, 2011 at 9:05 am

#1405290
RE: Error converting data type varchar to numeric- sql 2005

Before you even think of using ISNUMERIC for such a task, please read the following article for why that might not be such a good idea.
http://www.sqlservercentral.com/articles/IsNumeric/71512/
--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)

November 9, 2011 at 8:59 am

#1405285
RE: Trancender too simple?

michael.french 172 (11/9/2011)
Jeff,
My point on memorizing the answers to the questions was that it naturally happened as a result of repeatedly taking the practice tests. However, it was not my...
--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)

November 9, 2011 at 8:44 am

#1405272
RE: Trancender too simple?

Gazareth (11/9/2011)
Don't know what are you're getting at Jeff? My four year degree in Biochemistry has served me well in my career as a DBA 😉
Heh... Sorry... Not enough coffee...
--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)

November 9, 2011 at 8:42 am

#1405270
RE: with format in backup command

I think overwriting backups is a bit dangerous... if the proverbial "lights go out" in the middle of all that, you could lose both backups. My recommendation is to...
--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)

November 9, 2011 at 8:34 am

#1405260
RE: What's !@#!! wrong with my case expression?

Also, you've posted your question on several different forums on this site. A lot of the heavy hitters actually monitor all of the forums via "Questions posted today" 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)

November 9, 2011 at 8:32 am

#1405257
RE: What's !@#!! wrong with my case expression?

@BreakWaterPc,
As you can see, there's some question as to what really needs to be done here. It looks like you want to repalce on those things that end with...
--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)

November 9, 2011 at 8:27 am

#1405249
RE: What's !@#!! wrong with my case expression?

Sean Lange (11/9/2011)
Breakwaterpc (11/9/2011)
I like the non CE option better. The select statement fires off fine, but what do i need to change to make it actually update those...
--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)

November 9, 2011 at 8:15 am

#1405231
RE: how to specify an exact amount of rows to display in a table?

How do i specify that the number of rows that make up the Details for each Group must always be 15 as i sometimes return less data? The details on...
--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)

November 9, 2011 at 7:54 am

#1405203
RE: Trancender too simple?

What I was getting at is that folks work hard for their 4 year degree and they learn a lot of things in the process. That's the whole plan....
--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)

November 9, 2011 at 7:52 am

#1405198

Viewing 15 posts - 31,981 through 31,995 (of 59,099 total)