Jeff Moden

Forum Replies Created

Viewing 15 posts - 25,471 through 25,485 (of 59,099 total)

RE: SQLCMD

Heh... I had to think about it. For me, the correct answer would have started with "Exec xp_CmdShell". 😀
--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)

November 5, 2013 at 2:04 pm

#1664249
RE: How to Design, Build and Test a Dynamic Search Stored Procedure

Phil Parkin (11/5/2013)
Dwain does it again - nice article sir!
Ditto that! Nicely done, Dwain. Great explanations and revelation of code.
--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)

November 5, 2013 at 11:46 am

#1664211
RE: sp_OAMethod to retrieve the file attributes from a folder

jsteinbeck-618119 (11/5/2013)
Jeff,
The user is in the DB via GUI, they click a button on the form the basically says, "Lets look at new faxes that came in", and this form...
--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)

November 5, 2013 at 7:41 am

#1664146
RE: display order by like 1,2,3,4,5...............plz write quarie

dwain.c (11/5/2013)
Jeff Moden (11/5/2013)
dwain.c (11/5/2013)
For what it's worth, I'm in favor of a selective culling of the gene pool. 😛
I assure you, it's just words from some serious pent up...
--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)

November 5, 2013 at 1:22 am

#1664056
RE: Are the posted questions getting worse?

SQLRNNR (11/4/2013)
Ed Wagner (11/4/2013)
SQLRNNR (11/4/2013)
jasona.work (11/4/2013)
The joy and fun of migrating DBs to a new server...
Trying to get in touch with the people who need to update the application, people...
--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)

November 5, 2013 at 1:08 am

#1664052
RE: display order by like 1,2,3,4,5...............plz write quarie

dwain.c (11/5/2013)
For what it's worth, I'm in favor of a selective culling of the gene pool. 😛
I assure you, it's just words from some serious pent up frustration from working...
--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)

November 5, 2013 at 1:01 am

#1664051
RE: sp_OAMethod to retrieve the file attributes from a folder

I guess I'm a little confused about your process. What do you mean by "when a user access this file from within the DB"?
--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)

November 5, 2013 at 12:58 am

#1664050
RE: display order by like 1,2,3,4,5...............plz write quarie

dwain.c (11/4/2013)
Sounds like you have the luxury of an orderly, controlled shop. Congratulations for exercising such strict controls (and being able to)!
I don't think of them as strict controls...
--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)

November 5, 2013 at 12:39 am

#1664048
RE: hierarchical linking of locations to each other

hoseam (11/4/2013)
Jeff Moden (11/4/2013)
How many rows will this table eventually have and how often will it need to take new inserts or updates?
1. As many as it could
2. Not very...
--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)

November 5, 2013 at 12:18 am

#1664046
RE: display order by like 1,2,3,4,5...............plz write quarie

GilaMonster (11/4/2013)
Jeff Moden (11/4/2013)
Yes, yes... I know... all of your character based columns are NVARCHAR(MAX) because someone believes that "Premature optimization is the root of all evil." The problem...
--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)

November 5, 2013 at 12:03 am

#1664042
RE: display order by like 1,2,3,4,5...............plz write quarie

dwain.c (11/4/2013)
Jeff Moden (11/4/2013)
shashianireddy (11/4/2013)
sql 2008 version ,,nvarchar(MAX)
You're using NVARCHAR(MAX) for a housenumber???? In SQL Server 2008???? Why?????
You probably don't release it but you cannot rebuild a clustered index...
--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)

November 4, 2013 at 11:09 pm

#1664034
RE: display order by like 1,2,3,4,5...............plz write quarie

shashianireddy (11/4/2013)
Iam try this quarie but not display above format show as above
For the given data, it certainly does. Please post the data you're using where it doesn't.
Declare @tblTemp...
--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)

November 4, 2013 at 10:55 pm

#1664032
RE: display order by like 1,2,3,4,5...............plz write quarie

shashianireddy (11/4/2013)
sql 2008 version ,,nvarchar(MAX)
You're using NVARCHAR(MAX) for a housenumber???? In SQL Server 2008???? Why?????
You probably don't realize it but you cannot rebuild a clustered index in an Online...
--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)

November 4, 2013 at 10:42 pm

#1664031
RE: display order by like 1,2,3,4,5...............plz write quarie

twin.devil (11/4/2013)
Better practice is to maintain a sequence column in the table.
Why? I've added such a thing only when there is no other means and there 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)

November 4, 2013 at 10:33 pm

#1664030
RE: Consolidating an entire year into a single query

SQLTestUser (11/4/2013)
I Have a query that counts individual monthly orders just a simple count as below, however i want to consolidate the query below into a single query 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)

November 4, 2013 at 9:16 pm

#1664026

Viewing 15 posts - 25,471 through 25,485 (of 59,099 total)