Jeff Moden

Forum Replies Created

Viewing 15 posts - 53,986 through 54,000 (of 59,098 total)

RE: Can this be done without cursors?

-- No cursors please
/rockmoose
You must unlearn what You have learnt
Rockmoose! You ol' dog! Where in the heck have you been? How funny... I quoted your...
--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 24, 2007 at 10:10 am

#753770
RE: UK Cultures

Heh... speaking of "tea"... I once had a friend from the UK who thought folks in the US where a bit odd... here's his quote...
"I guess I don't understand Americans......
--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 24, 2007 at 9:22 am

#753762
RE: problem with float data type

I wonder if MS made the mistake of doing the rounding on the new display? What does the code for the problem come up with for an answer 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 24, 2007 at 9:16 am

#753760
RE: problem with float data type

In my book you should be getting 00.0000000000000000000000000000001 which is 1.0E-31. Anything else is a lie.
Yes... I agree... in DECIMAL math, you would be absolutely correct. But FLOAT does...
--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 24, 2007 at 8:51 am

#753755
RE: Insert row by row

No, no... (just making sure)... I said you "could" use a cursor... it wasn't a recommendation. 😀
Perhaps an example of the type of validation I'm talking about is required...
So...
--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 23, 2007 at 10:12 pm

#753730
RE: What is the difference between Programmer and Good Programmer ?

Moreover you are newbie to this site.
Ummmm... that's a bit arrogant on your part... you're a bit of a newbie yourself and, so far, I've not seen you 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)

November 23, 2007 at 10:07 pm

#753729
RE: T-SQL

To add to that... sp_help.
--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 23, 2007 at 10:01 pm

#753728
RE: What is mean by Programming styles?

Yes... pretty much all of that and more... for example, you'll never see me use a While Loop to create a list of contiguous dates... I'll always use a Tally...
--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 23, 2007 at 9:53 pm

#753727
RE: How to write query result in an output file in T-SQL (MSDE)

But when I'v used this method, the result of the select * query was unexploitable like the result can appear in a cmd window.
Sure, I can help... but I 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)

November 23, 2007 at 5:22 pm

#753718
RE: What is mean by Programming styles?

Now, those sound like some pretty strange places... Senior Sybase DBA with 0 days experience... they must have had a death wish. 😉
--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 23, 2007 at 5:19 pm

#753717
RE: Update only changed rows, Insert only new rows

Randy,
There's just a huge number of options because you don't have any triggers. For example, IF you're staging table contained ALL the customers (including ones that are no longer...
--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 23, 2007 at 5:14 pm

#753715
RE: Use GETDATE() within a UDF

Output from a stored procedure does not have a PK Constraint and cannot be indexed unless first materialized as a table. So, it depends...
--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 23, 2007 at 4:32 pm

#753713
RE: INSERTED DUPLICATE RECORDS

Yep... you're right... database sure can't do any of that And, I'm sure that the VB program does it with much more speed...
Everyone does realize that my statement...
--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 23, 2007 at 4:22 pm

#753712
RE: Multi-statement Table_valued Function error

I wish I knew enough about replication to help you out of the pickle you're in...
Thanks for the feedback.
--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 23, 2007 at 4:19 pm

#753711
RE: Query for nth lowest sequence in a group

Then, you're probably going to be ok...
--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 23, 2007 at 4:15 pm

#753710

Viewing 15 posts - 53,986 through 54,000 (of 59,098 total)