Jeff Moden

Forum Replies Created

Viewing 15 posts - 39,241 through 39,255 (of 59,098 total)

RE: Does a development DBA need to learn dot.net language. ?

DonaldW (3/22/2010)
Jeff Moden (3/21/2010)
I guess I'm the oddball. I've totally removed myself from such languages and have concentrated on T-SQL. Sounds stupid, I know, but when folks hire...
--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 22, 2010 at 6:44 am

#1137543
RE: Representing a hierarchy from comma separated values

Thanks for posting the solution. I apologize... for some reason I wasn't getting the fact that you were trying to create the Adjacency Set from the Hierarchical Path. ...
--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 22, 2010 at 5:47 am

#1137509
RE: Selecting list of month numbers between two dates

Thanks for the feedback, sivakumar.
--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 21, 2010 at 10:24 pm

#1137407
RE: DateTime input with time always at 00:00:00.0000

Agreed on the FLOAT conversion. Bad thing to do for the future.
Same goes with the CONVERT not because it's a bad thing for the future but because...
--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 21, 2010 at 10:20 pm

#1137405
RE: How to transform table with few rows to one row?

Jagger-784276 (3/21/2010)
Hi,
I am beginner.Just an example. If I have table with 3 rows and 3 columns:
customer number notes last visit...
--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 21, 2010 at 10:00 pm

#1137403
RE: Dyamic SQL Cursor is not working in SQL 2008

lmu92 (3/21/2010)
Sounds like "fun" to write software in an unknown language...
Heh... I've found that a lot of people who write T-SQL are actually writing in an unknown language. 😛
--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 21, 2010 at 9:59 pm

#1137402
RE: compare dates

lmu92 (3/21/2010)
Hi Prakash,
either the column names you provided is wrong or you're using the wrong column (PId=31).
Other than that I guess you want to find the rows where your parameters...
--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 21, 2010 at 9:53 pm

#1137400
RE: Does a development DBA need to learn dot.net language. ?

I guess I'm the oddball. I've totally removed myself from such languages and have concentrated on T-SQL. Sounds stupid, I know, but when folks hire me, they're hiring...
--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 21, 2010 at 9:36 pm

#1137397
RE: Ensure Unique Value Across Records

SwePeso (3/21/2010)
david.c.holley (3/19/2010)
Is there a way to do this AND allow Nulls? In other words, the when the WindowsUserId is provided, it must be unique, but it may not exist...
--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 21, 2010 at 9:17 pm

#1137395
RE: Selecting list of month numbers between two dates

BTW... you should never find the last day of the month because you may miss all but the first instant of that last day all together. Instead, you should...
--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 21, 2010 at 9:15 pm

#1137394
RE: Selecting list of month numbers between two dates

sivakumar.ss (3/20/2010)
Hi jeff,
xlnt solution.......
One doubt !
My requirement is like that instead of start date of every month [01/04/2007], i required end date of every month [31/04/2007]
bcoz no. of days...
--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 21, 2010 at 9:12 pm

#1137393
RE: Representing a hierarchy from comma separated values

Patrick Dadey (3/20/2010)
I think my problem is a bit different
than the solution you provided in that the id of the parent
for the child in #tree is not known
Maybe...
--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 21, 2010 at 8:56 pm

#1137392
RE: Calculate columns by adding the result of other coulmns on the fly

dibbydibby (3/19/2010)
Sorry bout the wrong section! I have found that some sections on the forums would be better as a generic section. I.e Replication and TSQL. Some sections have more...
--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, 2010 at 8:36 am

#1136774
RE: Calculate columns by adding the result of other coulmns on the fly

Very cool. Thanks for the feedback.
Yep... since you have 2k5 or better (didn't know that because this is a 2k forum), a CTE does make it 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 19, 2010 at 8:26 am

#1136760
RE: Finding Training

jcrawf02 (3/19/2010)
(fyi, these are all general 'you', I know that Jeff is not saying he is doing this)
Heh... Correct... I should have mentioned that. I can just imagine the...
--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, 2010 at 8:12 am

#1136744

Viewing 15 posts - 39,241 through 39,255 (of 59,098 total)