Jeff Moden

Forum Replies Created

Viewing 15 posts - 35,731 through 35,745 (of 59,099 total)

RE: Shrinking Databases

Remove autoshrink? No... I never use it and probably never will. I also can't think of a reason why I'd ever use it. But it takes MS...
--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 11, 2010 at 2:24 pm

#1261339
RE: Need help with additional SUM for SQL Pivot

Also, if you post data as outlined in the article at the first link in my signature line below, you might even get someone to provide a tested, coded answer....
--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 11, 2010 at 1:49 pm

#1261335
RE: time diff hh.mm

Bharat Panthee (12/11/2010)
if shorttime in hh:mm format then just used:
select CAST((cast((datediff(minute,[EmpSIN],[EmpSOut])-datediff(minute,[FirstIn],[FirstOut]))/60 as varchar(10))+ ':' + cast((datediff(minute,[EmpSIN],[EmpSOut])-datediff(minute,[FirstIn],[FirstOut]))% 60 as varchar(10))) AS TIME),
Heh... I guess "No replies to this thread 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)

December 11, 2010 at 1:45 pm

#1261334
RE: time difference in hh.mm

Never mind... someone posted an answer on the cross post at http://www.sqlservercentral.com/Forums/Topic1033293-145-1.aspx even though Gail asked folks to post here.
Moving on.
--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 11, 2010 at 1:41 pm

#1261333
RE: time difference in hh.mm

pnasz (12/11/2010)
I have one computed column Shorthours.
In this computed column i want to display the result in hh.mm
empid FirstIn FirstOut EMPSIN EMPSOut hrworked shorthr
100 08:35:00 18:01:00 08:00:00 18:00:00 9.26 0.74
firstin,firstout...
--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 11, 2010 at 1:37 pm

#1261332
RE: Syntax for creating packages in SQL Server 2000

anitha.chacko (12/11/2010)
Pls help me.How to create a package in SQL Server 2000
If the reference of "package" means like the ones in Oracle, you don't. SQL Server has no equivalent.
--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 11, 2010 at 1:31 pm

#1261331
RE: How can I get this selection in one TSQL run ?

Digs (12/11/2010)
Thanks Jeff..
Progress has been good since our last chat !:-):-D:-)
Very cool. Thanks for the feedback on that.
--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 11, 2010 at 1:29 pm

#1261330
RE: How can I get this selection in one TSQL run ?

ChrisM@home (12/11/2010)
Good Lord, I've been reincarnated as Jeff's fluffer!
Heh... a fine fluffer you'd be indeed. 😛 But it wasn't that. You posted right after I started my...
--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 11, 2010 at 1:28 pm

#1261329
RE: How can I get this selection in one TSQL run ?

Digs (12/11/2010)
What for... I have ID as a count down, How's ROW_NUMBER() gonna make a diff ???
All I need is a guru to spend 1 sec of his time 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)

December 11, 2010 at 12:34 pm

#1261323
RE: Quirky Update TSQL skill required on this calc

Thanks for the readily-consumable data and the great description of the problem.
First, I added a necessary column to the Temp table during its creation...
IF OBJECT_ID('tempdb..#priceData') IS NOT NULL DROP TABLE...
--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 11, 2010 at 12:18 pm

#1261320
RE: Getting Started in SQL Server

NICE! Well done, Craig! This is one of those that should be required reading... especially for recruiters, job seekers, and managers that don't have an SQL background.
--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 10, 2010 at 6:01 am

#1260990
RE: TSQL CSV issue

JKSQL (12/9/2010)
This is actually what it needs to be. I finally got around to debugging it. I was missing a comma before and after. If there is a more...
--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 9, 2010 at 7:26 pm

#1260862
RE: TSQL CSV issue

churlbut (12/9/2010)
I have a cool function that I use for just this reason:
Create a table function:
CREATE FUNCTION [dbo].[ParseValues]
(@String varchar(8000),
@Delimiter char(1)...
--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 9, 2010 at 6:53 pm

#1260860
RE: Are the posted questions getting worse?

Jack Corbett (12/8/2010)
I still haven't seen any valid excuses...
Travel money, hotel money, earn money... I'd love to make the trip from Detroit to Florida this time of year but I...
--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 9, 2010 at 12:36 pm

#1260742
RE: Need advice to improve SQL Server 2000 performance

thang_ngo_2002 (12/6/2010)
Yes, of course I will upgrade to Enterprise version
But as my second question, I'm worry about stabilization of Windows because at that case Windows has only 1GB for kernels.
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)

December 9, 2010 at 12:32 pm

#1260735

Viewing 15 posts - 35,731 through 35,745 (of 59,099 total)