Jeff Moden

Forum Replies Created

Viewing 15 posts - 46,396 through 46,410 (of 59,101 total)

RE: How to calculate the Bi-weekly in SQL

Dugi (12/26/2008)
Dugi (12/26/2008)
Jeff you are amazing ...I'm going to delete my answers ah :hehe:
but can you explain to me this t.n*14 where did you find it ???
SELECT DATEADD(dd,t.n*14,'20090102')...
--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)

December 26, 2008 at 10:33 am

#917864
RE: How to calculate the Bi-weekly in SQL

doss.tychicus (12/26/2008)
Thanks Jeff . that's really cool
You bet, Doss... thanks 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)

December 26, 2008 at 10:31 am

#917863
RE: How to transpose the ROWs

Praveen,
If you want to learn how to make cross tabs, then what Madhivanan suggested is a good idea. Also, I wrote a kind-of tutorial on how to make 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)

December 26, 2008 at 10:29 am

#917862
RE: Is it possible to call stored procedures inside a function

vaibhav.a (12/26/2008)
I want to call a stored procedure inside a function... and then create a view using that function . How can i use stored procedure inside a function....
Thank You...
--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)

December 26, 2008 at 10:25 am

#917860
RE: Still shows scan

samsql (12/25/2008)
hi i hav an update query which show table scan m confused how to i put indexes so that it does not scan the table
Update temp1 Set 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)

December 26, 2008 at 10:22 am

#917857
RE: How to calculate the Bi-weekly in SQL

doss.tychicus (12/26/2008)
is there any way i can calculate bi weekly in sql
from ex:
from 1/1/2009 to 12/31/2009
I need to know all the fridays biweekly
ex 1/2/2009, 1/16/2009,1/30/2009
Thanks
It's...
--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)

December 26, 2008 at 10:01 am

#917845
RE: How can we create view from a stored procedure in sql server 2005

Never mind... the answer is YES... you CAN use OPENROWSET in the view. What that means is that you CAN use a stored procedure as the source for 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)

December 26, 2008 at 9:39 am

#917838
RE: How can we create view from a stored procedure in sql server 2005

Ummmm.... Anyone know for sure if OPENROWSET, OPENQUERY, or OPENDATASOURCE can be used in a view or not? That could be the ticket.
--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)

December 26, 2008 at 9:28 am

#917834
RE: Performance isssue

Ummmm... if the real tables are going to be in a database that doesn't have SIMPLE recovery, then probably not. If the temp tables are being used as replacements...
--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)

December 26, 2008 at 9:19 am

#917826
RE: How do I combine records

ramadesai108 (12/26/2008)
Hi David,
I previsouly added the case statement in the group by, but forgot to add it in the order by and that's where 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)

December 26, 2008 at 9:06 am

#917822
RE: Is there a Bug with the Replace() Function in SQL Server 2005

Madhivanan (12/26/2008)
Refer
http://sqlblogcasts.com/blogs/madhivanan/archive/2008/07/15/varchar-max-datatype-and-replicate-function.aspx
Yep... we all agree on that. I believe the main complaint is... the documentation doesn't say anything about the default size.
--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)

December 26, 2008 at 8:47 am

#917811
RE: A simple CrossTab procedure

Interesting concept... but it doesn't work correctly. I ran the code and the test code, as is... the results are not exactly a cross tab... look at the scores...
--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)

December 25, 2008 at 1:19 pm

#917667
RE: Is there a Bug with the Replace() Function in SQL Server 2005

Perry Whittle (12/25/2008)
Lynn Pettis (12/17/2008)
since it needs to create the table on the fly it doesn't know how big the column needs to be so it so it makes 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)

December 25, 2008 at 12:12 pm

#917663
RE: Get Missing Data with Tally Table

Heh... only 365 brain cell shopping days left...
--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)

December 25, 2008 at 12:09 pm

#917662
RE: Are the posted questions getting worse?

Man, I sure hope they survive... I don't believe folks understand what an impact they've had on the United States and North America in general in the last 100 years....
--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)

December 25, 2008 at 12:07 pm

#917661

Viewing 15 posts - 46,396 through 46,410 (of 59,101 total)