Jeff Moden

Forum Replies Created

Viewing 15 posts - 42,856 through 42,870 (of 59,063 total)

RE: Read a non-delimited file and insert into table

touchmeknot123 (7/20/2009)
Hi Phil,
Thanks for the reply.
I figured it out.
I had to use merge join task and implement the same.
How were you able to split the street name from the city...
--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, 2009 at 5:27 pm

#1027360
RE: Need Help in Date Functions

. (7/20/2009)
Questions:
Is the start date you entered considered to be day 1 of week 1? In other words, if you enter a start date which is 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 20, 2009 at 5:14 pm

#1027354
RE: Datefunctions

Ah... Jedi mind games... I see now... "other 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)

July 20, 2009 at 5:12 pm

#1027352
RE: Datefunctions

Looks like the OP posted as I was writing my reply. And, is my mind playing tricks on me or are the INSERTs that you have in the quote...
--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, 2009 at 5:07 pm

#1027349
RE: Advice for the Unemployed

Steve Jones - Editor (7/19/2009)
Blogs could be a detractor, but they also show you learning, or trying to learn. The fact that you've repeated a "myth" doesn't necessarily mean you're...
--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, 2009 at 11:15 am

#1027168
RE: query running now for over 3 hours

If you do that, just remember to recreate indexes, verify FK's, establish the PK, setup constraints, copy any triggers, and rebuild any views that reference the table. 😉
--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, 2009 at 10:14 am

#1027117
RE: how to reduce tempdb size in production in ms sql

Unless there were some "run away" query that blew TempDB to an insane size, don't shrink TempDB... it's just gonna grow again.
--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, 2009 at 9:21 am

#1027060
RE: split field into numbers and join to table

I was just wondering if you are able to change the tables so that you don't have a CSV column at all. But, if you're happy, I'm happy. ...
--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, 2009 at 9:16 am

#1027048
RE: Using UDF parameter in select statement of UDF

That's the one, Lynn... it has a RowCount for each object ID and, I believe, that row count is always up to snuff.
If you read BOL about the system...
--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, 2009 at 9:14 am

#1027042
RE: how to search in sql by using like operator

Just to be sure... the "Magic" isn't in the CTE... it's in the Tally table and can be used in SQL Server 2000 just as effectively.
--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, 2009 at 6:36 am

#1026897
RE: Table design

If it's possible to have 1 comment per assessment, or not, you can easily get away with not having a comment table. If you can have more than 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)

July 20, 2009 at 1:04 am

#1026774
RE: FORMAT output to two Deciaml Places

Since you're formatting data, let's throw in right-justification, as well...
STR(ISNULL(SUM(QuantityOutstanding),0),10,2) AS Quantity
The key is that this type of formatting should be left up to the GUI, if you have 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)

July 20, 2009 at 12:59 am

#1026767
RE: Using UDF parameter in select statement of UDF

Ummmm.... now that I think about it, there's some new (new in 2k5) system view that actually gives you the correct number of rows for any given table without having...
--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, 2009 at 12:53 am

#1026765
RE: Using UDF parameter in select statement of UDF

AShehzad (7/20/2009)
Thanks for reply, Moden. Actually this example UDF was to convey my problem. I was looking to create some UDFs for various tasks and was required to use dynamic...
--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, 2009 at 12:51 am

#1026764
RE: Table design

Vinoo (7/19/2009)
GilaMonster (7/18/2009)
Did you change the names to obfuscate things, or are the columns really called that?
How does that matter to solve the problem? you can have any name 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 20, 2009 at 12:47 am

#1026761

Viewing 15 posts - 42,856 through 42,870 (of 59,063 total)