Jeff Moden

Forum Replies Created

Viewing 15 posts - 30,691 through 30,705 (of 59,101 total)

RE: how to write for loop and cursor in sql server

er.sivaganesh (3/20/2012)
ya it was working fine
but why u and jef told don't use cursor
Three reasons for me...
1. They're usually slower 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)

March 20, 2012 at 6:33 am

#1461570
RE: Disable and enable trigger

Jizzy Wig (3/20/2012)
What utter nonsense
Thanks for the example and no problem with disagreement but you really don't need to be that way.
Yes, if you have an explicit transaction or your...
--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 20, 2012 at 6:18 am

#1461559
RE: Coding Standards

Artoo22 (3/19/2012)
Jared, do me a favour please. Find sp_spaceused and modify it. What do you think? Good code laid out badly.
My opinion of sp_spaceused is "bad code laid out poorly"....
--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 19, 2012 at 10:46 pm

#1461441
RE: resarting row number based on values in categories

umar.memon (3/19/2012)
Solved the probelm, thank you so much for the guidance you have provided I really learned alot, never used CTE and Outer Apply before
once again thanks
Actually, you may 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)

March 19, 2012 at 9:59 pm

#1461436
RE: Coding Standards

Artoo22 (3/19/2012)
Hi,
I don't need assistance today, but I have a comment. Why doesn't Microsoft use T-SQL coding standards?
Whenever I script a system stored proc the code looks like a dogs...
--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 19, 2012 at 5:43 pm

#1461398
RE: Tabs or Spaces

MarbryHardin (3/19/2012)
Tabs, all the way.
Saying that you want to use spaces because people will write improperly formatted code is a hack. Tabs have the same usefulness and purpose 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)

March 19, 2012 at 5:39 pm

#1461397
RE: Tabs or Spaces

SQLRNNR (3/19/2012)
Nadrek (3/18/2012)
My answer to tabs vs. spaces, case convention, and pre vs post commas is always to let a computer do tedious, menial, purely rules based work - use...
--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 19, 2012 at 5:30 pm

#1461396
RE: Sum up certain accounts accross period

dwain.c (3/18/2012)
Jeff,
That's a very interesting article and it has described what I could not articulate in my dislike for correlated subqueries. I intrinsically knew that there would be a...
--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 19, 2012 at 9:05 am

#1461173
RE: TSQL Challenge 78 - Parse single field into multiple fields

I know it's just a contest and a lot of the problems are made up but I really worry about things like this. Judging from the number of people...
--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 19, 2012 at 8:10 am

#1461142
RE: best book for sql server

nikk_Stone (9/10/2011)
thnx...
but the book which you have told me...it is not free of cost...
i have to buy it online...
i want a frre book
Books Online. It covers all aspects 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)

March 19, 2012 at 1:58 am

#1461001
RE: TSQL Challenge 78 - Parse single field into multiple fields

This is another contest problem where the best solution wouldn't likely be an "all in one" query.
--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 19, 2012 at 1:50 am

#1461000
RE: sql_variant

Yep... I know this is an old post but I've just gone through an escapade with SQL_Variant with great success.
I agree that the "one table" idea is typically a very...
--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 17, 2012 at 4:54 pm

#1460909
RE: how to find no of row and column from a table?

Having a bit of a problem with the broken English but I believe this might be what you're looking for.
SELECT MemberID,
RowsOwned...
--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 17, 2012 at 1:46 pm

#1460897
RE: Storing Year only in SQL Server 2008

revozex (3/17/2012)
Hi Fellow Members,
I have Human Resource data containing many records with years only in Date of Birth column. Currently I'm storing 01-01-1967 if only 1967 is given as year.
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)

March 17, 2012 at 1:10 pm

#1460890
RE: how to write for loop and cursor in sql server

er.sivaganesh (3/17/2012)
alter PROCEDURE [dbo].[SP_Searchengine]
@VALUES varchar(8000)
AS
BEGIN
create table solution
(
AdSpaceId int,
AdInfoId int,
BusinessName varchar(200),
AdSpaceName ...
--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 17, 2012 at 1:04 pm

#1460889

Viewing 15 posts - 30,691 through 30,705 (of 59,101 total)