Jeff Moden

Forum Replies Created

Viewing 15 posts - 43,456 through 43,470 (of 59,102 total)

RE: Check given number

anandhakrishnabca (6/12/2009)
Hi,
I want to validate the given number. how to check for the following requirements in sql server 2005
1) how to...
--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)

June 12, 2009 at 10:25 pm

#1008998
RE: How to add new column to an existing table while inserting values

srikale (6/11/2009)
Hi ,
I want to insert a new column , check while inserting values.
For example : I have a table TBL with 2 columns , but...
--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)

June 12, 2009 at 10:22 pm

#1008997
RE: Query seems very slow for what its doing

I'm not sure why people think they need to do everything in a single query. Use the input parameters to get only the data you need from the properties...
--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)

June 12, 2009 at 10:11 pm

#1008995
RE: How to get Saturday b/w two dates

Just in case...
[font="Courier New"] SELECT DATEADD(wk,DATEDIFF(wk,-2,'07/13/2008')+t.Number,-2)
   FROM Master.dbo.spt_Values t
  WHERE t.Type = 'P'
    AND t.Number < DATEDIFF(wk,'07/13/2008','08/13/2008')+1
    AND DATEADD(wk,DATEDIFF(wk,-2,'07/13/2008')+t.Number,-2) <= '08/13/2008'[/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)

June 12, 2009 at 9:49 pm

#1008993
Reply To: Does SQL Server 2000 has a 'WITH' CLAUSE

No... SQL Server 2000 doesn't have WITH/CTE. Instead, use a "Derived Table" which is nearly identical in most cases. A derived table is just like a CTE in that it's...
--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)

June 12, 2009 at 9:39 pm

#1008988
RE: Can you manipulate field names programmatically ?

darryl (6/12/2009)
Greetings once again.
I am working on some sql to be used in a report. I have a transaction table called prtrxp. This table has about 100 fields....
--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)

June 12, 2009 at 9:31 pm

#1008986
RE: Which Rows in Cursor?

Ok... problem solved... you think. A better question is, what are you using a cursor for?
--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)

June 12, 2009 at 9:23 pm

#1008985
RE: Test your problem solving skills!

I believe I'd tell the manager off. It's not his neck if data is inappropriately deleted... it's mine.
I would insist on moving the data to a subdirectory off 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)

June 12, 2009 at 9:22 pm

#1008984
RE: Determining the number of business days between two dates

If all you want is to calculate week days, there's a very short function at the following article.
http://www.sqlservercentral.com/articles/Advanced+Querying/calculatingworkdays/1660/
If you want work days instead of week days, I suggest...
--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)

June 12, 2009 at 9:06 pm

#1008982
RE: BETWEEN keyword versus =

Paul McCurdy (6/12/2009)
Stupid me - ypu're absolutely right!
value1 >= value2 AND value1 <= value3
was quicker by a few seconds than
value1 BETWEEN value2 AND value3
I know, not my understanding either and...
--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)

June 12, 2009 at 9:00 pm

#1008981
RE: Need to export column headings with stored procedure

siboyd07 (6/10/2009)
I managed to come up with a solution. I don't know if it's the best but it will work. Basically we have an import utility that imported...
--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)

June 12, 2009 at 8:06 pm

#1008975
RE: O(n) , O(n log n), O(n^2)

RBarryYoung (6/10/2009)
Jeff Moden (6/10/2009)
If you strip away all the small stuff that won't impact the result much when the numbers get really big, you end up with O(N²/2). That's...
--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)

June 12, 2009 at 7:49 pm

#1008972
RE: charindex help

Terri (6/10/2009)
Good explanation Jeff. A small point, your solution fails if there is more than 1 space between the 2 words. e.g 'Lincoln Lincoln' has length 16. ...
--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)

June 12, 2009 at 7:36 pm

#1008969
RE: Differences between Unicode Text and ASCII text file

RBarryYoung (6/11/2009)
Jeff Moden (6/10/2009)
RBarryYoung (6/10/2009)
What you should be able to see however is that the Unicode .sql file is about twice the size of the Ascii one.
Any idea if SQL...
--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)

June 12, 2009 at 7:17 pm

#1008967
RE: Mining for Quitters

GSquared (6/11/2009)
So far as I can tell, that's pretty much been the end result of every one of our disagreements. It's just a matter of clarification.
Heh... I concur... but...
--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)

June 12, 2009 at 7:07 pm

#1008965

Viewing 15 posts - 43,456 through 43,470 (of 59,102 total)