Jeff Moden

Forum Replies Created

Viewing 15 posts - 42,976 through 42,990 (of 59,098 total)

RE: Use sp_MSforeachtable to gen COUNT(*) for each table in MyDBname

Now... if you want to know a bit more about each table including the row counts, try this...
--_______________________________________________________________________________________________________________________
/**********************************************************************************************************************
Purpose:
Returns a single result set similar to sp_Space used for all...
--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)

July 17, 2009 at 9:45 pm

#1026496
RE: Use sp_MSforeachtable to gen COUNT(*) for each table in MyDBname

You bet. Thanks for the feedback, TJ.
But I wasn't the first one to suggest it on this thread. Go back and look at what dobrzak wrote earlier. ...
--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)

July 17, 2009 at 9:31 pm

#1026493
RE: Read a non-delimited file and insert into table

It's not possible with the current information because there's nothing to identify the difference between the street and the city.
--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)

July 17, 2009 at 4:20 pm

#1026473
RE: remove duplicate rows

Heh... and the read up on proper table design so you can tell the folks who designed that table how to fix it. 😛
--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)

July 17, 2009 at 4:17 pm

#1026472
RE: sql query

TAman (7/17/2009)
I need to create a report to show a list of employees that have made an entry on a file more than once within any 60 minute window. ...
--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)

July 17, 2009 at 4:14 pm

#1026471
RE: Group by 15 minutes not Hour

First, a suggestion especially since you've got 613 points and you should really know better by now.. Read the first link in my signature line below for how 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)

July 17, 2009 at 4:06 pm

#1026470
RE: Cursor Performance Problem

Perhaps I misunderstood.... is there a cursor within the business logic for each spreadsheet or is there just one cursor that that controls which sheets are loaded one at 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)

July 17, 2009 at 2:51 pm

#1026451
RE: How to Recover Database without Backup

You may be able to use a disk utility to try to "undelete" the file, but chances of that happening on an active system decrease dramatically with every passing 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)

July 17, 2009 at 2:17 pm

#1026438
RE: Datefunctions

kaladharreddy15 (7/17/2009)
Hi Friends,
I need your's help on
This is my requirement there are two date parameters (@Startdate and @Enddate), when we select start date and end date...
--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)

July 17, 2009 at 2:12 pm

#1026437
RE: Returning accumulated totals from multiple rows

I have to ask an obvious question... sorry if it's too obvious... do you know how to use SUM() and GROUP BY?
--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)

July 17, 2009 at 2:05 pm

#1026432
RE: Cursor Performance Problem

KT8177 (7/17/2009)
I know cursors are generally not recommended but in this case it's needed.
Heh... says you. 😉 Perhaps you just haven't thought of the way to do...
--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)

July 17, 2009 at 1:58 pm

#1026428
RE: creating table and copying fields

novice82 (7/16/2009)
Thanks Jack.
I found a solution from the oracle forum.
Cool! Tell us what the solution is, please.
--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)

July 17, 2009 at 1:49 pm

#1026424
RE: 'replacing' values in a select statement

mmunson (7/16/2009)
Hi GSquared! 🙂
I could.... but I was hoping to get around that because I would need approval to create a new table. And then heads...
--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)

July 17, 2009 at 1:48 pm

#1026420
RE: Pivot query problem - can this be done ?

Ya beat me to it. Thanks for the "plug", Allister. 🙂
--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)

July 17, 2009 at 10:52 am

#1026323
RE: UNPIVOT using T-SQL

Mansfield (7/16/2009)
Since you have done the pivot the hard way, here's the equivalent to unpivot...
Before you go calling it the "hard way", you might want to read up on it...
--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)

July 17, 2009 at 10:50 am

#1026322

Viewing 15 posts - 42,976 through 42,990 (of 59,098 total)