Jeff Moden

Forum Replies Created

Viewing 15 posts - 47,896 through 47,910 (of 59,095 total)

RE: 'N' number of usage - Tally Table

I've used it for "cleaning" data... you know... remove all numbers, remove everything but the numbers, remove special characters, remove adjacent multiple spaces (although there are better ways 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)

October 7, 2008 at 6:56 am

#881602
RE: get last iserted records

Jeff Moden (10/7/2008)
karthikeyan (10/6/2008)
if you have datetime column in your table, then select max(datetime column) from will give you the expected result.
No... if someone happens to do an...
--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)

October 7, 2008 at 6:41 am

#881598
RE: Social Hacks

I'll use a quote that I heard a long time ago... "The internet is a well paved on-ramp to a dirt road." If you put personal information out there,...
--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)

October 7, 2008 at 6:40 am

#881597
RE: Few interview questions

Ahmad Osama (10/7/2008)
Hi All,
Here are few interview questions..
1) Is it possible to have a NULL value in a foreign key field?
Already been answered several times...
2) If I have 350 columns...
--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)

October 7, 2008 at 6:20 am

#881586
RE: How much it is feasible to store the photograph of Visitor in table?

My preference is to store the JPG.s in a directory and store the file name in the server for such a requirement. The reason for this is that it...
1....
--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)

October 7, 2008 at 6:04 am

#881578
RE: get last iserted records

dr_csharp (10/6/2008)
GilaMonster (10/6/2008)
DECLARE @MaxID INT
SELECT @MaxID = Max(ID) FROM Customer
which one is better :
i save @@Identity in a field when record insert in Table and i read saved id...
--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)

October 7, 2008 at 5:48 am

#881568
RE: Passing array To Stored Procedure

vidhyasudha (10/5/2008)
Hello,
Can we pass array to t-sql procedure? If so how.
Cheers
As well as the link Vijaya posted, please check out the following, as well...
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)

October 7, 2008 at 5:42 am

#881562
RE: Passing array To Stored Procedure

proudfoot.richard (10/7/2008)
Works in 2000, but I'm not sure that this works in 2005 which no longer permits table variables to be returned to a calling stored procedure?
I got round 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)

October 7, 2008 at 5:40 am

#881559
RE: Computation for running Difference

Clint,
This is a "running balance" or "running total" problem and there are lots of methods to pull it off including some really slow triangular joins, cursors, and While loops. ...
--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)

October 7, 2008 at 5:30 am

#881555
RE: Exclude Word List to filter SELECT results

Sure... the criteria to add to your query would be ...
WHERE yada-yada
AND Location NOT LIKE (SELECT '%'+Word+'%' dbo.FROM ExcludeTable)
--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)

October 7, 2008 at 5:23 am

#881551
RE: combining multiple rows into one

zypsy (10/6/2008)
i have got the table i want by running something like
SELECT billdate,custcode,custname,
MAX(CASE WHEN Seq=1 THEN brand ELSE NULL END) AS brand,
MAX(CASE WHEN Seq=1 THEN item ELSE NULL...
--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)

October 7, 2008 at 5:16 am

#881548
RE: The South African SQL Server Usergroup is Back

Have the time? Heh, what did you do? Make a clone? 🙂
--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)

October 7, 2008 at 4:41 am

#881534
RE: The South African SQL Server Usergroup is Back

I saw the title of this one and immediately thought "Hmmm... I'll just bet Gail is at the heart of this announcement."
--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)

October 6, 2008 at 9:38 pm

#881419
RE: Organizations With No DBAs

Dang! I'm not sure how it happened, but I missed the whole gambit of 9/22 posts! Very well stated, folks. Well done.
And, you, Mr. Burrows, have never...
--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)

October 6, 2008 at 9:32 pm

#881418
RE: Date range to also compute previous date per no. of days

clint_pow (10/6/2008)
Hi,
Its really amazing how it goes, I really appreciated it at last I can incorporated it with some of my query. How I wish I have a knowledge 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)

October 6, 2008 at 9:26 pm

#881416

Viewing 15 posts - 47,896 through 47,910 (of 59,095 total)