Jeff Moden

Forum Replies Created

Viewing 15 posts - 51,631 through 51,645 (of 59,091 total)

RE: I got burned today at a SQL Server Interview!

Brandie Tarvin (3/19/2008)
Gotta laugh?? Says who?
Why... Larry TCG 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)

March 19, 2008 at 5:40 am

#791379
RE: Syntax error converting datetime from character string.?

Man, you've got me... never saw such a thing.
But, riddle me this... why do you want the derived table when the query works fine without it?
select dt,datediff(dd,'2003-07-01',dt) as...
--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 18, 2008 at 11:15 pm

#791283
RE: Vardecimal

Man, do I ever understand that... there was this one thread that I had made about 7 posts on based on something I thought I knew... one of the guys...
--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 18, 2008 at 10:58 pm

#791281
RE: Select date columns value which are older than 10 days from today?

By the way, you seem to haunt this site a lot.
Heh... can't dance and it's too wet to plow 🙂
Thanks for the awesome compliment, Lynn... lot's of good folks...
--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 18, 2008 at 10:50 pm

#791280
RE: Importing vertical data using the flat file task?

Ok... this is even easier than BCP...
Initial setup...
--===== Create a linked server to the drive and path you desire.
EXEC dbo.sp_AddLinkedServer TxtSvr,
...
--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 18, 2008 at 10:36 pm

#791279
RE: Select date columns value which are older than 10 days from today?

If he cut us off, it's because he's already an "adult"... not sure I'd waste time on a PM... remember what I said...
most adults have already lost theirs so not...
--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 18, 2008 at 10:06 pm

#791277
RE: Computed column

My apologies... I just tried ALTER COLUMN on a computed column and it doesn't work. You'll get an "Incorrect syntax near the keyword 'AS'." You will need to...
--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 18, 2008 at 9:47 pm

#791271
RE: Computed column

... not sure it's a good idea to put hardcoded dates in a computed column, either. Not 100% sure what to replace it with but this might be a...
--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 18, 2008 at 9:42 pm

#791270
RE: Computed column

I haven't tried it on a computed column, but I think you should be able to do an ALTER TABLE/ALTER COLUMN...
--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 18, 2008 at 9:40 pm

#791269
RE: Select date columns value which are older than 10 days from today?

kaiitong (3/18/2008)
Did this topic ask for another of my perspective? No
Do I look like want your concern? NOPE
Did you come to answer my question? No
Why this topic's still active since...
--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 18, 2008 at 9:21 pm

#791263
RE: trigger on a row level

i challenge pointless requirements. i want to know why a requirement exists because i've seen far too many 'requirements' turn out to be unused and unneeded.
I absolutely agree...
--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 18, 2008 at 9:18 pm

#791262
RE: Vardecimal

LOL... Sorry, Matt... I just had this thought of you hanging another bag of coffee... I'm on my third one... 5 gallon bags, mind 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 18, 2008 at 9:01 pm

#791259
RE: Querying the INFORMATION_SCHEMA

Andrew_Webster (3/18/2008)
Top tip for working with the INFORMATION_SCHEMA views: use Excel to view them.
In Excel, go to Data, Import External Data..., then either Import Data or New Database...
--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 18, 2008 at 8:56 pm

#791256
RE: can a varbinary(MAX) be split into multiple varbinary(8000) for compatibility from 2005 to 2000

Yep... I gotta agree with that.
--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 18, 2008 at 8:53 pm

#791254
RE: trigger on a row level

Sergei Zarembo (3/18/2008)
Jeff,
thank you for explaining this. You are a big help as usual. I'll test and get back with results.
Sergei
Thanks, Sergei.
--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 18, 2008 at 8:51 pm

#791253

Viewing 15 posts - 51,631 through 51,645 (of 59,091 total)