Jeff Moden

Forum Replies Created

Viewing 15 posts - 53,116 through 53,130 (of 59,089 total)

RE: How to Subtract timespan from datetime

Assuming that "TimeElapsed" is of the DateTime datatype...
SELECT currDt = GETDATE()-TimeElapsed
--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 4, 2008 at 9:46 pm

#765043
RE: How can i export data in execel file in predefined excel format...

3 pages starting at...
http://www.sql-server-helper.com/tips/read-import-excel-file-p01.aspx
--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 4, 2008 at 9:37 pm

#765041
RE: which scripting language does sqlservercentral uses ?

Incomplete sentence... "Which scripting language does..."
What's the rest of 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)

January 4, 2008 at 9:29 pm

#765040
RE: Minimum (Approx) & Maximum (Approx) Salary in Google

Heh... "google 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)

January 4, 2008 at 9:28 pm

#765039
RE: how to merge 2 databases

And then there's the subject of primary keys... especially if they're based on IDENTITY.
--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 4, 2008 at 9:27 pm

#765037
RE: BTW(By The Way)

OIDK... WFM! 😛
--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 4, 2008 at 9:25 pm

#765036
RE: When to use cascade deletes/updates

Heh... deletes make me nervous, anyway... constitutes some form of lost data. I don't use cascade deletes because I want people to have to work at doing deletes. ...
--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 4, 2008 at 9:19 pm

#765035
RE: Date string in WHERE causes table scan instead of index seek

If memory serves correctly, I believe that form of index hint is "deprecated". Try this, instead...
select ACCT_NUM, OPERATOR_NUM, BRANCH_NUM
from TRANS_J_DATA_FULL WITH (INDEX(IX_TRAN_FULL))
where TRANS_DATE >= @dStartDate and TRANS_DATE <= @dEndDate...
--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 4, 2008 at 9:16 pm

#765034
RE: Check if temporary table exists or not?

Don't use either... use the functions built for this...
1. Check if temp table exists...
IF OBJECT_ID('TempDB..#temptablename','U') IS NOT NULL
PRINT 'Table Exists'
...
--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 4, 2008 at 8:38 pm

#765029
RE: Julian dates

Heh... in other words, there's no such thing as a Julian date of "107999"... can only go up to 107365... next day would be 108001.
With that in mind, the following...
--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 4, 2008 at 8:13 pm

#765022
RE: Bulk insert from excel 2003 failed

How did it help? What was 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)

January 4, 2008 at 7:59 pm

#765019
RE: can anyone give me an example of using current_timestamp / current_user in bcp format file?

Never import directly to the final destination table... import into a staging table... should be able to use a default on a staging table but, if not, just update the...
--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 4, 2008 at 7:57 pm

#765018
RE: user stored proc parameter finder

Two way street here... please share your solution.
--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 4, 2008 at 7:48 pm

#765016
RE: Creating a Phone Book / Horse Blanket type thing...

Heh... do you intend to print that size sheet?
--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 4, 2008 at 7:44 pm

#765015
RE: Index Tuning

Test the code in the presence of the indexes and not... that's the only real way to tell.
--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 4, 2008 at 7:34 pm

#765014

Viewing 15 posts - 53,116 through 53,130 (of 59,089 total)