Jeff Moden

Forum Replies Created

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

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
RE: Help! SQL select statement for an uncommon task

Here's one possible answer to the problem you requested. It does not, however, fix the fact that you're relating tables that have no relationship to each other...
--===== This just...
--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 8:46 pm

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

picant (1/17/2011)
Does anybody have a simple explanation what's wrong with such structure?
Yes... it produces data that doesn't actually exist in the real world. Instead, it produces randomized results from...
--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 8:23 pm

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

s_osborne2 (1/17/2011)
Hi,
Change your select statement to have the following:
;
WITH cte
AS ( SELECT
...
--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 7:44 pm

#1274438

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