Jeff Moden

Forum Replies Created

Viewing 15 posts - 41,671 through 41,685 (of 59,102 total)

RE: Comma separated Value

I still want to know why the OP wants to do this type of denormalization, though...
--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 5, 2009 at 8:14 am

#1061748
RE: master..xp_cmdshell works. But Exec master..xp_cmdshell doesn't work

But if i remote login to the server, it works
I'm pretty sure that's the nature of the beast and you won't be able to do much about that. This...
--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 5, 2009 at 8:05 am

#1061741
RE: Comma separated Value

I'm glad that someone else realizes how comparatively slow COALESCE is compared to ISNULL or a preset empty string.
However, my real question to the OP is (drum roll, please)... why...
--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 5, 2009 at 7:59 am

#1061734
RE: The multi-part identifier could not be bound

"Must look eye"...
ON WIP_DTL_HIST.DATE_WRK =DAILY_SCRAP.SFT_DATE
AND WIP_DTL_HIST.PAYROLL_SFT_WRK=DAILY_SCRAP.SFT_NUM
AND WIP_DTL_HIST.PART_NUM=DAILY_[highlight]SCARP[/highlight].PART_NUM
AND WIP_DTL_HIST.WKC=DAILY_SCRAP.WC_NUM
--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 5, 2009 at 7:50 am

#1061723
RE: Dictionary Table

I don't believe that you'll find anything about indexes or columns or a couple of other things in SysObjects. Even the sys.All_Objects in Master doesn't contain everything.
--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 5, 2009 at 7:27 am

#1061703
RE: ROUND() function doesn't round properly

Hmmmm.... something must be wrong on my end. It keeps giving me a 404 error.
Q & A's are sometimes pretty rich in information like the little date jewel you...
--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 5, 2009 at 7:08 am

#1061694
RE: SQL Server 2000 Related Query

Sorry... lost track of this thread.
Yes, changing the clustered index would do the trick. Now you know why I was asking all the questions about what "order" these 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)

October 5, 2009 at 7:04 am

#1061688
RE: How to skip checking the existence of objects when creating Stored Procedure

Nothing like a little coffee in the garden. 🙂
Everytime I've seen such a post, it's because the OP is trying to add columns to a table for something like "month"...
--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 5, 2009 at 6:51 am

#1061680
RE: SQL Server 2000 4000 character query limit for adhoc queries

Matt Whitfield (10/4/2009)
Jeff Moden (10/3/2009)
Most people don't know about it, but you can also create temporary stored procedures that begin with #.
A dark hand waves in the mist...
'Your SQL skill...
--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 5, 2009 at 6:42 am

#1061673
RE: SQL Server 2000 4000 character query limit for adhoc queries

alex_pangcats (10/4/2009)
Hi Gardin,
Thanks for the reply.
Your answer is nice, but I think it's more complicated and messy.
As I mentioned the value recieved by the parameter is dynamic so we can't...
--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 5, 2009 at 6:41 am

#1061671
RE: Are the posted questions getting worse?

bitbucket-25253 (10/3/2009)
Jeff
Ron, you've made my day! I thought I was the only cranky ol' fart
Jeff your a young wipper snapper ... heck I have a son older than you!
Heh......
--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 5, 2009 at 6:28 am

#1061664
RE: Generation X

Crud... there goes the neighborhood. Can we leave religion out of this, please?
--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 5, 2009 at 6:23 am

#1061662
RE: how to store large files in sqlserver 2008

Just to be clear, the suggestion I made was for pre-2k8 solutions. Pass the file path/name from the database to the app and let the app get the file.
--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 5, 2009 at 6:03 am

#1061654
RE: ROUND() function doesn't round properly

Shoot... the link is broken. Thanks anyway, Dave.
--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 5, 2009 at 5:58 am

#1061652
RE: Finding Bad Data in CSV Import

Thanks for the feedback, Max.
--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 5, 2009 at 5:53 am

#1061651

Viewing 15 posts - 41,671 through 41,685 (of 59,102 total)