Jeff Moden

Forum Replies Created

Viewing 15 posts - 40,696 through 40,710 (of 59,070 total)

RE: Manipulating Decimal Format 0000000090.00000

Ah, dang it. Sometimes I hate BOL... the STR function that I looked at to get the return type was for SQL Server Mobile. Why on Earth 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)

December 10, 2009 at 7:47 pm

#1090960
RE: Cannot bulk import CSV file with double quotes

support 23368 (12/10/2009)
no need to change the CSV file but looking at the query it appears that it may work slower.
Heh... slower than what? The 2 days it took...
--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, 2009 at 7:40 pm

#1090959
RE: Can anyone verify this please??

doran_doran (12/10/2009)
Little Lost here..
BWAA-HAAA!!! Apparently, so I am! :blush: My response was supposed to go on another post that I was looking at at almost the same time.
--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, 2009 at 7:28 pm

#1090955
RE: Replace cursor with while loop / compare cursor with while loop / optimize cursor

clive-421796 (12/10/2009)
Hi Lynn, instead of using:
WHERE
tbl.YourDateColumn >= @StartDate
AND tbl.YourDateColumn < @EndDate
I prefer to use:
WHERE
tbl.YourDateColumn between @StartDate AND @EndDate.
-------------------------
Have...
--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, 2009 at 7:05 pm

#1090946
RE: Get Last Name, First name and Middle Name from Full Name

Here's a bit of code for SQL Server 2000 that's equivalent to the 2k5 code I "cheated" with.:-D It uses "derived tables" instead of CTE's. Both are sometimes...
--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, 2009 at 6:50 pm

#1090945
RE: spliting the data using replace function

Thanks, Anitha :blush:
--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, 2009 at 6:34 pm

#1090941
RE: Get Last Name, First name and Middle Name from Full Name

Heh... try hell! I did cheat! I just got caught. :blush:
--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, 2009 at 6:29 pm

#1090939
RE: Replace cursor with while loop / compare cursor with while loop / optimize cursor

clive-421796 (12/10/2009)
Hi Jeff, I dont use winzip, I use winrar. Tried to download winzip, guess what ?
version 14 (latest) is 37 MB. So i looked for winzip 9 (about 4MB),...
--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, 2009 at 6:15 pm

#1090936
RE: spliting the data using replace function

Ok... here you go. You need to study this, Anitha, because every string like this follows a similar pattern of FieldName:fieldvalue fieldterminator. You should be able to do...
--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, 2009 at 5:58 pm

#1090931
RE: Substring column

Ah... now I see what you're trying to do.
--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, 2009 at 3:56 pm

#1090918
RE: Replace cursor with while loop / compare cursor with while loop / optimize cursor

Lynn Pettis (12/10/2009)
Jeff Moden (12/10/2009)
clive-421796 (12/10/2009)
Cant open a .rar (winrar) file ? Ah come on Jeff, never heard of anyone working in IT for years that does 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 10, 2009 at 3:28 pm

#1090906
RE: Replace cursor with while loop / compare cursor with while loop / optimize cursor

clive-421796 (12/10/2009)
Cant open a .rar (winrar) file ? Ah come on Jeff, never heard of anyone working in IT for years that does not have winrar installed. Go...
--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, 2009 at 3:21 pm

#1090899
RE: Get Last Name, First name and Middle Name from Full Name

n.heyen (12/10/2009)
Thank you Jeff -
When I copy and paste and run this code, I get errors. Is this SQL2000 code? Or does it need SQL2005?
The errors are:
Msg 156, Level...
--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, 2009 at 2:51 pm

#1090880
RE: Replace cursor with while loop / compare cursor with while loop / optimize cursor

TheSQLGuru (12/10/2009)
I haven't checked for certain Jeff, but I have seen these types of manipulations make proper dates for range queries:
SET @ldtStartDate = ISNULL(@dStartDate,DATEADD(month,-1,DATEADD(mm, DATEDIFF(mm,0,GETDATE()), 0)))
SET @ldtEndDate = ISNULL(@dEndDate,DATEADD(ms, -3,...
--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, 2009 at 9:22 am

#1090651
RE: What do I do now? (have fun with this...)

I was thinking the same thing, Gus... that's why I posted the retrospective. It took me a while but I remembered running into someone like this 10 or...
--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, 2009 at 9:19 am

#1090648

Viewing 15 posts - 40,696 through 40,710 (of 59,070 total)