Jeff Moden

Forum Replies Created

Viewing 15 posts - 30,931 through 30,945 (of 59,101 total)

RE: Sql Query in Case Staement

Yes but you need to encapsulate the SELECT in parenthesis and, as ColdCoffee identified, it must return only 1 value.
--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 1, 2012 at 7:01 pm

#1453965
RE: How to pad a string with spaces when size of data is unknown

The answer has been given multiple times already,
I'm not so sure that's true. It sounds like the OP has unknown length data and wants to size 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 1, 2012 at 6:58 pm

#1453963
RE: KILL

Actually, it sounds like you may have another active SPID that the KILL/ROLLBACK is waiting for. This can sometimes happen with things like dynamic SQL or a call 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 1, 2012 at 6:53 pm

#1453962
RE: Dividing a list of filenames into roughly equal batch sizes in KB

Gah... My apologies for a poor choice of words. :blush: My "you should be thanked" comment wasn't directed you at all. I can't speak for Sean but I...
--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 1, 2012 at 6:45 pm

#1453961
RE: Macro like function in SQL

arpost (3/1/2012)
That's not possible. Every Entry will have an exit.
Heh... so it's not possible that someone could enter an area and the battery on their cell phone gives 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)

March 1, 2012 at 6:25 pm

#1453960
RE: Avoiding a Cursor

😛
--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 1, 2012 at 6:06 pm

#1453959
RE: Avoiding a Cursor

five_ten_fiftyfold (2/29/2012)
I guess sometimes you need to dance with the Devil 🙂
Nah... not for something like this. Cadavre has the right stuff 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 1, 2012 at 3:11 pm

#1453918
RE: Macro like function in SQL

Need a bit more detail on your last request. Is it possible to have an "exit" that doesn't have a matching "entry" or an "entry" that has no matching...
--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 1, 2012 at 3:06 pm

#1453913
RE: Dividing a list of filenames into roughly equal batch sizes in KB

Elliott Whitlow (3/1/2012)
You know I have a different path and think it was mentioned above. Why do we care what process handles a particular file, just that they all...
--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 1, 2012 at 2:59 pm

#1453911
RE: Dividing a list of filenames into roughly equal batch sizes in KB

Sean Lange (2/29/2012)
I too suspected this wasn't going to end up set based because of the nature of the whole thing. I sort of eluded to that in my post...
--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 1, 2012 at 2:49 pm

#1453905
RE: Dividing a list of filenames into roughly equal batch sizes in KB

dembones79 (3/1/2012)
Wow! This is awesome. It'll take me a bit to process this. 🙂 Thanks again for all of the help!
In retrospect, it's actually pretty easy....
--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 1, 2012 at 2:32 pm

#1453890
RE: Avoiding a Cursor

Andy Hyslop (2/29/2012)
Not trying to be picky, but sp_MsForEachTable uses a cursor internally.
Interesting I didn't know this, but now I think about it makes sense I suppose...
Learn something new every...
--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)

February 29, 2012 at 7:09 am

#1453140
RE: Another user's avatar block

Dave Ballantyne (2/29/2012)
anthony.green (2/29/2012)
Sorry guys, it was a bit much, there where a few posts the day I changed to that avatar which made me upload it as I did...
--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)

February 29, 2012 at 5:20 am

#1453081
RE: @Yearmonth ?

olivia.forde (2/29/2012)
What does @Yearmonth -90 mean ?
If @Yearmonth is of the DATETIME datatype, that will subtract 90 days
Also date >=190000
Hard to tell without knowing the datatype but 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)

February 29, 2012 at 5:19 am

#1453079
RE: Need help finding out the space used by the table

Post withdrawn. I posted to the wrong thread.
--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)

February 29, 2012 at 4:50 am

#1453062

Viewing 15 posts - 30,931 through 30,945 (of 59,101 total)