Jeff Moden

Forum Replies Created

Viewing 15 posts - 34,231 through 34,245 (of 59,099 total)

RE: openquery - stored procedure

Tom.Thomson (4/18/2011)
Jeff Moden (4/17/2011)
Tom.Thomson (4/17/2011)
Incidentally, you can't call a stored procedure using OPENQUERY either.
Maybe not, but OPENROWSET works a treat.
Interesting. I wonder why MS decided to forbid calling...
--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)

April 18, 2011 at 5:33 pm

#1313137
RE: openquery - stored procedure

ChrisM@home (4/18/2011)
Jeff Moden (4/18/2011)
ChrisM@home (4/18/2011)
nikplic (4/17/2011)
Because, i want to have one code with whom i want to call datasources for my forms. I use FoxPro9 and SQL SErver 2008, and...
--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)

April 18, 2011 at 5:28 pm

#1313135
RE: Are the posted questions getting worse?

Gianluca Sartori (4/18/2011)
If somebody asked me for a compression tool, I would recommend IZArc, which is free and handles a lot of archive types, including RAR and ZIP.
http://www.izarc.org/index.html
Thanks, Gianluca. ...
--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)

April 18, 2011 at 7:39 am

#1312767
RE: Are the posted questions getting worse?

GilaMonster (4/18/2011)
Cross posting Jeff? 🙂
Higher compression. Ability to split the archive into multiple files (great for huge archives going onto CD/DVD or for getting through email limits). Encryption and passwords....
--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)

April 18, 2011 at 7:33 am

#1312760
RE: sql for building dynamic columns and rows from 2 tables.

That data structure will continue to burn you throughout your professional career at whatever company you're working for. Make them change it to a normalized data structure. Don't...
--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)

April 18, 2011 at 7:27 am

#1312756
RE: Are the posted questions getting worse?

Someone please tell me the advantage to using RAR files over ZIP files. ZIP files are the defacto compression type... what does RAR do that ZIP does not (except...
--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)

April 18, 2011 at 7:20 am

#1312738
RE: Database Response is too slow

As a side bar, I have an older machine that doesn't have RAR extracters in it, yet (so I can't see the OPs attachment). Someone please tell me if...
--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)

April 18, 2011 at 7:14 am

#1312731
RE: openquery - stored procedure

ChrisM@home (4/18/2011)
nikplic (4/17/2011)
Because, i want to have one code with whom i want to call datasources for my forms. I use FoxPro9 and SQL SErver 2008, and code is that...
--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)

April 18, 2011 at 7:08 am

#1312725
RE: openquery - stored procedure

I'll also state that "genericising" stored procs like this is a really bad idea. Be very careful. And, I'll warn again, I've not tested the above for SQL...
--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)

April 18, 2011 at 6:07 am

#1312702
RE: openquery - stored procedure

You can't have variables in OPENROWSET. Instead, you have to make the whole thing a dynamic statment. With that comes the possiblity of SQL INJECTION. You need...
--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)

April 18, 2011 at 5:59 am

#1312700
RE: copy files through network to another server

That, most definitely, would be true. 🙂
--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)

April 18, 2011 at 5:11 am

#1312676
RE: copy files through network to another server

Restore from tape maybe?
--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)

April 17, 2011 at 9:16 pm

#1312581
RE: openquery - stored procedure

Tom.Thomson (4/17/2011)
Incidentally, you can't call a stored procedure using OPENQUERY either.
Maybe not, but OPENROWSET works a treat.
SELECT *
FROM OPENROWSET('SQLOLEDB','Server=YourServer\InstanceHere;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)

April 17, 2011 at 9:09 pm

#1312580
RE: hierarchyid traversing the tree.

chrisLosAngles (4/17/2011)
What would you advice?
"Consistency and extensibility".
First, you're going to hate yourself in another year when another "October" comes around. You MUST include the year for your "volume" markers.
Second,...
--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)

April 17, 2011 at 7:19 pm

#1312576
RE: reading text datetime value with OPENROWSET and MICROSOFT.ACE.OLEDB12.0 changes datetime value

Indeed it does help. Thanks, Adrian. I'll give them a whirl.
--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)

April 17, 2011 at 5:07 pm

#1312566

Viewing 15 posts - 34,231 through 34,245 (of 59,099 total)