Jeff Moden

Forum Replies Created

Viewing 15 posts - 41,641 through 41,655 (of 59,067 total)

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
RE: The Dynamic Tally or Numbers Table

laughingskeptic (10/4/2009)
Jeff Moden (9/22/2009)
That's nice, but let's see you use that in a join or even as a stand-alone result set.
A table valued function will cover this if you don'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 5:42 am

#1061650
RE: MDX to generate CSV file as Output

So, are you all set or do you still need help on 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 5:34 am

#1061646
RE: How I can make look like I expert on SQL Server?

Marcin Gol [SQL Server MVP] (10/4/2009)
training kits maybe useful for you too
Only if you actually practice what they teach. Otherwise, you're just memorizing which won't get you anywhere 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)

October 4, 2009 at 9:10 am

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

The point Seth was trying to make is that if a column in a table doesn't exist but the table does, you'll get an error. Appologies for not following...
--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 4, 2009 at 8:55 am

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

Garadin (10/2/2009)
These will compile fine if the entire table does not exist. They will not compile if the table exists but the column you're referencing does not. 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)

October 3, 2009 at 9:46 pm

#1061419

Viewing 15 posts - 41,641 through 41,655 (of 59,067 total)