Jeff Moden

Forum Replies Created

Viewing 15 posts - 39,376 through 39,390 (of 59,098 total)

RE: How to select in this case - very complex SQL

Please read the article at the first link in my signature below. You'll get better help. A description of what you want to actually accomplish would also be...
--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)

March 13, 2010 at 8:42 am

#1133212
RE: CURSORS

gilbert delarosa (3/12/2010)
Each of my clients has its own database with all of the same obects. I often have to query data for all clients for internal reports. I have...
--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)

March 12, 2010 at 9:44 pm

#1133123
RE: Attribute to identify system databases

{Edit} Didn't see Paul's post... Paul has it right.
--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)

March 12, 2010 at 9:38 pm

#1133120
RE: Is it possible...

Steve Jones - Editor (3/12/2010)
I don't think there's a way to be sure of the last date, but you can disable logins and then see if someone complains.
Heh... disable 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)

March 12, 2010 at 9:32 pm

#1133118
RE: Query timeout, High DiskIO & low page life expectancy

Please see the article at the second link in my signature line below. Thanks.
--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)

March 12, 2010 at 9:30 pm

#1133117
RE: Eliminating Timeouts

sqlislife (3/12/2010)
How can a midsized company such as ours go about eliminating timeout caused by users. Is it possible? Anything causes timeouts from jobs running simultaneously as server requests 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)

March 12, 2010 at 9:28 pm

#1133114
RE: Manipulate Date Output

monitor89 (3/12/2010)
I have YYYYMMDD stored in dob column in table h.
The line below gives me MMDDYYYY
substr(h.dob,5,2) || right(h.dob,2) || left(h.dob,4) as Birth_Date,
What should I change/add to insert slashes into 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)

March 12, 2010 at 9:24 pm

#1133113
RE: sql server stored procedure

r.vijaykanth (3/12/2010)
i want to create a stored procedure
which takes tablename as input and returns table data as out put
Why? What is the business reason for 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)

March 12, 2010 at 9:21 pm

#1133112
RE: DBA Won't Allow Alter Table for Identity Insert

What is the nature of the data where you'd want to insert directly into an IDENTITY column?
--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)

March 12, 2010 at 9:13 pm

#1133109
RE: Are the posted questions getting worse?

Lynn only needs 37 more posts to become to only the 4th person to ever break the 10k post mark in the history of SSC. C'mon Lynn! We'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)

March 12, 2010 at 8:52 pm

#1133107
RE: Are the posted questions getting worse?

Lynn Pettis (3/11/2010)
CirquedeSQLeil (3/11/2010)
Jeff has quietly passed the 20,000 pt mark. No fanfare???
Congrats Jeff.
[font="Comic Sans MS"]Congratulations on passing 20,000, Jeff!![/font]
Heh... sorry I'm late for the party! 😛 ...
--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)

March 12, 2010 at 8:47 pm

#1133106
RE: Duplicating a record within a table

patrick 98158 (3/11/2010)
Hello All,
I have a Table1 with 10 fields currently.
Field#1 is a unique key.
I have a UI that prompts the user for
a. an existing Field#1 (from unique...
--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)

March 11, 2010 at 10:03 pm

#1132451
RE: How should conditions be stored in a table?

Gosh... the FNF thing notwithstanding, I guess I'd have to say "It Depends". BIT datatypes can't be aggregated (sometimes useful for getting a count using a SUM of items...
--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)

March 11, 2010 at 9:58 pm

#1132450
RE: select random records but for each category

Hmmmm.... this problem is coming up more and more... must be a new homework problem by a given teacher in some school or maybe a favorite "take home" interview question...
--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)

March 11, 2010 at 9:44 pm

#1132445
RE: bcp usage syntax error

First error I see is that you have the database name in the -S parameter. Remove the .POSTCARD and try 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)

March 11, 2010 at 9:33 pm

#1132442

Viewing 15 posts - 39,376 through 39,390 (of 59,098 total)