Jeff Moden

Forum Replies Created

Viewing 15 posts - 33,181 through 33,195 (of 59,099 total)

RE: Bulk Insert Modifies Imported Character

CodePage = 'RAW' simply supresses any codepage conversions. There's more information in Books Online on the subject under "BULK INSERT".
--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)

July 21, 2011 at 8:01 pm

#1356849
RE: how to add commas as thousand separator for numbers stored as text

Yes. But, since you're in the "Newbie" forum, I have to tell you that ...
1) Formatted data should not be permanently stored in SQL Server, period.
2) SQL Server 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)

July 21, 2011 at 7:57 pm

#1356848
RE: A search with a Rank

JKSQL (7/21/2011)
Yeah K Smith changed my goal. Now I want it allllllllll. 🙂 Going into this I really thought there was a function that would just 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)

July 21, 2011 at 6:25 pm

#1356838
RE: A search with a Rank

Kath Smith (7/21/2011)
I sent the code via email. For some reason SSC didnt like something within it so I couldnt post it here. Let me know if 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)

July 21, 2011 at 5:50 pm

#1356832
RE: Copy from a folder to an other

ALZDBA (7/19/2011)
Welsh Corgi (7/18/2011)
There was a post on SSC of an example of the file copy using Powershell about a week ago.
# copy all jpg files from c:\temp to c:\temp\jpgs
Copy-Item...
--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)

July 21, 2011 at 3:41 pm

#1356794
RE: A search with a Rank

This looks like it might be a problem easily solved by a Tally Table. If I get the chance tonight, I'll see what I can do. Of course,...
--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)

July 21, 2011 at 3:33 pm

#1356789
RE: The "Numbers" or "Tally" Table: What it is and how it replaces a loop.

Got it! Lynn Pettis has a similar problem. Apologies for the typical American mistake on the name. :blush:
--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)

July 21, 2011 at 2:31 pm

#1356744
RE: The "Numbers" or "Tally" Table: What it is and how it replaces a loop.

shannonjk (7/21/2011)
Jeff, Thanks for the tip! I have actually been focusing on that exact thing with indexes lately :). On a side note, I am actually a 'him' not 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)

July 21, 2011 at 1:24 pm

#1356692
RE: The "Numbers" or "Tally" Table: What it is and how it replaces a loop.

David Burrows (7/21/2011)
How about a simpler approach
SELECT DATEADD(minute, (t.N - 1) * 30, @DateStart)
FROM dbo.Tally t
WHERE t.N BETWEEN 1 AND (DATEDIFF(day, @DateStart, @DateEnd) + 1) * 48
ORDER...
--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)

July 21, 2011 at 1:23 pm

#1356691
RE: Select phone numbers depending on priority

CELKO (7/21/2011)
>> We cannot always alter the existing schema. <<
I have started asking if this is possible in my standard "cut & paste" asking for minimal Netiquette. My experience for...
--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)

July 21, 2011 at 8:20 am

#1356428
RE: How to use temporary table in function

jbnv (7/21/2011)
I confess I'm still a little confused why this trick is necessary rather than just using a table variable inside the function, which is permitted?
Mr. Dvorak stated that he...
--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)

July 21, 2011 at 8:08 am

#1356411
RE: How to use temporary table in function

Jakub Dvorak (7/20/2011)
Comments posted to this topic are about the item <A HREF="/articles/UDF/74231/">How to use temporary table in function</A>
+10 for thinking outside of the box, Jakub. There have been...
--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)

July 21, 2011 at 8:06 am

#1356406
RE: How to use temporary table in function

RichB (7/21/2011)
Presumably that also has the effect of turning the temporary table into a global temporary table that magically disappears as soon as the original session clears it out? :hehe:
Bet...
--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)

July 21, 2011 at 7:58 am

#1356393
RE: Freetext query to get surrounding portion of text

Guh! Thanks, Gus. That's what I thought.
The big problem with doing what the OP wants to do is that FTS is just what it says... it's a search....
--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)

July 20, 2011 at 9:51 pm

#1356134
RE: A Little Interviewing Advice

Travis, you're a gentleman and a scholar. Thanks for agreeing to disagree.
--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)

July 20, 2011 at 9:34 pm

#1356129

Viewing 15 posts - 33,181 through 33,195 (of 59,099 total)