Jeff Moden

Forum Replies Created

Viewing 15 posts - 48,196 through 48,210 (of 59,095 total)

RE: SQL script to import data from .txt table using BCP

At least tell your buddy that there's errors in the data that he might not be aware of... dude... 😉
--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)

September 20, 2008 at 7:23 pm

#874650
RE: store output of stored proc into temp table

By the way... if you believe in paper instead of code, please read the Microsoft article at the following link...
http://support.microsoft.com/kb/153441/EN-US/
See where it says "NOTE: This problem does not apply 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)

September 20, 2008 at 7:07 pm

#874649
RE: store output of stored proc into temp table

Man, I really appreciate you watching out for me, Sergiy. I've learned a lot from you. Thanks...
Ok... like I've done before when this controversy of Select/Into has come...
--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)

September 20, 2008 at 6:50 pm

#874648
RE: SQL script to import data from .txt table using BCP

Exact same principles apply... but, now the requirements sound like homework. Recommend you take a look at Books Online and do your own homework... 😉
Good luck.
--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)

September 20, 2008 at 3:42 pm

#874638
RE: Invalid views

Barry... nice blog! But why don't you write that stuff as articles on SSC? 😉
--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)

September 20, 2008 at 3:37 pm

#874635
RE: SQL script to import data from .txt table using BCP

Ok... no error checking except for total number of rows. That also means, no primary key in this instance. You have to remove the primary key from 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)

September 20, 2008 at 11:59 am

#874621
RE: Invalid views

Heh... Barry's post wasn't there when I started typing my response.
I agree, Barry... I used to call variables such as these "accumulators" which is also probably more appropriate.
"Pseudo Cursors"? ...
--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)

September 20, 2008 at 9:41 am

#874608
RE: last time table is accessed

bkDBA (9/19/2008)
Thanks. Good info. Have you actually tried it? Not trying to be a smart guy about this... I've heard that the auditing features of 2k8 are...
--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)

September 20, 2008 at 9:27 am

#874606
RE: store output of stored proc into temp table

Ninja's_RGR'us (9/19/2008)
Jeff Moden (9/18/2008)
Ninja's_RGR'us (9/18/2008)
Yes you need to create it first, including column definitions.
Heh... not exactly true...
SELECT *
INTO #MyHead
FROM OPENROWSET('SQLOLEDB','Server=(local);Trusted_Connection=Yes;Database=Master',
...
--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)

September 20, 2008 at 9:23 am

#874605
RE: store output of stored proc into temp table

Madhivanan (9/19/2008)
Jeff Moden (9/18/2008)
Ninja's_RGR'us (9/18/2008)
Yes you need to create it first, including column definitions.
Heh... not exactly true...
SELECT *
INTO #MyHead
FROM OPENROWSET('SQLOLEDB','Server=(local);Trusted_Connection=Yes;Database=Master',
...
--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)

September 20, 2008 at 9:18 am

#874603
RE: SQL script to import data from .txt table using BCP

With error checking... broad subject... lemme start by asking what you want to do with the duplicate primay keys included in your sample file?
--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)

September 20, 2008 at 9:07 am

#874602
RE: Invalid views

Wandrag (9/18/2008)
Whoa -this is cool....:)
Can you please explain how this works (Not the sp_refreshview part), but the fact that one don't have to loop through the view names to build...
--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)

September 20, 2008 at 8:44 am

#874601
RE: File System Task

Still, will that create a directory that doesn't already 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)

September 20, 2008 at 7:38 am

#874595
RE: Joining the darkside

rbarryyoung (9/19/2008)
Jeff Moden (9/18/2008)
What ever possesed you to join the darkside?
You don't know the power of the darkside!
😀
Heh... "These are not the droids you want... move along." 😛
--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)

September 19, 2008 at 10:29 pm

#874538
RE: Can any one help me to prepare basic check list for database server for SQL server 2005.

Jason Wisdom (9/19/2008)
http://searchsqlserver.techtarget.com/tip/0,289483,sid87_gci1180698,00.html
This article, combined with my own experiences, forms the basis of my above post.
Thanks, Jason... I misread your previous post a bit. I agree that these are...
--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)

September 19, 2008 at 10:27 pm

#874537

Viewing 15 posts - 48,196 through 48,210 (of 59,095 total)