Jeff Moden

Forum Replies Created

Viewing 15 posts - 35,341 through 35,355 (of 59,102 total)

RE: SQL Dilemma

chaudharyabhijit (1/17/2011)
Hello Jeff,
Thank you for the suggestion. I would love to do what you asked me but unfortunately these tables are from a really obsolete software and there is no...
--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)

January 18, 2011 at 7:31 am

#1274715
RE: How to fill in nulls in a set with zeroes?

keymoo (1/18/2011)
Jeff Moden
Just to follow up on that... a good ol' fashioned cross-tab can make life real easy and "prettier".
SELECT Symbol,
SUM(CASE...
--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)

January 18, 2011 at 7:29 am

#1274713
RE: Normalise Data

Bryan McGuire (1/17/2011)
Hi,
I have been given a task to create a pivot table from a table of data supplied via a 3rd party.
The table is structured like this...
CREATE TABLE [dbo].[EntityRiskGroupKeyItem](
[Name]...
--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)

January 17, 2011 at 11:21 pm

#1274494
RE: TSQL Problem -- Cal the actual working hours for a particular users

sqlbaby2 (1/17/2011)
I already found the solutions ...thanks
In that case, would you mind sharing them? Two way street here... 😉
And... you should still read the article I pointed you 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)

January 17, 2011 at 11:06 pm

#1274492
RE: Basic SQL Query, going wrong somewhere......

omd (1/17/2011)
Hi,
I have a table that has a specific column holding dates & also a time e.g. '1/14/2011 16:25:32 PM'.
All I am trying to do is use a basic delete...
--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)

January 17, 2011 at 11:02 pm

#1274489
RE: Using Case for an Update

tacy.highland (1/17/2011)
Here's the scenario:
There are two tables involved. One is the BookingActivity table which will be updated. The Update statement will also look at the Clients table 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)

January 17, 2011 at 11:00 pm

#1274488
RE: Best practice for building a SELECT query based on multiple paramters

JayK (1/17/2011)
Found this article which looks good to me:
http://www.sqlteam.com/article/implementing-a-dynamic-where-clause
Using COALESCE certainly looks a lot neater.....
You need to be a wee bit careful with COALESCE because it will change datatypes based...
--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)

January 17, 2011 at 10:49 pm

#1274483
RE: Mulitple procedure vs Single procedure

CELKO (1/17/2011)
You were asleep in your freshman Software Engineering class! Coupling? Cohesion? Remember all that stuff?
Each module of code should have one entry and one exit point. Each...
--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)

January 17, 2011 at 10:37 pm

#1274480
RE: Page Splits on Non-clustered unique primary Key

sqlchanakya (1/17/2011)
So can we take a conclusion that we will have page splits at non clustered level even its a sequentially ordered?
No. Not necessarily but you certainly could 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)

January 17, 2011 at 10:23 pm

#1274477
RE: TSQL Problem -- Cal the actual working hours for a particular users

sqlbaby2 (1/17/2011)
Thanks for the solutions .. now i having a new issues, i try to summarizing data with rollup in order to get the total amount of durations for each...
--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)

January 17, 2011 at 10:08 pm

#1274475
RE: ISNULL of an INTEGER

imohamed (12/3/2010)
I discovered a functionality of ISNULL today that I hope there is a good explanation for it.
Eg: Table "T1" has an integer field "A" which is either 0...
--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)

January 17, 2011 at 10:05 pm

#1274473
RE: SQL Dilemma

Just a couple of notes I'd like to add... first, we've just seen what happens when date and time are stored in separate columns for things like this. 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)

January 17, 2011 at 9:57 pm

#1274471
RE: Page Splits on Non-clustered unique primary Key

The DM you're using will not help you find page splits. sys.dm_db_index_physical_stats will show you the affect that page and extent splits have had in the form of fragmentation...
--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)

January 17, 2011 at 9:46 pm

#1274467
RE: Error while executing cursors

You bet. Thank you for the feedback.
--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)

January 17, 2011 at 9:41 pm

#1274464
RE: Help! SQL select statement for an uncommon task

picant (1/17/2011)
Tanks that's something I was looking for. Looks quite complex. It'll take me some time to understand how it works. Thanks again.
Nope... not complex at all. The first...
--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)

January 17, 2011 at 9:39 pm

#1274462

Viewing 15 posts - 35,341 through 35,355 (of 59,102 total)