Jeff Moden

Forum Replies Created

Viewing 15 posts - 49,621 through 49,635 (of 59,099 total)

RE: Query Data without Dynamic SQL

GilaMonster (6/27/2008)
Jeff Moden (6/26/2008)
I haven't had to work with it so haven't been able to see what it actually does to a database and, as a result, can't say whether...
--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)

June 27, 2008 at 12:16 am

#835170
RE: Temporary Table problem

Ummm... yeah... just don't try to run the same proc twice at the same time unless you detect if the table is present before you make it...
... and be pretty...
--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)

June 27, 2008 at 12:10 am

#835166
RE: Inserting row with Procedure

Never mind... I got it... took a little trickery...
drop table #Fun
GO
select *
into #fun
from openquery([myserver],'SET FMTONLY OFF exec master.dbo.xp_DirTree [C:\],1,1')
select * from #fun
--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)

June 26, 2008 at 11:15 pm

#835156
RE: Inserting row with Procedure

Bugger... this works just fine (I changed my servername in the code)....
drop table #Fun
GO
select *
into #fun
from openquery([myserver],'exec master.dbo.sp_who')
select * from #fun
... and so does this...
exec master.dbo.xp_DirTree [C:\],1,1
... but this...
--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)

June 26, 2008 at 11:03 pm

#835154
RE: Inserting row with Procedure

Dang it... nicely done, Matt... I totally forgot that OpenQuery could have an EXEC in it. :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)

June 26, 2008 at 10:22 pm

#835145
RE: SQL table dynamic creation

gerald.duncan (6/25/2008)
and create a separate SQL table from each file
[font="Arial Black"]WHY???[/font] :blink: Especially when they all have the same file format...
--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)

June 26, 2008 at 10:14 pm

#835144
RE: Table var maximum row number

Heh... best way to prevent recompiles in 2k5... is to... use 2k :hehe:
--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)

June 26, 2008 at 10:09 pm

#835142
RE: Query Data without Dynamic SQL

This kind of "trick" is to make forming GUI code (inherently dynamic) easier. It's a trick to try to make the GUI table driven so someone doesn't have 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)

June 26, 2008 at 10:05 pm

#835139
RE: extracting database sizes using sp_spaceused

susan.bartrum (6/26/2008)
Thank you.
Now looked at the code, so that will keep me out of trouble for a little while!
If you want to stay out of trouble even longer, don't declare...
--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)

June 26, 2008 at 9:43 pm

#835126
RE: UPDATE statement that creates duplicate records

I think I see a dual triangular join between Deleted and Inserted and that might give you a funky rowcount... but I don't see anything in that code that would...
--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)

June 26, 2008 at 9:40 pm

#835125
RE: Order by Query

Heh... that's what happens when you store dates or times as formatted data. These should be stored just as a DateTime data type and formatted for display only. ...
--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)

June 26, 2008 at 9:33 pm

#835123
RE: eliminating duplicates

janine.rawnsley (6/26/2008)
Doesn't look right?? And I can't honestly say I understand his code.. I feel a bit dense ;/
Nah... Don't feel dense... Like I said above, Barry simply forgot 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)

June 26, 2008 at 9:25 pm

#835120
RE: Temporary Table problem

suhas.kanade (6/26/2008)
We have to write a stored procedure in SQL 2000 in which we need to create dynamically 3-5 tables depending on parameters. But in that we are facing 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)

June 26, 2008 at 9:15 pm

#835117
RE: Temporary Table problem

Karthik,
Try to select from the temp table the code just made...
--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)

June 26, 2008 at 9:09 pm

#835116
RE: Archetype Records

What did you find out when you Googled or Yahoo'd the word?
--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)

June 26, 2008 at 9:06 pm

#835113

Viewing 15 posts - 49,621 through 49,635 (of 59,099 total)