Jeff Moden

Forum Replies Created

Viewing 15 posts - 51,946 through 51,960 (of 59,091 total)

RE: Help with Year calculations

alorenzini (3/10/2008)
That worked fine. Thanks.
See above and reconsider how much hell you will go through if any of the dates ever come in with a time other than midnight... 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)

March 10, 2008 at 2:58 pm

#787620
RE: Help with Year calculations

Lynn Pettis (3/10/2008)
Jeff, since the OP wants the end of the year wouldn't you want this:
SELECT @startdate = CAST('2007' AS DATETIME)
SELECT @enddate = DATEADD(yy,1,CAST('2007' AS DATETIME)) - 1
I know why...
--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)

March 10, 2008 at 2:56 pm

#787619
RE: Need help with selecting primary key!

There are, of course, exceptions to every rule... but most people name a table after what a single row in the table holds. For example, the Customer table would...
--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)

March 10, 2008 at 2:51 pm

#787611
RE: Is it possible to do it in one query?

First, I thought you said the "records" looked like this...
PunchIn, PunchOut, Break, PunchIn, Punchout.
Second... are your really happy with the solution? Try it with multiple days...
USE tempdb
go
Create Table Punches(empid...
--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)

March 10, 2008 at 2:32 pm

#787599
RE: Re-arrainge a character field

dan (3/10/2008)
Some dates appear as '20080310' and others appear as '10/03/2008'.
I have been asked to make all the dates appear consistently, as '20080310'. I've tried several variations of this:
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)

March 10, 2008 at 2:06 pm

#787589
RE: Need help with selecting primary key!

I have an OrderLookup table, where the PK is the PurchaseOrderID.
You actually named a table "OrderLookup" to hold Purchase Orders and gave it a Primary Key on a column called...
--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)

March 10, 2008 at 1:49 pm

#787572
RE: how to design audit trail

Will C2 Auditing help in this area?
--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)

March 10, 2008 at 1:45 pm

#787569
RE: how to design

Ummmm... let me get this straight... you got a job as a designer and you don't really know how to design?
--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)

March 10, 2008 at 1:43 pm

#787567
RE: Help with Year calculations

SELECT CAST('2007' AS DATETIME)
SELECT DATEADD(yy,1,CAST('2007' AS DATETIME))
--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)

March 10, 2008 at 1:42 pm

#787566
RE: The Daily Routine

Oral meds? Lucky... at least they weren't supositories 😉
--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)

March 10, 2008 at 7:00 am

#787336
RE: Bulk Move between Databases

michael.esposito (3/10/2008)
Thanks all...but it seems BCP and BULK INSERT require the data to come from data files, not an instance of SQL. Is there a way to copy it 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)

March 10, 2008 at 6:54 am

#787334
RE: Removing double quotes from colum names with cvs export

Could be done in plain ol' T-SQL... but would require either a trip through xp_CmdShell or would need to be called externally in a batch file.
--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)

March 10, 2008 at 6:50 am

#787332
RE: How to order by in this case?

Heh... yeah... I can see that... my question would be why? And if what you say were true, why list all of the users instead of just the most...
--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)

March 10, 2008 at 6:42 am

#787325
RE: BCP problems (SQL2K)

Markus2006 (3/10/2008)
In the first version I was using native format but than I found out that national charactes are not transferred correctly despite the fact that I provided correct code...
--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)

March 10, 2008 at 6:27 am

#787314
RE: Create table with number of columns in a parameter

nicolas.pages (3/10/2008)
All right, thanks for that answer. The only thing is I am using sql server 2000, so i need to look if pivoting tables is possible there, 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)

March 10, 2008 at 6:24 am

#787312

Viewing 15 posts - 51,946 through 51,960 (of 59,091 total)