Jeff Moden

Forum Replies Created

Viewing 15 posts - 52,816 through 52,830 (of 59,098 total)

RE: 2005

... and, if you're really smart, do a backup first.
--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 20, 2008 at 7:26 am

#769991
RE: create a table with a variable name!

You will need to use some form of dynamic SQL...
DECLARE @TableName SYSNAME
SET @TableName = 'sometablename'
EXEC ('CREATE TABLE '+@TableName+' put rest of create here')
I guess I'm really worried about why 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)

January 20, 2008 at 7:25 am

#769990
RE: add at the same time delete

Going to another site for your files is a PITA... it would be much better if you'd just attach the files to your post.
The files are JSP files... I'm 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)

January 20, 2008 at 7:21 am

#769989
RE: SYNTAX ERROR USING PARAMETERS

Replace this part of the code...
/*
EXEC EDI..prcCreditCardCampaign '2008-01-14 00:00:00:000','2008-01-18 23:59:59:999'
EXEC EDI..prcCreditCardCampaign NULL,NULL
*/
IF OBJECT_ID('prcCreditCardCampaign') IS NOT NULL
DROP PROC prcCreditCardCampaign
GO
CREATE PROC prcCreditCardCampaign
@FromDate DATETIME = NULL,
@ToDate DATETIME = NULL
AS
SET NOCOUNT...
--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 20, 2008 at 7:12 am

#769988
RE: How to return a LOT of other columns with group by

Heh... "Flat file cleanup on aisle 5"!
Are you all set, Kirk? Did Mark's post do what you needed (looks like it but thougt I'd double check)?
--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 19, 2008 at 8:35 pm

#769982
RE: Issue with date field calculations

No, no... it won't fail if the IGNORE DUPLICATES option is turned on for the unique index. It will just give a warning that at least one duplicate was...
--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 19, 2008 at 7:46 pm

#769980
RE: locking an entire table

You have no error detection code and no rollback code... and SET XACTABORT has not been turned on to make up for it...
... so why do you need a transaction...
--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 19, 2008 at 7:40 pm

#769979
RE: How to return a LOT of other columns with group by

I've seen requests like this before and they always puzzle me... it would appear that the name should be the primary key in this case. Yet, you have 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)

January 19, 2008 at 7:34 pm

#769978
RE: Using WAITFOR DELAY

waitfor usage can bring an entire application to a grinding halt in an instant:
Not sure what you mean... how?
--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 19, 2008 at 7:29 pm

#769976
RE: I got a job but .....

If you do it right, more than you can possibly imagine...
--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 19, 2008 at 7:25 pm

#769974
RE: ExecuteWithResults

The following URL has a lot of good information about Excel spreadsheets and ADODB... perhaps it'll have what you're looking for...
http://www.simple-talk.com/sql/t-sql-programming/sql-server-excel-workbench/
--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 19, 2008 at 6:56 am

#769935
RE: DBCC PINTABLE - What is actually pinned

Also, not sure why you'd bother pinning it... it will certainly fit in cache.
--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 18, 2008 at 7:44 pm

#769920
RE: TempDB is 13gigs and growing

17GB seems a bit large even if it's a Terabyte instance... if folks are using triangular joins, cursors for large record sets, temp tables for large record sets, views of...
--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 18, 2008 at 7:41 pm

#769919
RE: BULK INSERT & Text Qualifier

remember this code was done based on BOL examples, but I don't remember the topic.
First, nice idea... hadn't thought about doing it that way. Great way to import...
--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 18, 2008 at 7:07 pm

#769918
RE: BULK INSERT & Text Qualifier

Sergiy (1/14/2008)
All of you are wrong.
Using "," as delimites is an error waiting to happen.
mdjtlj, ask you supplier to build a test file containing '19" Monitor'.
Then try to process 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 18, 2008 at 7:05 pm

#769917

Viewing 15 posts - 52,816 through 52,830 (of 59,098 total)