Jeff Moden

Forum Replies Created

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

RE: trying to count number of distinct minutes of record inserted by hour. If minutes are in sequential order then they should count as 1.

CELKO (12/8/2010)
set up and populate a table with the time slots defined by the start and end times, then update that table as you get data. It should be an...
--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 4:09 pm

#1261347
RE: Get new Identity Value Insert into another table

CELKO (12/8/2010)
Your approach is completely wrong. You are trying to build pointer chains using the count of physical insertion attempts as pointers instead of a real key. You are not...
--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:56 pm

#1261343
RE: PreVisor Assessment Test

Just a personal opinion here... I don't believe in such canned tests because they're not testing for what I want to see in a Developer or DBA.
--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:38 pm

#1261341
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

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