Jeff Moden

Forum Replies Created

Viewing 15 posts - 44,566 through 44,580 (of 59,101 total)

RE: How do I extract information from a string

If the formatting of each element is pretty much cast in stone, then a straight forward method may be in order...
Here's the test data...
--===== Create a demonstration table (This is...
--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 16, 2009 at 11:14 pm

#960794
RE: BULK INSERT problems

It's going to be tough to troubleshoot this without some test data and a listing of the code that does the Bulk Insert. If the data has private information...
--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 16, 2009 at 10:20 pm

#960781
RE: comparing results of 2 views

harish_ravi (3/16/2009)
Thanks for your reply. i verified it was working gr8.
but i dont think its working for comparing data with duplicate values.
like the below.
DECLARE @v1 TABLE (id INT, txt VARCHAR(100))
DECLARE...
--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 16, 2009 at 10:17 pm

#960780
RE: NEED HELP URGENT (MLB)

Heh... "Survey says... ding, ding, ding, ding, ding... STUFF! Look it up in Books Online". Bruce is spot on.
--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 16, 2009 at 10:08 pm

#960777
RE: Using IN clause for and double type field in table

"Teach a man to fish and..."
All of your questions are answered in the following two articles...
http://www.sqlservercentral.com/articles/TSQL/62867/
http://www.sqlservercentral.com/articles/T-SQL/63003/
--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 16, 2009 at 10:06 pm

#960776
RE: A theoretical flat file database, how could it work well?

I think that it's funny as hell that anyone would call an XML file a "flat file". 😉
Before I even knew SQL Server existed and the small company 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 16, 2009 at 9:51 pm

#960772
RE: Query to get Last month's Data

You bet... thanks for the feedback. 🙂
--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 16, 2009 at 9:29 pm

#960766
RE: sp_msforeachdb

Mike Levan (3/16/2009)
How could i list size of all databases in (MB/GB) in a server.
Mike Levan (3/16/2009)
I am using this for table count in each db, is there a way...
--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 16, 2009 at 8:12 pm

#960744
RE: Query to get Last month's Data

Oh yeah..l. I forgot. Never use BETWEEN for date comparisons of this nature because you never know when someone is going to include a time in the column along...
--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 16, 2009 at 7:26 pm

#960729
RE: Query to get Last month's Data

[font="Courier New"] WHERE yourdatecolumn >= DATEADD(mm,DATEDIFF(mm,0,GETDATE())-1,0)
AND yourdatecolumn < DATEADD(mm,DATEDIFF(mm,0,GETDATE()),0)[/font]
--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 16, 2009 at 7:25 pm

#960728
RE: String Manipulation

Goldie Graber (3/16/2009)
Jeff Moden (3/16/2009)
One of your requirements was to ....
4. Replace all entity codes (“&xxx;”) with X
If you "smear" that requirement across...
--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 16, 2009 at 6:15 pm

#960713
RE: String Manipulation

Goldie Graber (3/16/2009)
Jeff Moden (3/16/2009)
Goldie Graber (3/16/2009)
I can't seem to get better performance than my original function.
I'm pasting it here for future reference.
Do you have the code for the new...
--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 16, 2009 at 6:05 pm

#960711
RE: String Manipulation

Goldie Graber (3/16/2009)
I can't seem to get better performance than my original function.
I'm pasting it here for future reference.
Do you have the code for the new function... I know 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)

March 16, 2009 at 3:12 pm

#960622
RE: String Manipulation

RBarryYoung (3/16/2009)
Jeff, do you have a test set for this?
Only the "single line" of HTML Goldie previously attached a couple of posts back...
--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 16, 2009 at 3:10 pm

#960619
RE: Are the posted questions getting worse?

Bob Hovious (3/15/2009)
I truly hope that his MVP wasn't awarded solely for participation. When I was a child, schools often handed out awards for perfect attendance. ...
--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 16, 2009 at 9:30 am

#960350

Viewing 15 posts - 44,566 through 44,580 (of 59,101 total)