Jeff Moden

Forum Replies Created

Viewing 15 posts - 33,916 through 33,930 (of 59,099 total)

RE: newbie to sql server

Hi i am a developer in sql server. can any one suggest me what i shall learn next for bright career
Actually, yes we can. 🙂 Post (or attach 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)

May 15, 2011 at 5:46 pm

#1324822
RE: need help in Pivot query

roshanmaugustine (5/10/2011)
Hi All ,
I have a table with columns
ProjectID ,YearofOperation WeekNo,PorjectParameterSchedule, ProjectParameterScope,ProjectParameterResources,ProjectParameterQuality
1 2011 18 2 10 5 18
1 2011 19 6 8 9 45
1 2011 20 9 10...
--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)

May 15, 2011 at 5:26 pm

#1324815
RE: need help in grouping cyclic rows

CELKO (5/12/2011)
CREATE VIEW Foobar (country_name, col_1, col_2)
AS
SELECT DISTINCT country_name,
CASE WHEN col_1 <= col_2 THEN col_1 ELSE col_2 END AS col_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)

May 15, 2011 at 5:18 pm

#1324813
RE: Is NTILE OVER (PARTITION BY .. running total..) possible?

TheSQLGuru (5/3/2011)
That is by far the biggest shortcoming SQL Server has IMNSHO.
Unless you count the fact that there is no split function, no function to generate sequential numbers or dates...
--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)

May 15, 2011 at 5:14 pm

#1324812
RE: Is NTILE OVER (PARTITION BY .. running total..) possible?

ChrisM@home (5/2/2011)
This is probably the simplest set-based solution.
Oh... be careful, Chris. Apologies for quibbling but a Recursive CTE isn't set-based. It's a form of hidden RBAR which can...
--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)

May 15, 2011 at 5:01 pm

#1324810
RE: How to add new partitions automatically to a table when new quarter started.

Ah... I finally get the irony of your post, Remi. 🙂
--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)

May 15, 2011 at 4:53 pm

#1324808
RE: Store Procedure OutPut Column name

the_hichamus (5/15/2011)
Hi Everyone,
This is my first time posting on this forum.
DECLARE @LoginG as uniqueidentifier = (select l.LoginGUID from login l inner join EmailQueue eq on eqo.OriginatingColumnValue = l.LoginID...
--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)

May 15, 2011 at 4:50 pm

#1324807
RE: What is up with the "Hey Kid Classification"?

I would imagine for the very reason you quoted. I also believe that the classification has been around for a very long time and that you've just not noticed...
--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)

May 15, 2011 at 4:47 pm

#1324806
RE: How to add new partitions automatically to a table when new quarter started.

Ninja's_RGR'us (5/15/2011)
:w00t:
What link is that Jeff?
Looks like you're catching up the backlog of e-mails or something... thread ended over 10 days ago!
Heh... Considering this OP has reposted the same question...
--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)

May 15, 2011 at 4:34 pm

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

Tom.Thomson (5/15/2011)
Jeff Moden (5/14/2011)
It would be very interesting, indeed, if there were a true relational database that some of the people touting the attributes of relational databases could try. ...
--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)

May 15, 2011 at 4:22 pm

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

Tom.Thomson (5/15/2011)
Well, I agree that APL is probably a horror in this context; but the other two? If they count as horrors, then surely so must C#, and 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)

May 15, 2011 at 3:46 pm

#1324789
RE: Are the posted questions getting worse?

In the area of "are the posted articles getting worse"...
I realize that it's an older article but isn't the word "Automatic" and code with hard-coded dates a bit of 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)

May 15, 2011 at 12:23 pm

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

peter-757102 (5/15/2011)
...I ran into a disturbing issue that caused me to give up in frustration.
Time for some beer popsicles and a long chat with the dust bunnies. 😛
In short, 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)

May 15, 2011 at 12:10 pm

#1324742
RE: How to add new partitions automatically to a table when new quarter started.

theunique1011 (5/4/2011)
Thank you for reply. i couldn't find in Books online. can you please write code for me to delete quarter data and add new partition automatically.
No... please see 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)

May 15, 2011 at 11:36 am

#1324730
RE: How to add new partitions automatically to a table when new quarter started.

theunique1011 (5/3/2011)
Can you explain me how to create a job to add and delete partitions automatically?
Yes... please see the link that SQL Kiwi provided above.
--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)

May 15, 2011 at 11:35 am

#1324728

Viewing 15 posts - 33,916 through 33,930 (of 59,099 total)