Jeff Moden

Forum Replies Created

Viewing 15 posts - 30,706 through 30,720 (of 59,101 total)

RE: Get month names ordered using recursion

the sqlist (3/15/2012)
Jeff Moden (3/15/2012)
My point is that you do need to kill the flys or the resulting swarm will result in posts like "Why is my database running so...
--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 10:15 am

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

Kingston Dhasian (3/17/2012)
Jeff Moden (3/16/2012)
er.sivaganesh (3/16/2012)
thanks for every one who joined in this discussion i just solved this problem by creating ...
--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 8:47 am

#1460867
RE: rows into columns

You bet. If you get the chance, let us know how it pans out for you.
--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, 2012 at 11:48 pm

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

er.sivaganesh (3/16/2012)
thanks for every one who joined in this discussion i just solved this problem by creating cusor in my store...
--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, 2012 at 11:42 pm

#1460831
RE: Aggregating multiple columns into 1

CELKO (3/16/2012)
>> I have a table containing some customers names and the amounts they have spent per month. <<
You have no idea what first normal form means and that...
--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, 2012 at 11:32 pm

#1460830
RE: Covert rows into a comma delimited string

manjunath.dacca (3/16/2012)
Written a query which returns as shown below
BagalkotBadamiR.B.Patil
BagalkotBadamiSunil Kambar
The result expected is
BagalkotBadamiR.B.Patil,Sunil Kambar
how to do this?
You'll find your answer at the following excellent link written by wayne Sheffield.
http://www.sqlservercentral.com/articles/comma+separated+list/71700/
--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, 2012 at 11:27 pm

#1460829
RE: Constraint to prevent UPDATE after row is committed

Ah, understood. I was going by what you had posted for code.
Shifting gears a bit, I'm concerned about your "busy" Temp DB. This is frequently caused by things...
--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, 2012 at 9:41 am

#1460594
RE: logic explanation

capn.hector (3/16/2012)
Jeff,
Depending on the application would using the created on date for the first modified date be better than some future date?
so in the above query it would be rewritten
select...
--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, 2012 at 9:27 am

#1460584
RE: Tally OH! An Improved SQL 8K “CSV Splitter” Function

These types of problems with VM are typically are not code related. A lot of folks setup VM to move resources to and from SQLServer servers and, when such...
--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, 2012 at 9:22 am

#1460581
RE: Sum up certain accounts accross period

dwain.c (3/15/2012)
Here's another solution:
;WITH PLYTD AS (
SELECT Account, Organization, Period, [Year]
,(SELECT SUM(Amount) FROM @acct a2
WHERE a1.Account = a2.Account and a1.Organization = a2.Organization and a1.[Year] = a2.[Year] and
a2.Period <= a1.Period
) As...
--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, 2012 at 7:45 am

#1460507
RE: logic explanation

As written, it also creates a performance problem because it will never use an INDEX SEEK. This type of predicate is frequently referred to as a "non-SARGable" predicate. ...
--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, 2012 at 7:23 am

#1460491
RE: Tally OH! An Improved SQL 8K “CSV Splitter” Function

Apologies... I have no clue what the problem could be. We have a VM environment at work and it screams.
--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, 2012 at 7:14 am

#1460484
RE: CTE( common table expression)

p.s.
The word "dude" isn't always a complimentary one. You might want to avoid it's 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 16, 2012 at 6:56 am

#1460468
RE: CTE( common table expression)

manub22 (3/15/2012)
This also saves us creating multiple sub-queries if required in a SQL statement. Like if your are self-joining 2 same sub-queries, you only need to create a single CTE...
--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, 2012 at 6:55 am

#1460465
RE: Sum a column for a set of Trees on a Recursive Table

Oh... be careful, now. That only works if each top level item only has a straight trunk instead of a tree. Run the code with the following data...
--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, 2012 at 6:35 am

#1460452

Viewing 15 posts - 30,706 through 30,720 (of 59,101 total)