Jeff Moden

Forum Replies Created

Viewing 15 posts - 52,156 through 52,170 (of 59,091 total)

RE: Varchar(max) problem in SQL server 2005

The length of the number of characters plus 6 or 8 bytes worth of length info.
Question is, why are you using VARCHAR(MAX) if it'll never get bigger than a thousand...
--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)

March 4, 2008 at 7:10 pm

#785276
RE: small issue

Heh... And the GUI rules... it may take longer and it may run slower, but the GUI rules.
Bill Gates was right 15 years ago... someday there won't be any...
--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)

March 4, 2008 at 6:50 pm

#785273
RE: Timetable report

spencepa (3/4/2008)
Matrix seems to work but if a student has a 15 min tutorial, this fills a whole column the same as a hour
What do you want it to do?
--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)

March 4, 2008 at 5:18 pm

#785265
RE: Selecting random rows

Based on that link, I'm thinking this is someone's homework... wait a minute... I've got a porkchop around here somewhere... maybe even a Yak Burger, huh, Peter?
--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)

March 4, 2008 at 4:54 pm

#785263
RE: What is a Cursor?

Only if you promise to avoid cursors and while loops like they were going to kill you... because they'll certainly kill the performance of your code. There's almost always...
--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)

March 4, 2008 at 4:50 pm

#785262
RE: Selecting random rows

I sure do... read the URL in my signature. People will come screaming out of the woodwork to answer your question almost before you can ask it if 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)

March 4, 2008 at 4:30 pm

#785258
RE: Calculating Agregate value based on select statements from different tables

Welcome aboard... first, here's one answer two your problem...
SELECT
(
SELECT SUM(ROOMREVENUE) AS 'ROOM REVENUE' FROM RPT_HOTEL_STATS WHERE PROPERTY = 'DELSOL'
AND STAT_DATE > '2007-12-31 00:00:00.000'
AND STAT_DATE <= DATEDIFF(day, 0, getdate())
)
/
(
select SUM(NUMROOMS) FROM...
--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)

March 4, 2008 at 4:25 pm

#785257
RE: Assigning value to variable. Another attempt.

willyboy (3/4/2008)
It is just not updating the JobSteps table.
How do you know that? What if it's updating the table with the same stuff that you have in it (NULLS?)...
--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)

March 4, 2008 at 4:19 pm

#785255
RE: Assigning value to variable. Another attempt.

willyboy (3/4/2008)
It would not surprise me if someone wanted to reach through the internet and throttle me.
Depends... do ya like porkchops? 🙂
--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)

March 4, 2008 at 4:12 pm

#785251
RE: to use break and continue

Guess I should be pretty happy then... apparently some of my articles inspire people to ask questions. 🙂
--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)

March 4, 2008 at 4:01 pm

#785248
RE: INSERT INTO Statement Error

Ok, no... you have to use NEWID() to populate the column. It is NOT a self populating column. Then, you would check for an error... if no error,...
--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)

March 4, 2008 at 3:41 pm

#785239
RE: How to lay out SQL Code

Heh... no,... I'll happily continue to be "wrong" on this one... 😉
--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)

March 4, 2008 at 3:29 pm

#785237
RE: dbcc inputbuffer question

Adam Bean (3/4/2008)
haha! That's my view!!! I feel special ...
http://www.sqlservercentral.com/Forums/Topic457115-146-1.aspx
Dang, Adam... why don't you put your name on that bad boy! 😉
--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)

March 4, 2008 at 3:06 pm

#785229
RE: small issue

Hmmm.... when it comes to plain ol' delimited text files such as CSV files, I sometimes think people make things way too difficult. You can easily get a listing...
--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)

March 4, 2008 at 2:35 pm

#785220
RE: INSERT INTO Statement Error

Remove the semi-colon... change the double quotes to single quotes around 'James'.
--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)

March 4, 2008 at 1:26 pm

#785189

Viewing 15 posts - 52,156 through 52,170 (of 59,091 total)