Jeff Moden

Forum Replies Created

Viewing 15 posts - 47,656 through 47,670 (of 59,095 total)

RE: Calculating Work Days

Heh... cool! But, you don't really hate RBAR... or you wouldn't be using 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 22, 2008 at 9:33 pm

#888449
RE: Calculating Work Days

Yes... short answer would be to use a calendar table to get the smallest non-holiday, non-weekend date that is >= 15 days out.
--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 22, 2008 at 4:32 pm

#888398
RE: Need help on performance and integrity

I swear I've done this problem on this forum before... :hehe:
Dan, in the GIF file example, please tell me why RowID 10 is NOT considered to be a dupe of...
--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 21, 2008 at 8:28 pm

#887913
RE: SQL Server 2000

Oh yeah... I forgot to mention that, Matt. Thanks for the reminder,
Shifting gears a bit here... What a PITA.... I hate it when they do stuff like that... 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)

October 21, 2008 at 7:02 pm

#887899
RE: user tables and data types

You're welcome and thanks for the feedback. Just to be clear, it's a view... not a table. 🙂
--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 21, 2008 at 6:42 pm

#887894
RE: Query Analyzer sends 'Results to File'

I think it's because you've not identified the database where the table is at in your query. Try using a 3 part name for the table in th Query.
--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 21, 2008 at 6:39 pm

#887893
RE: SQL Server 2000

Dunno if it is... 🙂
--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 21, 2008 at 6:24 pm

#887891
RE: Cannot insert duplicate key row in object 'sysmergeschemachange' with unique index 'schemachangeversion'.

marcos jose (10/18/2008)
... and, why not change to sql server 2000?
Heh... Why not change to 2k5 or 2k8?
--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 21, 2008 at 11:10 am

#887739
RE: Extreme long UPDATE action, advice needed.

FreeHansje (10/21/2008)
Something funny is going on, I have to go deeper into this.
Jeff, the statement is as given in my first post. I get about 13000 1-row-effected messages in 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)

October 21, 2008 at 5:10 am

#887515
RE: Who Wants to Be Rich?

See? What a rich man I am to have such good friends as Barry. We've had more darned fun on these forums.
Thanks for the laugh, Barry. 🙂
--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 20, 2008 at 11:45 pm

#887426
RE: Who Wants to Be Rich?

rbarryyoung (10/20/2008)
Jeff Moden (10/20/2008)
Heh... which definition of "diatribe" do you mean here? 😛
1 archaic : a prolonged discourse
2: a bitter and abusive speech or writing
3: ironic or satirical criticism
... ...
--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 20, 2008 at 11:12 pm

#887419
RE: user tables and data types

tjm (10/20/2008)
Yes. I can see the max_length, but not data_types? Any suggestions?
SELECT * FROM Information_Schema.Columns
--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 20, 2008 at 8:07 pm

#887398
RE: Query Analyzer sends 'Results to File'

Nikhil Shikarkhane (10/20/2008)
I dont know what are you using the file for but you can also use sp_send_dbmail to query output into a flatfile
and have it comma separated cause using...
--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 20, 2008 at 7:26 pm

#887392
RE: SQL Server 2000

Nicely done, Greg. And, if you want the date/time to change no matter which column is updated, just remove the IF...
CREATE TRIGGER tr_your_trigger_name
ON [YourTable]
FOR INSERT,UPDATE
AS
IF @@ROWCOUNT = 0 RETURN
...
--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 20, 2008 at 7:11 pm

#887390
RE: Extreme long UPDATE action, advice needed.

FreeHansje (10/20/2008)
I'm not sure how many actual updates have been done, since I get an update result for each individual update; a guestimate makes me believe there are about 13000...
--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 20, 2008 at 7:04 pm

#887389

Viewing 15 posts - 47,656 through 47,670 (of 59,095 total)