Jeff Moden

Forum Replies Created

Viewing 15 posts - 41,041 through 41,055 (of 59,102 total)

RE: running total

chandreshgeria (11/24/2009)
sir ,
Depend on party turnover if 2 rows return two rows and if 200000 return 200000 with running total
Perhaps you don't understand. I'm trying...
--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)

November 24, 2009 at 9:15 am

#1083528
RE: Convert searched String to number

Heh... you're faster than I am..
Yes, in 2k you just swing the CTE's down into the FROM clause as "derived tables" and you've basically got the same thing. Well...
--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)

November 24, 2009 at 8:37 am

#1083493
RE: tempdb - understanding unallocated space

Heh... you're doing one of the worst things possible. I don't know how big your TempDB was before you started shrinking it but set it to 10% larger than...
--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)

November 23, 2009 at 11:21 pm

#1083296
RE: Large Number of Tables (1,090,000)

Actually, I'd run like hell.
--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)

November 23, 2009 at 11:15 pm

#1083294
RE: any one no where to place these 3 below statements in a CURSOR to find get info on the cursor

Dave Ballantyne (11/23/2009)
Something like this ?
Nicely done Dave. 🙂 I'll just bet that the OP's bosses will remain unswayed, though, because they probably can't figure out how it equates...
--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)

November 23, 2009 at 11:00 pm

#1083285
RE: Documentation on db work

You really should try Googling for stuff like this.
--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)

November 23, 2009 at 10:44 pm

#1083275
RE: Lengthy procedure vs Split procedure

ManoharV (11/23/2009)
Hi All,
Will there be any differences in terms of execution if i write complex functionality in single procedure or can i split them into multiple procedures.
Nope......
--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)

November 23, 2009 at 10:32 pm

#1083269
RE: Creating simple dynamic sql

You don't need dynamic sql for this...
a. SELECT * FROM Movies WHERE MovieID = @MovieID
b. SELECT * FROM Movies WHERE MovieName = @MovieName
The only time you need really need dynamic...
--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)

November 23, 2009 at 10:22 pm

#1083265
RE: why there is need of integration service?

why integration services are required ?
BWAAA-HAAAA!!!! I keep asking myself the same question. 😉
--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)

November 23, 2009 at 10:16 pm

#1083262
RE: Exporting Data to CSV file

becklery (11/22/2009)
Hi.
I think you can refer to the url below:
http://www.dotnetspider.com/resources/701-Export-Data-CSV-Excel.aspx
Heh... not exactly a T-SQL 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)

November 23, 2009 at 10:13 pm

#1083260
RE: Exporting Data to CSV file

sqlbuddy123 (11/23/2009)
Hi,
Again I got a small problem. Actually in the output .csv file 70% of rows are good but in...
--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)

November 23, 2009 at 10:10 pm

#1083259
RE: CSV Files

Jus,
I do imports in a manner similar to what you code does. I just keep running into DBA's that don't know how to protect their system and still allow...
--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)

November 23, 2009 at 10:06 pm

#1083256
RE: Reading CSV file a line at a time using uftReadfileAsTable

smithsp17 (11/23/2009)
Hi,
I have CSV files which I'd like to load into a table using the function uftReadfileAsTable. (http://xpns.net/Examples/uftReadFileAsTable.txt). I've been able to read the first line, but am...
--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)

November 23, 2009 at 9:45 pm

#1083252
RE: Update HELP

cm62597 (11/23/2009)
I have phone numbers store in my database....I am trying to create a test database that makes all the phone numbers random instead of the real ones. 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)

November 23, 2009 at 9:37 pm

#1083245
RE: Update HELP

BWAA-HAAA!!!!! C'mon guys... the cited function requires that you feed it a random number and you guys say "generate a 10 digit random number". But both of those...
--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)

November 23, 2009 at 9:21 pm

#1083241

Viewing 15 posts - 41,041 through 41,055 (of 59,102 total)